RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

18 rows where analysis = "diamond", bioproject = "PRJNA1086823" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 18 ✖

tax_kingdom 1

bioproject 1

  • PRJNA1086823 · 18 ✖

analysis 1

  • diamond · 18 ✖

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
1468392 1468392 PRJNA1086823_P_NODE_17242_length_245_cov_0.906977_g17125_i0 PRJNA1086823 17242 245 0.906977 2.22209365 Chloroflexota bacterium 2026724 Bacteria Bacteria 132 6.18e-34   NR MDQ1323348.1 2026724 g17125 i0 89.7 2.48571428571429 68 7 83.3 0 244 41 485 552 MDQ1323348.1 bidirectional [NiFe] hydrogenase diaphorase subunit [Chloroflexota bacterium] diamond 609 132 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
7846455 7846455 PRJNA1086823_P_NODE_18327_length_243_cov_0.917647_g18210_i0 PRJNA1086823 18327 243 0.917647 2.22988221 Roseiflexaceae bacterium 2762507 Bacteria Bacteria 119 2.54e-30   NR HEU5102422.1 2762507 g18210 i0 72.5 2.93827160493827 80 22 98.8 0 241 2 42 121 HEU5102422.1 Gfo/Idh/MocA family oxidoreductase [Roseiflexaceae bacterium] diamond 714 119 1 Bacteria   Bacillati Chloroflexota Chloroflexia Chloroflexales Roseiflexaceae   Roseiflexaceae bacterium
23145853 23145853 PRJNA1086823_P_NODE_12159_length_253_cov_0.866667_g12042_i0 PRJNA1086823 12159 253 0.866667 2.19266751 Chloroflexota bacterium 2026724 Bacteria Bacteria 129 4.48e-36   NR NLG72210.1 2026724 g12042 i0 88.3 2.72727272727273 77 9 91.3 0 253 23 83 159 NLG72210.1 cyclic pyranopterin monophosphate synthase MoaC [Chloroflexota bacterium] diamond 690 129 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
26592442 26592442 PRJNA1086823_P_NODE_15961_length_247_cov_0.896552_g15844_i0 PRJNA1086823 15961 247 0.896552 2.21448344 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 143 6.939999999999998e-42   NR HLC30776.1 2026734 g15844 i0 79.3 0.995951417004049 82 17 99.6 0 2 247 49 130 HLC30776.1 3TM-type holin [Dehalococcoidia bacterium] diamond 246 143 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
27478305 27478305 PRJNA1086823_P_NODE_16943_length_245_cov_0.906977_g16826_i0 PRJNA1086823 16943 245 0.906977 2.22209365 Chloroflexi bacterium RBG_16_57_11 1797651 Bacteria Bacteria 145 1.71e-38   NR OGO36634.1 1797651 g16826 i0 92.6 0.991836734693878 81 6 99.2 0 244 2 350 430 OGO36634.1 MAG: hypothetical protein A2W35_16610 [Chloroflexi bacterium RBG_16_57_11] diamond 243 145 1 Bacteria   Bacillati Chloroflexota         Chloroflexi bacterium RBG_16_57_11
27509999 27509999 PRJNA1086823_P_NODE_12143_length_253_cov_0.866667_g12026_i0 PRJNA1086823 12143 253 0.866667 2.19266751 Candidatus Avedoeria danica 3140675 Bacteria Bacteria 45.4 0.00455   NR MBK6767969.1 3140675 g12026 i0 81.8 0.260869565217391 22 4 26.1 0 170 105 456 477 MBK6767969.1 hypothetical protein [Candidatus Avedoeria danica] diamond 66 45.4 1 Bacteria   Bacillati Chloroflexota Ardenticatenia Candidatus Epilineales Candidatus Epilineaceae Candidatus Avedoeria Candidatus Avedoeria danica
27762750 27762750 PRJNA1086823_P_NODE_13524_length_251_cov_0.876404_g13407_i0 PRJNA1086823 13524 251 0.876404 2.19977404 Chloroflexota bacterium 2026724 Bacteria Bacteria 150 3.54e-40   NR MBI5652903.1 2026724 g13407 i0 88 2.97609561752988 83 10 99.2 0 249 1 38 120 MBI5652903.1 glycosyltransferase family 39 protein [Chloroflexota bacterium] diamond 747 150 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
27857121 27857121 PRJNA1086823_P_NODE_11705_length_256_cov_1.054645_g11588_i0 PRJNA1086823 11705 256 1.054645 2.6998912 Chloroflexia bacterium 2448782 Bacteria Bacteria 148 2.66e-41   NR MFN8514720.1 2448782 g11588 i0 87.1 0.99609375 85 11 99.6 0 255 1 59 143 MFN8514720.1 selenide, water dikinase SelD [Chloroflexia bacterium] diamond 255 148 1 Bacteria   Bacillati Chloroflexota Chloroflexia       Chloroflexia bacterium
28258929 28258929 PRJNA1086823_P_NODE_14246_length_250_cov_0.881356_g14129_i0 PRJNA1086823 14246 250 0.881356 2.20339 Bacteria 2 Bacteria Bacteria 104 6.06e-24   NR MBI3958924.1 2026724 g14129 i0 57.5 2.904 80 34 96 0 242 3 185 264 MBI3958924.1 S9 family peptidase [Chloroflexota bacterium] diamond 726 105 0.990476190476191 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
29215115 29215115 PRJNA1086823_P_NODE_16469_length_246_cov_0.901734_g16352_i0 PRJNA1086823 16469 246 0.901734 2.21826564 Chloroflexota bacterium 2026724 Bacteria Bacteria 127 5.17e-33   NR HEX2325813.1 2026724 g16352 i0 79 1.97560975609756 81 17 98.8 0 245 3 34 114 HEX2325813.1 amidohydrolase family protein [Chloroflexota bacterium] diamond 486 127 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
29435599 29435599 PRJNA1086823_P_NODE_17790_length_244_cov_0.912281_g17673_i0 PRJNA1086823 17790 244 0.912281 2.22596564 Chloroflexota bacterium 2026724 Bacteria Bacteria 146 2.78e-39   NR HET7767275.1 2026724 g17673 i0 76.5 0.995901639344262 81 19 99.6 0 1 243 184 264 HET7767275.1 ABC transporter substrate-binding protein [Chloroflexota bacterium] diamond 243 146 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
30383880 30383880 PRJNA1086823_P_NODE_17993_length_244_cov_0.912281_g17876_i0 PRJNA1086823 17993 244 0.912281 2.22596564 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 44.3 0.00319   NR HSP56482.1 2026734 g17876 i0 42.4 2.40983606557377 66 37 81.1 1 243 46 30 94 HSP56482.1 hypothetical protein [Dehalococcoidia bacterium] diamond 588 44.3 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
31109969 31109969 PRJNA1086823_P_NODE_1775_length_558_cov_2.047423_g1660_i0 PRJNA1086823 1775 558 2.047423 11.42462034 Anaerolineaceae bacterium 2024896 Bacteria Bacteria 55.1 1.89e-5   NR MBI9051853.1 2024896 g1660 i0 48.1 0.279569892473118 52 27 28 0 549 394 174 225 MBI9051853.1 peptidase E [Anaerolineaceae bacterium] diamond 156 55.1 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae   Anaerolineaceae bacterium
31679253 31679253 PRJNA1086823_P_NODE_12477_length_253_cov_0.866667_g12360_i0 PRJNA1086823 12477 253 0.866667 2.19266751 Chloroflexota bacterium 2026724 Bacteria Bacteria 98.2 6.66e-22   NR MBI3738358.1 2026724 g12360 i0 70.1 0.91304347826087 77 22 90.1 1 253 26 340 416 MBI3738358.1 DUF190 domain-containing protein [Chloroflexota bacterium] diamond 231 98.2 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31900816 31900816 PRJNA1086823_P_NODE_6077_length_329_cov_1.175781_g5960_i0 PRJNA1086823 6077 329 1.175781 3.86831949 Chloroflexota bacterium 2026724 Bacteria Bacteria 136 4.849999999999999e-38   NR RYF28988.1 2026724 g5960 i0 62.7 0.930091185410334 102 38 93 0 328 23 27 128 RYF28988.1 MAG: hypothetical protein EOO17_03160 [Chloroflexota bacterium] diamond 306 136 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32090681 32090681 PRJNA1086823_P_NODE_19378_length_242_cov_0.869822_g19261_i0 PRJNA1086823 19378 242 0.869822 2.10496924 Anaerolineae bacterium 2052143 Bacteria Bacteria 90.1 7.84e-19   NR CAG1014194.1 2052143 g19261 i0 54.4 0.979338842975207 79 36 97.9 0 238 2 202 280 CAG1014194.1 hypothetical protein ANRL4_05137 [Anaerolineae bacterium] diamond 237 90.1 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
32785542 32785542 PRJNA1086823_P_NODE_12380_length_253_cov_0.866667_g12263_i0 PRJNA1086823 12380 253 0.866667 2.19266751 Chloroflexota bacterium 2026724 Bacteria Bacteria 63.9 1.31e-9   NR MQC83261.1 2026724 g12263 i0 73.8 0.49802371541502 42 11 49.8 0 127 2 86 127 MQC83261.1 hypothetical protein [Chloroflexota bacterium] diamond 126 63.9 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32785544 32785544 PRJNA1086823_P_NODE_13400_length_251_cov_0.876404_g13283_i0 PRJNA1086823 13400 251 0.876404 2.19977404 Chloroflexota bacterium 2026724 Bacteria Bacteria 143 1.47e-41   NR MEP7135496.1 2026724 g13283 i0 87.8 0.9800796812749 82 10 98 0 5 250 54 135 MEP7135496.1 DUF456 family protein [Chloroflexota bacterium] diamond 246 143 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);;