RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA393181" and tax_phylum = "Vulcanimicrobiota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Vulcanimicrobiota · 11 ✖

tax_kingdom 1

bioproject 1

  • PRJNA393181 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
410470 410470 PRJNA393181_S_NODE_28581_length_211_cov_2.436782_g28475_i0 PRJNA393181 28581 211 2.436782 5.14161002 Candidatus Cybelea sp. 2952917 Bacteria Bacteria 67.8 2.8e-12   NR HYM30214.1 2952917 g28475 i0 58.3 0.682464454976303 48 20 68.2 0 145 2 88 135 HYM30214.1 tetratricopeptide repeat protein [Candidatus Cybelea sp.] diamond 144 67.8 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
15105995 15105995 PRJNA393181_S_NODE_10092_length_380_cov_2.364431_g9986_i0 PRJNA393181 10092 380 2.364431 8.9848378 Candidatus Cybelea sp. 2952917 Bacteria Bacteria 114 3.4900000000000006e-27   NR HYM33183.1 2952917 g9986 i0 55 2.04473684210526 129 53 98.7 3 378 4 252 379 HYM33183.1 nitrate/sulfonate/bicarbonate ABC transporter ATP-binding protein [Candidatus Cybelea sp.] diamond 777 114 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
24636914 24636914 PRJNA393181_S_NODE_3100_length_608_cov_2.942207_g3012_i0 PRJNA393181 3100 608 2.942207 17.88861856 Bacteria 2 Bacteria Bacteria 244 1.33e-78   NR HYM30922.1 2952917 g3012 i0 68.3 5.32401315789474 180 56 88.3 1 538 2 22 201 HYM30922.1 helix-turn-helix domain-containing protein [Candidatus Cybelea sp.] diamond 3237 244 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
25304700 25304700 PRJNA393181_S_NODE_35540_length_183_cov_2.047945_g35434_i0 PRJNA393181 35540 183 2.047945 3.74773935 Candidatus Cybelea sp. 2952917 Bacteria Bacteria 60.5 1.84e-9   NR HYM31984.1 2952917 g35434 i0 51.7 0.983606557377049 60 25 91.8 1 9 176 93 152 HYM31984.1 hypothetical protein [Candidatus Cybelea sp.] diamond 180 60.5 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
26695349 26695349 PRJNA393181_S_NODE_36121_length_181_cov_1.972222_g36015_i0 PRJNA393181 36121 181 1.972222 3.56972182 Candidatus Baltobacteraceae bacterium 3107660 Bacteria Bacteria 57 9.39e-8   NR HTX53815.1 2952909 g36015 i0 75 0.662983425414365 40 10 66.3 0 1 120 194 233 HTX53815.1 phosphatase PAP2 family protein [Candidatus Baltobacteraceae bacterium] diamond 120 57 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae   Candidatus Baltobacteraceae bacterium
27169857 27169857 PRJNA393181_S_NODE_10422_length_374_cov_2.418398_g10316_i0 PRJNA393181 10422 374 2.418398 9.04480852 Candidatus Cybelea sp. 2952917 Bacteria Bacteria 79.7 1.39e-14   NR HYM31155.1 2952917 g10316 i0 58.8 1.6283422459893 68 28 54.5 0 4 207 331 398 HYM31155.1 CoA transferase [Candidatus Cybelea sp.] diamond 609 79.7 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
27881746 27881746 PRJNA393181_S_NODE_14625_length_315_cov_2.428058_g14519_i0 PRJNA393181 14625 315 2.428058 7.6483827 Bacteria 2 Bacteria Bacteria 78.2 1.56e-14   NR HVO00968.1 2952917 g14519 i0 78.4 2.92380952380952 51 11 48.6 0 314 162 271 321 HVO00968.1 ABC transporter permease [Candidatus Cybelea sp.] diamond 921 78.2 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
28591290 28591290 PRJNA393181_S_NODE_45467_length_155_cov_1.983051_g45361_i0 PRJNA393181 45467 155 1.983051 3.07372905 Candidatus Cybelea sp. 2952917 Bacteria Bacteria 68.2 1.02e-11   NR HYM31387.1 2952917 g45361 i0 59.6 0.909677419354839 47 19 91 0 15 155 155 201 HYM31387.1 2OG-Fe(II) oxygenase [Candidatus Cybelea sp.] diamond 141 68.2 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
29349063 29349063 PRJNA393181_S_NODE_33249_length_191_cov_3.032468_g33143_i0 PRJNA393181 33249 191 3.032468 5.79201388 Candidatus Lustribacter sp. 3069335 Bacteria Bacteria 45.8 0.00153   NR HEV8022820.1 3069335 g33143 i0 65.8 0.596858638743455 38 13 59.7 0 115 2 1 38 HEV8022820.1 response regulator [Candidatus Lustribacter sp.] diamond 114 45.8 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Lustribacter Candidatus Lustribacter sp.
31086393 31086393 PRJNA393181_S_NODE_8255_length_416_cov_2.976253_g8149_i0 PRJNA393181 8255 416 2.976253 12.38121248 Candidatus Elarobacter sp. 3047550 Bacteria Bacteria 57 2.3e-6   NR HEY0383590.1 3047550 g8149 i0 38.4 1.46394230769231 86 39 62 1 261 4 70 141 HEY0383590.1 hypothetical protein [Candidatus Elarobacter sp.] diamond 609 57 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Elarobacter Candidatus Elarobacter sp.
31908624 31908624 PRJNA393181_S_NODE_43277_length_160_cov_2.219512_g43171_i0 PRJNA393181 43277 160 2.219512 3.5512192 Candidatus Cybelea sp. 2952917 Bacteria Bacteria 45.8 9.99e-4   NR HYM33184.1 2952917 g43171 i0 52.4 0.7875 42 19 76.9 1 124 2 21 62 HYM33184.1 ABC transporter permease subunit [Candidatus Cybelea sp.] diamond 126 45.8 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea 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);;