RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJDB9741" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 20 ✖

tax_kingdom 1

bioproject 1

  • PRJDB9741 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
14039133 14039133 PRJDB9741_P_NODE_5892_length_259_cov_1.857143_g5575_i0 PRJDB9741 5892 259 1.857143 4.81000037 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 156 4.16e-47   NR MDO9333994.1 2026733 g5575 i0 95.3 0.984555984555985 85 4 98.5 0 257 3 29 113 MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium] diamond 255 156 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales bacterium
19136456 19136456 PRJDB9741_P_NODE_29596_length_166_cov_0.871795_g29279_i0 PRJDB9741 29596 166 0.871795 1.4471797 Anaerolineales bacterium 2073117 Bacteria Bacteria 112 1.89e-27   NR MCJ7435777.1 2073117 g29279 i0 89.1 2.96385542168675 55 6 99.4 0 1 165 239 293 MCJ7435777.1 ABC transporter substrate-binding protein [Anaerolineales bacterium] diamond 492 112 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
26589036 26589036 PRJDB9741_P_NODE_30921_length_165_cov_1.758621_g30604_i0 PRJDB9741 30921 165 1.758621 2.90172465 Chloroflexota bacterium 2026724 Bacteria Bacteria 80.1 6.87e-16   NR MDY6876674.1 2026724 g30604 i0 72.2 1.96363636363636 54 15 98.2 0 2 163 25 78 MDY6876674.1 UDP-N-acetylglucosamine 2-epimerase [Chloroflexota bacterium] diamond 324 80.1 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
26969148 26969148 PRJDB9741_P_NODE_39462_length_161_cov_1.357143_g39145_i0 PRJDB9741 39462 161 1.357143 2.18500023 Anaerolineae bacterium 2052143 Bacteria Bacteria 66.6 3.33e-11   NR MBN8592119.1 2052143 g39145 i0 56.6 2.96273291925466 53 23 98.8 0 2 160 91 143 MBN8592119.1 FAD:protein FMN transferase [Anaerolineae bacterium] diamond 477 66.6 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
27317176 27317176 PRJDB9741_P_NODE_2223_length_501_cov_2.075221_g1910_i0 PRJDB9741 2223 501 2.075221 10.39685721 Dehalococcoidales bacterium 2026733 Bacteria Bacteria 200 4.82e-63   NR MDO9333994.1 2026733 g1910 i0 92 0.67065868263473 112 8 66.5 1 22 354 24 135 MDO9333994.1 30S ribosomal protein S4 [Dehalococcoidales bacterium] diamond 336 200 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia Dehalococcoidales     Dehalococcoidales bacterium
29180133 29180133 PRJDB9741_P_NODE_41069_length_159_cov_3.172727_g40752_i0 PRJDB9741 41069 159 3.172727 5.04463593 Chloroflexota bacterium 2026724 Bacteria Bacteria 103 4.57e-24   NR MBM4427268.1 2026724 g40752 i0 86.8 1 53 7 100 0 1 159 498 550 MBM4427268.1 ATP-dependent RecD-like DNA helicase [Chloroflexota bacterium] diamond 159 103 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
29463690 29463690 PRJDB9741_P_NODE_28110_length_167_cov_0.864407_g27793_i0 PRJDB9741 28110 167 0.864407 1.44355969 Roseiflexaceae bacterium 2762507 Bacteria Bacteria 70.9 1.6e-12   NR HWQ11260.1 2762507 g27793 i0 71.1 1.61676646706587 45 13 80.8 0 167 33 695 739 HWQ11260.1 PxKF domain-containing protein [Roseiflexaceae bacterium] diamond 270 70.9 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae   Roseiflexaceae bacterium
29747987 29747987 PRJDB9741_P_NODE_15651_length_185_cov_2.198529_g15334_i0 PRJDB9741 15651 185 2.198529 4.06727865 Chloroflexota bacterium 2026724 Bacteria Bacteria 81.3 4.55e-16   NR HZO26753.1 2026724 g15334 i0 65.6 0.989189189189189 61 21 98.9 0 184 2 253 313 HZO26753.1 glycosyltransferase family 39 protein [Chloroflexota bacterium] diamond 183 81.3 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
29811287 29811287 PRJDB9741_P_NODE_30171_length_166_cov_0.871795_g29854_i0 PRJDB9741 30171 166 0.871795 1.4471797 Chloroflexi bacterium RBG_19FT_COMBO_55_16 1797669 Bacteria Bacteria 52.8 3.86e-6   NR OGO63860.1 1797669 g29854 i0 71.9 5.42168674698795 32 9 57.8 0 165 70 98 129 OGO63860.1 MAG: 6-phosphofructokinase [Chloroflexi bacterium RBG_19FT_COMBO_55_16] diamond 900 52.8 1 Bacteria   Bacillati Chloroflexota         Chloroflexi bacterium RBG_19FT_COMBO_55_16
30595155 30595155 PRJDB9741_P_NODE_14113_length_188_cov_1.467626_g13796_i0 PRJDB9741 14113 188 1.467626 2.75913688 Kouleothrix 186475 Bacteria Bacteria 114 1.2200000000000002e-27   NR MFN8567971.1 2779161 g13796 i0 83.9 4.9468085106383 62 10 98.9 0 2 187 276 337 MFN8567971.1 ATP-binding protein [Kouleothrix sp.] diamond 930 114 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae Kouleothrix Kouleothrix sp.
30980594 30980594 PRJDB9741_P_NODE_14754_length_187_cov_1.478261_g14437_i0 PRJDB9741 14754 187 1.478261 2.76434807 Oscillochloris sp. 2547424 Bacteria Bacteria 112 3.61e-30   NR NTW97335.1 2547424 g14437 i0 96.7 0.978609625668449 61 2 97.9 0 3 185 58 118 NTW97335.1 hypothetical protein [Oscillochloris sp.] diamond 183 112 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Oscillochloridaceae Oscillochloris Oscillochloris sp.
31011954 31011954 PRJDB9741_P_NODE_39755_length_161_cov_0.910714_g39438_i0 PRJDB9741 39755 161 0.910714 1.46624954 Roseiflexaceae bacterium 2762507 Bacteria Bacteria 60.8 7e-10   NR HEU4328905.1 2762507 g39438 i0 49 0.950310559006211 51 25 95 1 1 153 8 57 HEU4328905.1 SdrD B-like domain-containing protein [Roseiflexaceae bacterium] diamond 153 60.8 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae   Roseiflexaceae bacterium
31296382 31296382 PRJDB9741_P_NODE_42995_length_152_cov_3.291262_g42678_i0 PRJDB9741 42995 152 3.291262 5.00271824 Anaerolineae bacterium 2052143 Bacteria Bacteria 79.3 1.34e-15   NR MCU0507864.1 2052143 g42678 i0 78 0.986842105263158 50 11 98.7 0 1 150 615 664 MCU0507864.1 PAS domain S-box protein [Anaerolineae bacterium] diamond 150 79.3 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
31486450 31486450 PRJDB9741_P_NODE_9456_length_210_cov_2.788820_g9139_i0 PRJDB9741 9456 210 2.78882 5.856522 Candidatus Chloroploca mongolica 2528176 Bacteria Bacteria 57.4 1.6e-7   NR WP_135481924.1 2528176 g9139 i0 75 0.457142857142857 32 8 45.7 0 98 3 37 68 WP_135481924.1 protein phosphatase 2C domain-containing protein [Candidatus Chloroploca mongolica] diamond 96 57.4 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Oscillochloridaceae Candidatus Chloroploca Candidatus Chloroploca mongolica
31644204 31644204 PRJDB9741_P_NODE_7077_length_236_cov_1.090909_g6760_i0 PRJDB9741 7077 236 1.090909 2.57454524 Ktedonobacteraceae bacterium 2740538 Bacteria Bacteria 114 6.19e-29   NR HET8845596.1 2740538 g6760 i0 74.4 0.991525423728814 78 20 99.2 0 234 1 95 172 HET8845596.1 MFS transporter [Ktedonobacteraceae bacterium] diamond 234 114 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales Ktedonobacteraceae   Ktedonobacteraceae bacterium
31992319 31992319 PRJDB9741_P_NODE_7398_length_231_cov_0.868132_g7081_i0 PRJDB9741 7398 231 0.868132 2.00538492 Chloroflexota bacterium 2026724 Bacteria Bacteria 42.4 0.0426   NR MDE2900845.1 2026724 g7081 i0 37.7 0.896103896103896 69 33 89.6 3 10 216 134 192 MDE2900845.1 LLM class flavin-dependent oxidoreductase [Chloroflexota bacterium] diamond 207 42.4 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32467231 32467231 PRJDB9741_P_NODE_28039_length_167_cov_0.864407_g27722_i0 PRJDB9741 28039 167 0.864407 1.44355969 Roseiflexaceae bacterium 2762507 Bacteria Bacteria 79.7 2.87e-16   NR HEU5102305.1 2762507 g27722 i0 71.7 0.952095808383233 53 15 95.2 0 1 159 204 256 HEU5102305.1 N-acyl homoserine lactonase family protein [Roseiflexaceae bacterium] diamond 159 79.7 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae   Roseiflexaceae bacterium
32498816 32498816 PRJDB9741_P_NODE_17239_length_183_cov_1.119403_g16922_i0 PRJDB9741 17239 183 1.119403 2.04850749 Chloroflexi bacterium 13_1_4 1805069 Bacteria Bacteria 67.8 2.53e-11   NR OLD45325.1 1805069 g16922 i0 70.5 3.81967213114754 44 13 72.1 0 183 52 56 99 OLD45325.1 MAG: hypothetical protein AUI48_13380 [Chloroflexi bacterium 13_1_40CM_2_68_14] diamond 699 67.8 1 Bacteria   Bacillati Chloroflexota         Chloroflexi bacterium 13_1_40CM_2_68_14
32624755 32624755 PRJDB9741_P_NODE_29640_length_166_cov_0.871795_g29323_i0 PRJDB9741 29640 166 0.871795 1.4471797 Ktedonobacterales bacterium 2306968 Bacteria Bacteria 53.5 8.51e-7   NR HKB46401.1 2306968 g29323 i0 45.5 1.89759036144578 55 29 99.4 1 166 2 12 65 HKB46401.1 hypothetical protein [Ktedonobacterales bacterium] diamond 315 53.5 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales     Ktedonobacterales bacterium
32656013 32656013 PRJDB9741_P_NODE_32500_length_165_cov_0.879310_g32183_i0 PRJDB9741 32500 165 0.87931 1.4508615 Chloroflexota bacterium 2026724 Bacteria Bacteria 63.9 3.24e-10   NR MBV9577260.1 2026724 g32183 i0 60 1.85454545454545 50 20 90.9 0 9 158 4 53 MBV9577260.1 branched-chain amino acid ABC transporter permease [Chloroflexota bacterium] diamond 306 63.9 1 Bacteria   Bacillati Chloroflexota         Chloroflexota 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);;