RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

22 rows where analysis = "diamond", bioproject = "PRJEB30004" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 22 ✖

tax_kingdom 1

bioproject 1

  • PRJEB30004 · 22 ✖

analysis 1

  • diamond · 22 ✖

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
20439523 20439523 PRJEB30004_P_NODE_362817_length_244_cov_3.102439_g347190_i0 PRJEB30004 362817 244 3.102439 7.56995116 Candidatus Limnocylindrales bacterium 2952938 Bacteria Bacteria 79 1.92e-16   NR HEU5205134.1 2952938 g347190 i0 61.2 2.61885245901639 67 26 82.4 0 44 244 1 67 HEU5205134.1 GntR family transcriptional regulator [Candidatus Limnocylindrales bacterium] diamond 639 79 1 Bacteria   Bacillati Chloroflexota Candidatus Limnocylindria Candidatus Limnocylindrales     Candidatus Limnocylindrales bacterium
21721911 21721911 PRJEB30004_P_NODE_495178_length_193_cov_1.396104_g479551_i0 PRJEB30004 495178 193 1.396104 2.69448072 Chloroflexota bacterium 2026724 Bacteria Bacteria 102 7.93e-25   NR MCC6178170.1 2026724 g479551 i0 78.3 6.45077720207254 60 13 93.3 0 14 193 22 81 MCC6178170.1 polyphosphate kinase 2 [Chloroflexota bacterium] diamond 1245 102 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
26931853 26931853 PRJEB30004_P_NODE_682182_length_151_cov_1.714286_g666555_i0 PRJEB30004 682182 151 1.714286 2.58857186 Bacteria 2 Bacteria Bacteria 91.3 8.53e-20   NR HEV3309432.1 2026724 g666555 i0 88 1.98675496688742 50 6 99.3 0 1 150 560 609 HEV3309432.1 FAD-linked oxidase C-terminal domain-containing protein [Chloroflexota bacterium] diamond 300 91.7 0.995637949836423 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
27064815 27064815 PRJEB30004_P_NODE_302242_length_280_cov_1.966805_g286615_i0 PRJEB30004 302242 280 1.966805 5.507054 Chloroflexota bacterium 2026724 Bacteria Bacteria 169 1.41e-48   NR HEX6508864.1 2026724 g286615 i0 80.6 0.996428571428571 93 18 99.6 0 280 2 191 283 HEX6508864.1 long-chain-fatty-acid--CoA ligase [Chloroflexota bacterium] diamond 279 169 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
27760165 27760165 PRJEB30004_P_NODE_434704_length_213_cov_1.557471_g419077_i0 PRJEB30004 434704 213 1.557471 3.31741323 Caldilineaceae bacterium 2614250 Bacteria Bacteria 118 4.75e-29   NR MEZ4617933.1 2614250 g419077 i0 75.7 1.97183098591549 70 17 98.6 0 211 2 170 239 MEZ4617933.1 RHS repeat-associated core domain-containing protein [Caldilineaceae bacterium] diamond 420 118 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae   Caldilineaceae bacterium
27823169 27823169 PRJEB30004_P_NODE_183544_length_403_cov_2.285714_g167933_i0 PRJEB30004 183544 403 2.285714 9.21142742 Chloroflexota bacterium 2026724 Bacteria Bacteria 220 1.41e-63   NR MDQ6673653.1 2026724 g167933 i0 78.4 2.07692307692308 139 24 99 3 400 2 683 821 MDQ6673653.1 LLM class flavin-dependent oxidoreductase [Chloroflexota bacterium] diamond 837 220 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
27886088 27886088 PRJEB30004_P_NODE_399425_length_227_cov_1.744681_g383798_i0 PRJEB30004 399425 227 1.744681 3.96042587 Anaerolineae bacterium 2052143 Bacteria Bacteria 132 1.87e-36   NR MCC6801234.1 2052143 g383798 i0 88.4 2.73568281938326 69 8 91.2 0 1 207 174 242 MCC6801234.1 ATP-binding protein [Anaerolineae bacterium] diamond 621 132 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
28100500 28100500 PRJEB30004_P_NODE_467805_length_201_cov_2.092593_g452178_i0 PRJEB30004 467805 201 2.092593 4.20611193 Bacteria 2 Bacteria Bacteria 98.6 4.59e-22   NR HLZ10037.1 2026724 g452178 i0 68.2 2.95522388059702 66 21 98.5 0 2 199 258 323 HLZ10037.1 two-component regulator propeller domain-containing protein [Chloroflexota bacterium] diamond 594 98.6 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28479613 28479613 PRJEB30004_P_NODE_688046_length_150_cov_1.738739_g672419_i0 PRJEB30004 688046 150 1.738739 2.6081085 Bacillati 1783272 Bacteria Bacteria 70.9 1.23e-12   NR MBV9791075.1 2026724 g672419 i0 70.2 7.18 47 14 94 0 143 3 1646 1692 MBV9791075.1 amino acid adenylation domain-containing protein [Chloroflexota bacterium] diamond 1077 71.2 0.995786516853933 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28644087 28644087 PRJEB30004_P_NODE_344927_length_254_cov_1.627907_g329300_i0 PRJEB30004 344927 254 1.627907 4.13488378 Ktedonobacterales bacterium 2306968 Bacteria Bacteria 43.1 0.0312   NR HKS69084.1 2306968 g329300 i0 82.1 0.330708661417323 28 5 33.1 0 85 2 1 28 HKS69084.1 hydrogenase 4 subunit B [Ktedonobacterales bacterium] diamond 84 43.1 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales     Ktedonobacterales bacterium
30159396 30159396 PRJEB30004_P_NODE_363332_length_244_cov_2.087805_g347705_i0 PRJEB30004 363332 244 2.087805 5.0942442 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 48.1 4.66e-4   NR MCC6386707.1 2026734 g347705 i0 53.8 0.959016393442623 39 18 48 0 241 125 340 378 MCC6386707.1 protein kinase [Dehalococcoidia bacterium] diamond 234 48.1 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
30633397 30633397 PRJEB30004_P_NODE_293533_length_286_cov_2.234818_g277906_i0 PRJEB30004 293533 286 2.234818 6.39157948 Herpetosiphonaceae bacterium 2720503 Bacteria Bacteria 106 1.43e-24   NR MBA3943638.1 2720503 g277906 i0 58.2 5.86363636363636 91 38 95.5 0 277 5 52 142 MBA3943638.1 diaminopimelate decarboxylase [Herpetosiphonaceae bacterium] diamond 1677 106 1 Bacteria   Bacillati Chloroflexota Chloroflexia Herpetosiphonales Herpetosiphonaceae   Herpetosiphonaceae bacterium
30785025 30785025 PRJEB30004_P_NODE_611174_length_164_cov_2.384000_g595547_i0 PRJEB30004 611174 164 2.384 3.90976 FCB group 1783270 Bacteria Bacteria 70.5 2.06e-12   NR MBN2549712.1 2073117 g595547 i0 57.4 3.95121951219512 54 23 98.8 0 2 163 136 189 MBN2549712.1 beta-lactamase family protein [Anaerolineales bacterium] diamond 648 71.2 0.990168539325843 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
30918117 30918117 PRJEB30004_P_NODE_430794_length_214_cov_2.594286_g415167_i0 PRJEB30004 430794 214 2.594286 5.55177204 Chloroflexota bacterium 2026724 Bacteria Bacteria 58.5 1.45e-9   NR MDQ3466956.1 2026724 g415167 i0 76.3 0.532710280373832 38 9 53.3 0 213 100 11 48 MDQ3466956.1 transcriptional regulator [Chloroflexota bacterium] diamond 114 58.5 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31076044 31076044 PRJEB30004_P_NODE_505495_length_190_cov_1.357616_g489868_i0 PRJEB30004 505495 190 1.357616 2.5794704 Chloroflexota bacterium 2026724 Bacteria Bacteria 100 1.06e-23   NR HEX6508478.1 2026724 g489868 i0 76.2 2.98421052631579 63 15 99.5 0 189 1 42 104 HEX6508478.1 winged helix-turn-helix domain-containing protein [Chloroflexota bacterium] diamond 567 100 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31518724 31518724 PRJEB30004_P_NODE_381556_length_235_cov_2.301020_g365929_i0 PRJEB30004 381556 235 2.30102 5.407397 Chloroflexota bacterium 2026724 Bacteria Bacteria 102 2.3399999999999994e-23   NR HLZ07472.1 2026724 g365929 i0 71.8 3.01276595744681 78 22 99.6 0 234 1 526 603 HLZ07472.1 chitobiase/beta-hexosaminidase C-terminal domain-containing protein [Chloroflexota bacterium] diamond 708 102 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31993093 31993093 PRJEB30004_P_NODE_553638_length_177_cov_1.782609_g538011_i0 PRJEB30004 553638 177 1.782609 3.15521793 Anaerolineae bacterium 2052143 Bacteria Bacteria 97.1 1.18e-21   NR MCD6289033.1 2052143 g538011 i0 66.1 1.94915254237288 59 20 100 0 177 1 180 238 MCD6289033.1 glycoside hydrolase family 78 protein [Anaerolineae bacterium] diamond 345 97.1 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
32018206 32018206 PRJEB30004_P_NODE_361078_length_245_cov_2.388350_g345451_i0 PRJEB30004 361078 245 2.38835 5.8514575 Bacteria 2 Bacteria Bacteria 69.3 4.08e-13   NR HEY1292831.1 2026724 g345451 i0 50 2.20408163265306 64 32 78.4 0 16 207 30 93 HEY1292831.1 endonuclease [Chloroflexota bacterium] diamond 540 69.7 0.994261119081779 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32088025 32088025 PRJEB30004_P_NODE_636438_length_159_cov_2.733333_g620811_i0 PRJEB30004 636438 159 2.733333 4.34599947 Anaerolineales bacterium 2073117 Bacteria Bacteria 79.7 2.24e-16   NR MCK5794276.1 2073117 g620811 i0 62.3 1 53 20 100 0 1 159 167 219 MCK5794276.1 DUF4143 domain-containing protein [Anaerolineales bacterium] diamond 159 79.7 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
32372947 32372947 PRJEB30004_P_NODE_321399_length_268_cov_1.410480_g305772_i0 PRJEB30004 321399 268 1.41048 3.7800864 Chloroflexota bacterium 2026724 Bacteria Bacteria 153 4.4e-41   NR HEX6510597.1 2026724 g305772 i0 86.4 1.97014925373134 88 12 98.5 0 266 3 453 540 HEX6510597.1 alpha-L-arabinofuranosidase C-terminal domain-containing protein [Chloroflexota bacterium] diamond 528 153 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32814503 32814503 PRJEB30004_P_NODE_500480_length_191_cov_2.105263_g484853_i0 PRJEB30004 500480 191 2.105263 4.02105233 Anaerolineae bacterium 2052143 Bacteria Bacteria 77 8.89e-15   NR MBZ0299947.1 2052143 g484853 i0 63.6 2.62303664921466 55 20 86.4 0 170 6 38 92 MBZ0299947.1 SDR family oxidoreductase [Anaerolineae bacterium] diamond 501 77 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
32877476 32877476 PRJEB30004_P_NODE_575260_length_172_cov_1.624060_g559633_i0 PRJEB30004 575260 172 1.62406 2.7933832 Ktedonobacterales bacterium 2306968 Bacteria Bacteria 76.6 9.82e-16   NR HZC78526.1 2306968 g559633 i0 77.8 0.784883720930233 45 10 78.5 0 3 137 127 171 HZC78526.1 RNA polymerase sigma factor [Ktedonobacterales bacterium] diamond 135 76.6 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales     Ktedonobacterales bacterium

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