RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA543299", tax_kingdom = "Bacillati" and tax_phylum = "Mycoplasmatota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Mycoplasmatota · 8 ✖

tax_kingdom 1

  • Bacillati · 8 ✖

bioproject 1

  • PRJNA543299 · 8 ✖

tax_clade 0

Link rowid ▼ query bioproject node length coverage rel_abundance taxname_lca taxid_lca taxoncategory taxoncategorysimple bits evalue lowcoverage_flag analysis_used target taxid gene allele pident sumperc_cov alnlen mismatch qcov gapopen qstart qend tstart tend target_title analysis sumalnlen maxbits bits_percmax tax_superkingdom tax_clade tax_kingdom tax_phylum tax_class tax_order tax_family tax_genus tax_species
22186566 22186566 PRJNA543299_P_NODE_7678_length_267_cov_1.169725_g7521_i0 PRJNA543299 7678 267 1.169725 3.12316575 Mycoplasma phocoeninasale 2726117 Bacteria Bacteria 172 1.7999999999999998e-38   NTclustered gi|148616230|gb|EF591066.1| 2726117 g7521 i0 85.455 57.250936329588 165 24 62 0 2 166 222 386 Mycoplasma phocoeninasale strain CSL 5364 elongation factor tu gene, partial cds blastn 15286 172 1 Bacteria   Bacillati Mycoplasmatota Mollicutes Mycoplasmatales Mycoplasmataceae Mycoplasma Mycoplasma phocoeninasale
28183073 28183073 PRJNA543299_P_NODE_20506_length_167_cov_0.864407_g20349_i0 PRJNA543299 20506 167 0.864407 1.44355969 Mycoplasmopsis arginini 2094 Bacteria Bacteria 95.9 5.4e-23   NR WP_282459906.1 2094 g20349 i0 90.9 0.988023952095808 55 5 98.8 0 167 3 48 102 WP_282459906.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 165 95.9 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29036026 29036026 PRJNA543299_P_NODE_19008_length_172_cov_1.658537_g18851_i0 PRJNA543299 19008 172 1.658537 2.85268364 Mycoplasmopsis arginini 2094 Bacteria Bacteria 112 7.449999999999999e-31   NR WP_282459023.1 2094 g18851 i0 100 0.976744186046512 56 0 97.7 0 170 3 17 72 WP_282459023.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 168 112 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29288294 29288294 PRJNA543299_P_NODE_23989_length_163_cov_0.894737_g23832_i0 PRJNA543299 23989 163 0.894737 1.45842131 Mycoplasmopsis arginini 2094 Bacteria Bacteria 55.8 2.59e-8   NR MDI3349620.1 2094 g23832 i0 62.2 0.680981595092024 37 14 68.1 0 111 1 1 37 MDI3349620.1 hypothetical protein [Mycoplasmopsis arginini] diamond 111 55.8 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29540880 29540880 PRJNA543299_P_NODE_11890_length_217_cov_1.214286_g11733_i0 PRJNA543299 11890 217 1.214286 2.63500062 Mycoplasmopsis arginini 2094 Bacteria Bacteria 131 1.4599999999999998e-37   NR MDI3349447.1 2094 g11733 i0 100 0.981566820276498 71 0 98.2 0 3 215 11 81 MDI3349447.1 hypothetical protein [Mycoplasmopsis arginini] diamond 213 131 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
29920095 29920095 PRJNA543299_P_NODE_26831_length_155_cov_2.405660_g26674_i0 PRJNA543299 26831 155 2.40566 3.728773 Mycoplasmopsis arginini 2094 Bacteria Bacteria 99.4 8.04e-26   NR WP_282459096.1 2094 g26674 i0 100 1.9741935483871 51 0 98.7 0 153 1 21 71 WP_282459096.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 306 99.4 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
31025860 31025860 PRJNA543299_P_NODE_20075_length_167_cov_2.584746_g19918_i0 PRJNA543299 20075 167 2.584746 4.31652582 Mycoplasmopsis arginini 2094 Bacteria Bacteria 121 1.99e-33   NR MDI3349615.1 2094 g19918 i0 100 0.988023952095808 55 0 98.8 0 166 2 102 156 MDI3349615.1 CCA-adding enzyme [Mycoplasmopsis arginini] diamond 165 121 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini
32544270 32544270 PRJNA543299_P_NODE_21699_length_166_cov_0.871795_g21542_i0 PRJNA543299 21699 166 0.871795 1.4471797 Mycoplasmopsis arginini 2094 Bacteria Bacteria 104 7.18e-28   NR WP_282459184.1 2094 g21542 i0 100 0.939759036144578 52 0 94 0 165 10 28 79 WP_282459184.1 hypothetical protein, partial [Mycoplasmopsis arginini] diamond 156 104 1 Bacteria   Bacillati Mycoplasmatota   Mycoplasmoidales Metamycoplasmataceae Mycoplasmopsis Mycoplasmopsis arginini

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

CREATE TABLE contig_metadata(query VARCHAR, bioproject VARCHAR, node VARCHAR, length VARCHAR, coverage VARCHAR, rel_abundance VARCHAR, taxname_lca VARCHAR, taxid_lca VARCHAR, taxoncategory VARCHAR, taxoncategorysimple VARCHAR, bits VARCHAR, evalue VARCHAR, lowcoverage_flag VARCHAR, analysis_used VARCHAR, "target" VARCHAR, taxid VARCHAR, gene VARCHAR, allele VARCHAR, pident VARCHAR, sumperc_cov VARCHAR, alnlen VARCHAR, mismatch VARCHAR, qcov VARCHAR, gapopen VARCHAR, qstart VARCHAR, qend VARCHAR, tstart VARCHAR, tend VARCHAR, target_title VARCHAR, analysis VARCHAR, sumalnlen VARCHAR, maxbits VARCHAR, bits_percmax VARCHAR, tax_superkingdom VARCHAR, tax_clade VARCHAR, tax_kingdom VARCHAR, tax_phylum VARCHAR, tax_class VARCHAR, tax_order VARCHAR, tax_family VARCHAR, tax_genus VARCHAR, tax_species VARCHAR);;