RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

13 rows where analysis = "diamond", bioproject = "PRJNA572587" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 13 ✖

tax_kingdom 1

bioproject 1

  • PRJNA572587 · 13 ✖

analysis 1

  • diamond · 13 ✖

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
18410929 18410929 PRJNA572587_P_NODE_34955_length_186_cov_27.335766_g34627_i0 PRJNA572587 34955 186 27.335766 50.84452476 Anaerolineae bacterium 2052143 Bacteria Bacteria 65.1 1.51e-10   NR MFL7809221.1 2052143 g34627 i0 50.8 1.85483870967742 63 28 96.8 1 182 3 206 268 MFL7809221.1 hypothetical protein [Anaerolineae bacterium] diamond 345 65.1 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
26998015 26998015 PRJNA572587_P_NODE_14622_length_302_cov_1.612648_g14294_i0 PRJNA572587 14622 302 1.612648 4.87019696 Bacteria 2 Bacteria Bacteria 80.1 4.8e-15   NR MEE9198569.1 2026734 g14294 i0 77.6 6.23841059602649 49 11 48.7 0 9 155 383 431 MEE9198569.1 F0F1 ATP synthase subunit beta [Dehalococcoidia bacterium] diamond 1884 80.5 0.995031055900621 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
27711772 27711772 PRJNA572587_P_NODE_20804_length_248_cov_2.226131_g20476_i0 PRJNA572587 20804 248 2.226131 5.52080488 Chloroflexi bacterium CFX6 2293710 Bacteria Bacteria 49.7 1.26e-5   NR MCE7937064.1 2293710 g20476 i0 49.1 0.665322580645161 55 28 66.5 0 38 202 1 55 MCE7937064.1 hypothetical protein [Chloroflexi bacterium CFX6] diamond 165 49.7 1 Bacteria   Bacillati Chloroflexota         Chloroflexi bacterium CFX6
27977461 27977461 PRJNA572587_P_NODE_1165_length_1134_cov_63.817512_g1059_i0 PRJNA572587 1165 1134 63.817512 723.69058608 Bacteria 2 Bacteria Bacteria 89.4 8.83e-16   NR MBN1874077.1 2052143 g1059 i0 48.8 0.915343915343915 86 44 22.8 0 277 534 200 285 MBN1874077.1 protein phosphatase 2C domain-containing protein [Anaerolineae bacterium] diamond 1038 90.1 0.992230854605993 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
28311330 28311330 PRJNA572587_P_NODE_2526_length_824_cov_30.667097_g2304_i0 PRJNA572587 2526 824 30.667097 252.69687928 Chloroflexota bacterium 2026724 Bacteria Bacteria 95.5 3.95e-21   NR MEM7345207.1 2026724 g2304 i0 54.9 0.298543689320388 82 37 29.9 0 556 311 2 83 MEM7345207.1 hypothetical protein [Chloroflexota bacterium] diamond 246 95.5 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28406006 28406006 PRJNA572587_P_NODE_9906_length_378_cov_4.996960_g9579_i0 PRJNA572587 9906 378 4.99696 18.8885088 Bellilinea sp. 2838785 Bacteria Bacteria 117 2.21e-28   NR GIV63694.1 2838785 g9579 i0 100 0.484126984126984 61 0 48.4 0 187 369 1 61 GIV63694.1 MAG: sodium transporter [Bellilinea sp.] diamond 183 117 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae Bellilinea Bellilinea sp.
28861470 28861470 PRJNA572587_P_NODE_14088_length_308_cov_11.598456_g13760_i0 PRJNA572587 14088 308 11.598456 35.72324448 Dictyobacter 2024965 Bacteria Bacteria 114 7.370000000000001e-27   NR WP_149400690.1 2014874 g13760 i0 79.7 2.01623376623377 69 14 67.2 0 215 9 162 230 WP_149400690.1 hypothetical protein [Dictyobacter arantiisoli] diamond 621 114 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales Dictyobacteraceae Dictyobacter Dictyobacter arantiisoli
29700078 29700078 PRJNA572587_P_NODE_21490_length_244_cov_0.902564_g21162_i0 PRJNA572587 21490 244 0.902564 2.20225616 Chloroflexota bacterium 2026724 Bacteria Bacteria 58.5 9.45e-8   NR RYF28783.1 2026724 g21162 i0 59.1 3.94672131147541 44 18 54.1 0 188 57 88 131 RYF28783.1 MAG: hypothetical protein EOO17_03940, partial [Chloroflexota bacterium] diamond 963 58.5 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
30301144 30301144 PRJNA572587_P_NODE_26432_length_217_cov_30.422619_g26104_i0 PRJNA572587 26432 217 30.422619 66.01708323 Anaerolineales bacterium 2073117 Bacteria Bacteria 42.4 0.0303   NR MBL8089521.1 2073117 g26104 i0 40.3 0.995391705069124 72 29 80.2 2 215 42 69 140 MBL8089521.1 GIY-YIG nuclease family protein [Anaerolineales bacterium] diamond 216 42.4 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
31185067 31185067 PRJNA572587_P_NODE_22235_length_239_cov_21.573684_g21907_i0 PRJNA572587 22235 239 21.573684 51.56110476 Anaerolineales bacterium 2073117 Bacteria Bacteria 56.6 4.42e-7   NR HIE57619.1 2073117 g21907 i0 53.7 1.35564853556485 54 22 67.8 1 9 170 336 386 HIE57619.1 ISNCY family transposase [Anaerolineales bacterium] diamond 324 56.6 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
31406864 31406864 PRJNA572587_P_NODE_6936_length_466_cov_12.832134_g6612_i0 PRJNA572587 6936 466 12.832134 59.79774444 Candidatus Limnocylindrales bacterium 2952938 Bacteria Bacteria 153 2.36e-44   NR HUQ84768.1 2952938 g6612 i0 64.5 1.59656652360515 124 44 79.8 0 93 464 27 150 HUQ84768.1 MarR family transcriptional regulator [Candidatus Limnocylindrales bacterium] diamond 744 153 1 Bacteria   Bacillati Chloroflexota Candidatus Limnocylindria Candidatus Limnocylindrales     Candidatus Limnocylindrales bacterium
31768188 31768188 PRJNA572587_P_NODE_43037_length_167_cov_0.864407_g42709_i0 PRJNA572587 43037 167 0.864407 1.44355969 Bacillati 1783272 Bacteria Bacteria 48.5 1.19e-4   NR MEW6402165.1 2026724 g42709 i0 91.3 2.5688622754491 23 2 41.3 0 70 138 153 175 MEW6402165.1 hypothetical protein [Chloroflexota bacterium] diamond 429 48.5 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32766064 32766064 PRJNA572587_P_NODE_28640_length_208_cov_6.528302_g28312_i0 PRJNA572587 28640 208 6.528302 13.57886816 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 53.9 2.47e-6   NR MCL2706616.1 2026734 g28312 i0 47.1 0.735576923076923 51 27 73.6 0 42 194 139 189 MCL2706616.1 J domain-containing protein [Dehalococcoidia bacterium] diamond 153 53.9 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia 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);;