RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where bioproject = "PRJNA939415", tax_kingdom = "Thermotogati" and tax_phylum = "Synergistota"

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Synergistota · 4 ✖

tax_kingdom 1

  • Thermotogati · 4 ✖

bioproject 1

  • PRJNA939415 · 4 ✖

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
14943464 14943464 PRJNA939415_P_NODE_44832_length_289_cov_1.236111_g44410_i0 PRJNA939415 44832 289 1.236111 3.57236079 Bacteria 2 Bacteria Bacteria 98.6 3.129999999999999e-23   NR WP_037974020.1 2754 g44410 i0 48.2 8.57439446366782 85 44 88.2 0 280 26 28 112 WP_037974020.1 acetyltransferase [Synergistes jonesii] diamond 2478 99 0.995959595959596 Bacteria   Thermotogati Synergistota Synergistia Synergistales Synergistaceae Synergistes Synergistes jonesii
17494765 17494765 PRJNA939415_P_NODE_95474_length_241_cov_1.642857_g95052_i0 PRJNA939415 95474 241 1.642857 3.95928537 Jonquetella anthropi 428712 Bacteria Bacteria 115 2.73e-21   NTclustered gi|194410714|gb|EU840722.1| 428712 g95052 i0 77.72 19.4771784232365 193 39 80 4 1 192 219 408 Jonquetella anthropi strain E3_33 23S ribosomal RNA gene, partial sequence blastn 4694 115 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Jonquetella Jonquetella anthropi
27941217 27941217 PRJNA939415_P_NODE_69525_length_264_cov_2.753927_g69103_i0 PRJNA939415 69525 264 2.753927 7.27036728 Acetomicrobium sp. 1872099 Bacteria Bacteria 71.2 3.78e-12   NR WP_332635803.1 1872099 g69103 i0 50.8 0.715909090909091 63 30 70.5 1 186 1 1 63 WP_332635803.1 glycosyltransferase family 4 protein [Acetomicrobium sp.] diamond 189 71.2 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Acetomicrobiaceae Acetomicrobium Acetomicrobium sp.
31700270 31700270 PRJNA939415_P_NODE_89877_length_245_cov_5.104651_g89455_i0 PRJNA939415 89877 245 5.104651 12.50639495 Jonquetella 428711 Bacteria Bacteria 55.1 1.66e-6   NR WP_008519799.1 428711 g89455 i0 96.4 0.342857142857143 28 1 34.3 0 162 245 1 28 WP_008519799.1 MULTISPECIES: hypothetical protein [Jonquetella] diamond 84 55.1 1 Bacteria   Thermotogati Synergistota Synergistia Synergistales Dethiosulfovibrionaceae Jonquetella  

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);;