RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJNA1123436" and tax_phylum = "Vulcanimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Vulcanimicrobiota · 6 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1123436 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
8682422 8682422 PRJNA1123436_P_NODE_118507_length_244_cov_0.900585_g117293_i0 PRJNA1123436 118507 244 0.900585 2.1974274 Candidatus Tumulicola sp. 3069698 Bacteria Bacteria 140 1.18e-37   NR HEY1655168.1 3069698 g117293 i0 82.5 0.983606557377049 80 14 98.4 0 3 242 190 269 HEY1655168.1 arylsulfatase [Candidatus Tumulicola sp.] diamond 240 140 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Tumulicola Candidatus Tumulicola sp.
16856101 16856101 PRJNA1123436_P_NODE_109834_length_246_cov_1.560694_g108620_i0 PRJNA1123436 109834 246 1.560694 3.83930724 Candidatus Baltobacteraceae bacterium 3107660 Bacteria Bacteria 162 3.68e-48   NR HEY9180254.1 2952909 g108620 i0 92.7 4 82 6 100 0 246 1 101 182 HEY9180254.1 hypothetical protein [Candidatus Baltobacteraceae bacterium] diamond 984 162 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
27418159 27418159 PRJNA1123436_P_NODE_97943_length_250_cov_0.870056_g96729_i0 PRJNA1123436 97943 250 0.870056 2.17514 Candidatus Elarobacter sp. 3047550 Bacteria Bacteria 94 2.22e-21   NR HTD25762.1 3047550 g96729 i0 65.9 1.956 82 28 98.4 0 1 246 135 216 HTD25762.1 HAD-IA family hydrolase [Candidatus Elarobacter sp.] diamond 489 94 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Elarobacter Candidatus Elarobacter sp.
30512498 30512498 PRJNA1123436_P_NODE_104893_length_248_cov_0.880000_g103679_i0 PRJNA1123436 104893 248 0.88 2.1824 Candidatus Cybelea sp. 2952917 Bacteria Bacteria 107 1.78e-27   NR HYM30698.1 2952917 g103679 i0 67.1 1.8508064516129 76 25 91.9 0 230 3 76 151 HYM30698.1 hypothetical protein [Candidatus Cybelea sp.] diamond 459 107 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
32093357 32093357 PRJNA1123436_P_NODE_87638_length_264_cov_1.057592_g86424_i0 PRJNA1123436 87638 264 1.057592 2.79204288 Candidatus Baltobacteraceae bacterium 3107660 Bacteria Bacteria 52 2.48e-5   NR HTX55255.1 2952909 g86424 i0 33.7 1.01136363636364 89 53 97.7 2 1 258 204 289 HTX55255.1 hypothetical protein [Candidatus Baltobacteraceae bacterium] diamond 267 52 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
32473260 32473260 PRJNA1123436_P_NODE_47619_length_363_cov_1.417241_g46405_i0 PRJNA1123436 47619 363 1.417241 5.14458483 Candidatus Lustribacter sp. 3069335 Bacteria Bacteria 115 2.4699999999999996e-29   NR HEX2704480.1 3069335 g46405 i0 94.7 0.471074380165289 57 3 47.1 0 5 175 147 203 HEX2704480.1 transposase [Candidatus Lustribacter sp.] diamond 171 115 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Lustribacter Candidatus Lustribacter sp.

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