RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA658591" and tax_kingdom = "Bacillati"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_kingdom 1

  • Bacillati · 13 ✖

bioproject 1

  • PRJNA658591 · 13 ✖

analysis 1

  • diamond · 13 ✖
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
16464228 16464228 PRJNA658591_S_NODE_3473_length_237_cov_24.473404_g3410_i0 PRJNA658591 3473 237 24.473404 58.00196748 Candidatus Obscuribacterales bacterium 2364082 Bacteria Bacteria 144 8.16e-42   NR MBX9724270.1 2364082 g3410 i0 88.5 0.987341772151899 78 9 98.7 0 236 3 21 98 MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium] diamond 234 144 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Candidatus Melainabacteria   Candidatus Obscuribacterales     Candidatus Obscuribacterales bacterium
17203466 17203466 PRJNA658591_S_NODE_2974_length_252_cov_1.704433_g2911_i0 PRJNA658591 2974 252 1.704433 4.29517116 Stanieria cyanosphaera PCC 7437 111780 Bacteria Bacteria 130 1.08e-34   NR CAC81002.1 111780 g2911 i0 82.9 0.976190476190476 82 14 97.6 0 251 6 208 289 CAC81002.1 NAD-dependent glyceraldehyde-3-phosphate dehydrogenase (phosphorylating), partial [Stanieria cyanosphaera PCC 7437] diamond 246 130 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Pleurocapsales Dermocarpellaceae Stanieria Stanieria cyanosphaera
27397599 27397599 PRJNA658591_S_NODE_2703_length_262_cov_13.535211_g2640_i0 PRJNA658591 2703 262 13.535211 35.46225282 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 133 7.07e-36   NR MBX9694561.1 2847862 g2640 i0 74.7 0.99618320610687 87 21 98.5 1 260 3 87 173 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 261 133 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
27555107 27555107 PRJNA658591_S_NODE_5764_length_197_cov_1.108108_g5701_i0 PRJNA658591 5764 197 1.108108 2.18297276 Leifsonia sp. Leaf264 1736314 Bacteria Bacteria 44.3 0.0059   NR WP_055905398.1 1736314 g5701 i0 38.5 0.989847715736041 65 35 99 1 1 195 191 250 WP_055905398.1 hypothetical protein [Leifsonia sp. Leaf264] diamond 195 44.3 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Microbacteriaceae Leifsonia Leifsonia sp. Leaf264
28186560 28186560 PRJNA658591_S_NODE_6246_length_191_cov_1.077465_g6183_i0 PRJNA658591 6246 191 1.077465 2.05795815 Actinotalea sp. JY-7885 2758576 Bacteria Bacteria 42.4 0.0255   NR WP_188037768.1 2758576 g6183 i0 41.8 0.863874345549738 55 27 81.7 3 35 190 196 248 WP_188037768.1 hypothetical protein, partial [Actinotalea sp. JY-7885] diamond 165 42.4 1 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Cellulomonadaceae Actinotalea Actinotalea sp. JY-7885
28988617 28988617 PRJNA658591_S_NODE_10368_length_162_cov_0.858407_g10305_i0 PRJNA658591 10368 162 0.858407 1.39061934 Bacillati 1783272 Bacteria Bacteria 41.6 0.0316   NR HLX25562.1 2952917 g10305 i0 42.9 1.51851851851852 42 23 75.9 1 39 161 357 398 HLX25562.1 peptide ABC transporter substrate-binding protein [Candidatus Cybelea sp.] diamond 246 41.6 1 Bacteria   Bacillati Vulcanimicrobiota Vulcanimicrobiia Vulcanimicrobiales Vulcanimicrobiaceae Candidatus Cybelea Candidatus Cybelea sp.
29291845 29291845 PRJNA658591_S_NODE_6529_length_188_cov_1.122302_g6466_i0 PRJNA658591 6529 188 1.122302 2.10992776 Actinocrispum sp. NPDC 1891916 Bacteria Bacteria 60.5 9.95e-9   NR WP_364762316.1 3154835 g6466 i0 60.7 0.893617021276596 56 22 89.4 0 184 17 414 469 WP_364762316.1 glycoside hydrolase family 3 C-terminal domain-containing protein [Actinocrispum sp. NPDC049592] diamond 168 60.5 1 Bacteria   Bacillati Actinomycetota Actinomycetes Pseudonocardiales Pseudonocardiaceae Actinocrispum Actinocrispum sp. NPDC049592
29904145 29904145 PRJNA658591_S_NODE_4191_length_221_cov_3.720930_g4128_i0 PRJNA658591 4191 221 3.72093 8.2232553 Micrococcales 85006 Bacteria Bacteria 66.2 1.23e-10   NR WP_307102463.1 1665 g4128 i0 62.5 4.6289592760181 48 18 65.2 0 78 221 3 50 WP_307102463.1 NAD(P)-dependent alcohol dehydrogenase [Arthrobacter globiformis] diamond 1023 66.6 0.993993993993994 Bacteria   Bacillati Actinomycetota Actinomycetes Micrococcales Micrococcaceae Arthrobacter Arthrobacter globiformis
30112873 30112873 PRJNA658591_S_NODE_8932_length_168_cov_2.445378_g8869_i0 PRJNA658591 8932 168 2.445378 4.10823504 Cyanobacteriota bacterium 2847862 Bacteria Bacteria 47 4.34e-4   NR MBX9694561.1 2847862 g8869 i0 64.1 0.696428571428571 39 10 62.5 1 114 10 15 53 MBX9694561.1 hypothetical protein [Cyanobacteriota bacterium] diamond 117 47 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota         Cyanobacteriota bacterium
30586737 30586737 PRJNA658591_S_NODE_5093_length_206_cov_2.292994_g5030_i0 PRJNA658591 5093 206 2.292994 4.72356764 Anaerolineales bacterium 2073117 Bacteria Bacteria 66.6 8.67e-11   NR HND47414.1 2073117 g5030 i0 56.5 0.902912621359223 62 27 90.3 0 202 17 652 713 HND47414.1 hypothetical protein [Anaerolineales bacterium] diamond 186 66.6 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
30851831 30851831 PRJNA658591_S_NODE_2474_length_272_cov_1.488789_g2411_i0 PRJNA658591 2474 272 1.488789 4.04950608 Bacteria 2 Bacteria Bacteria 91.3 4.58e-19   NR HEY3021937.1 2586742 g2411 i0 47.6 3.68382352941176 84 44 92.6 0 21 272 575 658 HEY3021937.1 hypothetical protein [Solirubrobacteraceae bacterium] diamond 1002 91.7 0.995637949836423 Bacteria   Bacillati Actinomycetota Thermoleophilia Solirubrobacterales Solirubrobacteraceae   Solirubrobacteraceae bacterium
30966216 30966216 PRJNA658591_S_NODE_10034_length_163_cov_1.596491_g9971_i0 PRJNA658591 10034 163 1.596491 2.60228033 uncultured Chloroflexota bacterium 166587 Bacteria Bacteria 43.1 0.00901   NR CAA9302627.1 166587 g9971 i0 44.2 0.791411042944785 43 21 79.1 1 21 149 304 343 CAA9302627.1 MAG: hypothetical protein AVDCRST_MAG77-5794 [uncultured Chloroflexota bacterium] diamond 129 43.1 1 Bacteria   Bacillati Chloroflexota         uncultured Chloroflexota bacterium
32199530 32199530 PRJNA658591_S_NODE_7018_length_183_cov_1.164179_g6955_i0 PRJNA658591 7018 183 1.164179 2.13044757 Jaaginema sp. PMC 1080.18 2684452 Bacteria Bacteria 63.2 1.01e-9   NR MEC4805688.1 2684452 g6955 i0 61.7 0.770491803278688 47 18 77 0 42 182 270 316 MEC4805688.1 glutamyl-tRNA reductase [Jaaginema sp. PMC 1080.18] diamond 141 63.2 1 Bacteria Cyanobacteriota/Melainabacteria group Bacillati Cyanobacteriota Cyanophyceae Leptolyngbyales Leptolyngbyaceae Jaaginema Jaaginema sp. PMC 1080.18

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