RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

35 rows where analysis = "diamond", bioproject = "PRJEB83711" and tax_phylum = "Chloroflexota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Chloroflexota · 35 ✖

tax_kingdom 1

bioproject 1

  • PRJEB83711 · 35 ✖

analysis 1

  • diamond · 35 ✖

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
9071496 9071496 PRJEB83711_P_NODE_48488_length_270_cov_1.329949_g48222_i0 PRJEB83711 48488 270 1.329949 3.5908623 Chloroflexota bacterium 2026724 Bacteria Bacteria 179 6.489999999999999e-54   NR GIW19751.1 2026724 g48222 i0 98.9 0.988888888888889 89 1 98.9 0 268 2 74 162 GIW19751.1 MAG: hypothetical protein KatS3mg065_0047 [Chloroflexota bacterium] diamond 267 179 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
15447447 15447447 PRJEB83711_P_NODE_77893_length_242_cov_1.698225_g77627_i0 PRJEB83711 77893 242 1.698225 4.1097045 Bacteria 2 Bacteria Bacteria 149 2.54e-41   NR HAX23816.1 2026724 g77627 i0 95 1.98347107438017 80 4 99.2 0 1 240 67 146 HAX23816.1 amidohydrolase [Chloroflexota bacterium] diamond 480 149 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
15447464 15447464 PRJEB83711_P_NODE_78453_length_242_cov_0.923077_g78187_i0 PRJEB83711 78453 242 0.923077 2.23384634 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 137 6.68e-40   NR MEZ4501180.1 2026734 g78187 i0 81.3 0.991735537190083 80 15 99.2 0 241 2 18 97 MEZ4501180.1 cyclic-di-AMP receptor [Dehalococcoidia bacterium] diamond 240 137 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
26615280 26615280 PRJEB83711_P_NODE_59221_length_252_cov_1.374302_g58955_i0 PRJEB83711 59221 252 1.374302 3.46324104 Bacteria 2 Bacteria Bacteria 125 2.19e-32   NR MCA1570731.1 2026724 g58955 i0 77.8 4.75 81 16 96.4 1 250 8 301 379 MCA1570731.1 AI-2E family transporter [Chloroflexota bacterium] diamond 1197 125 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
26622725 26622725 PRJEB83711_P_NODE_39241_length_291_cov_1.275229_g38975_i0 PRJEB83711 39241 291 1.275229 3.71091639 Caldilineaceae bacterium 2614250 Bacteria Bacteria 163 2.3e-47   NR MCB0091691.1 2614250 g38975 i0 84.2 1.95876288659794 95 15 97.9 0 3 287 29 123 MCB0091691.1 D-2-hydroxyacid dehydrogenase [Caldilineaceae bacterium] diamond 570 163 1 Bacteria   Bacillati Chloroflexota Caldilineae Caldilineales Caldilineaceae   Caldilineaceae bacterium
27318965 27318965 PRJEB83711_P_NODE_62783_length_250_cov_1.367232_g62517_i0 PRJEB83711 62783 250 1.367232 3.41808 Candidatus Limnocylindrales bacterium 2952938 Bacteria Bacteria 138 9.57e-38   NR HEX7347677.1 2952938 g62517 i0 78.3 1.992 83 18 99.6 0 1 249 45 127 HEX7347677.1 type I glyceraldehyde-3-phosphate dehydrogenase [Candidatus Limnocylindrales bacterium] diamond 498 138 1 Bacteria   Bacillati Chloroflexota Candidatus Limnocylindria Candidatus Limnocylindrales     Candidatus Limnocylindrales bacterium
27382132 27382132 PRJEB83711_P_NODE_77543_length_243_cov_0.888235_g77277_i0 PRJEB83711 77543 243 0.888235 2.15841105 Chloroflexota bacterium 2026724 Bacteria Bacteria 165 5.3899999999999997e-48   NR MDQ2674531.1 2026724 g77277 i0 93.8 3 81 5 100 0 1 243 92 172 MDQ2674531.1 phenylalanine--tRNA ligase subunit alpha [Chloroflexota bacterium] diamond 729 165 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
27729695 27729695 PRJEB83711_P_NODE_61544_length_251_cov_0.876404_g61278_i0 PRJEB83711 61544 251 0.876404 2.19977404 Chloroflexia bacterium 2448782 Bacteria Bacteria 126 1.29e-33   NR MBA3450306.1 2448782 g61278 i0 74.7 3.9681274900398402 83 21 99.2 0 3 251 107 189 MBA3450306.1 sugar ABC transporter permease [Chloroflexia bacterium] diamond 996 126 1 Bacteria   Bacillati Chloroflexota Chloroflexia       Chloroflexia bacterium
28234273 28234273 PRJEB83711_P_NODE_40426_length_288_cov_1.246512_g40160_i0 PRJEB83711 40426 288 1.246512 3.58995456 Chloroflexota bacterium 2026724 Bacteria Bacteria 43.9 0.0235   NR MCH8009005.1 2026724 g40160 i0 58.8 0.708333333333333 34 12 33.3 1 165 260 184 217 MCH8009005.1 PQQ-dependent sugar dehydrogenase [Chloroflexota bacterium] diamond 204 43.9 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28329172 28329172 PRJEB83711_P_NODE_58166_length_253_cov_0.866667_g57900_i0 PRJEB83711 58166 253 0.866667 2.19266751 Anaerolineae bacterium 2052143 Bacteria Bacteria 144 1.6399999999999999e-40   NR MBZ0291721.1 2052143 g57900 i0 90.4 0.984189723320158 83 8 98.4 0 3 251 183 265 MBZ0291721.1 TniB family NTP-binding protein [Anaerolineae bacterium] diamond 249 144 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium
28518797 28518797 PRJEB83711_P_NODE_41627_length_285_cov_1.301887_g41361_i0 PRJEB83711 41627 285 1.301887 3.71037795 Ktedonobacteraceae bacterium 2740538 Bacteria Bacteria 100 6.78e-25   NR HET8845834.1 2740538 g41361 i0 49.5 0.978947368421053 93 44 97.9 1 285 7 21 110 HET8845834.1 hypothetical protein [Ktedonobacteraceae bacterium] diamond 279 100 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales Ktedonobacteraceae   Ktedonobacteraceae bacterium
28771233 28771233 PRJEB83711_P_NODE_57607_length_253_cov_0.866667_g57341_i0 PRJEB83711 57607 253 0.866667 2.19266751 Ktedonobacteraceae bacterium 2740538 Bacteria Bacteria 160 5.479999999999998e-47   NR MEO7019206.1 2740538 g57341 i0 88.1 3.98418972332016 84 10 99.6 0 253 2 159 242 MEO7019206.1 methyltransferase domain-containing protein [Ktedonobacteraceae bacterium] diamond 1008 160 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales Ktedonobacteraceae   Ktedonobacteraceae bacterium
28897455 28897455 PRJEB83711_P_NODE_52588_length_262_cov_1.264550_g52322_i0 PRJEB83711 52588 262 1.26455 3.313121 Chloroflexia bacterium 2448782 Bacteria Bacteria 135 7.1e-36   NR MBA2469376.1 2448782 g52322 i0 73.5 1.93511450381679 83 22 95 0 261 13 147 229 MBA2469376.1 DNA modification methylase [Chloroflexia bacterium] diamond 507 135 1 Bacteria   Bacillati Chloroflexota Chloroflexia       Chloroflexia bacterium
28921660 28921660 PRJEB83711_P_NODE_41128_length_286_cov_1.464789_g40862_i0 PRJEB83711 41128 286 1.464789 4.18929654 Bacteria 2 Bacteria Bacteria 115 2.02e-28   NR MDP9472224.1 2026724 g40862 i0 56.4 2.95804195804196 94 41 98.6 0 283 2 203 296 MDP9472224.1 polysaccharide deacetylase family protein [Chloroflexota bacterium] diamond 846 115 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
28992620 28992620 PRJEB83711_P_NODE_69368_length_247_cov_0.896552_g69102_i0 PRJEB83711 69368 247 0.896552 2.21448344 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 108 1.46e-27   NR HEU0074922.1 2026734 g69102 i0 59.8 2.97570850202429 82 33 99.6 0 1 246 78 159 HEU0074922.1 PHP domain-containing protein [Dehalococcoidia bacterium] diamond 735 108 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
29276330 29276330 PRJEB83711_P_NODE_74389_length_244_cov_0.912281_g74123_i0 PRJEB83711 74389 244 0.912281 2.22596564 Dehalococcoidia bacterium 2026734 Bacteria Bacteria 129 1.02e-32   NR MSQ29539.1 2026734 g74123 i0 68.8 0.983606557377049 80 25 98.4 0 240 1 336 415 MSQ29539.1 ABC transporter substrate-binding protein [Dehalococcoidia bacterium] diamond 240 129 1 Bacteria   Bacillati Chloroflexota Dehalococcoidia       Dehalococcoidia bacterium
29434018 29434018 PRJEB83711_P_NODE_65950_length_249_cov_0.886364_g65684_i0 PRJEB83711 65950 249 0.886364 2.20704636 Anaerolineales bacterium 2073117 Bacteria Bacteria 112 8.97e-30   NR HEX9388031.1 2073117 g65684 i0 77.1 1 83 17 100 1 249 1 26 106 HEX9388031.1 rhodanese-like domain-containing protein [Anaerolineales bacterium] diamond 249 112 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales bacterium
30184879 30184879 PRJEB83711_P_NODE_70032_length_246_cov_1.618497_g69766_i0 PRJEB83711 70032 246 1.618497 3.98150262 FCB group 1783270 Bacteria Bacteria 131 2.1199999999999993e-34   NR KPK11909.1 1703386 g69766 i0 84 10.9512195121951 75 12 91.5 0 227 3 1 75 KPK11909.1 MAG: citrate synthase [Anaerolineae bacterium SG8_19] diamond 2694 131 1 Bacteria   Bacillati Chloroflexota Anaerolineae       Anaerolineae bacterium SG8_19
30697751 30697751 PRJEB83711_P_NODE_52154_length_263_cov_0.821053_g51888_i0 PRJEB83711 52154 263 0.821053 2.15936939 Kallotenue papyrolyticum 1325125 Bacteria Bacteria 43.9 0.0178   NR WP_026369774.1 1325125 g51888 i0 41.1 0.832699619771863 73 38 81 2 43 255 281 350 WP_026369774.1 glycosyltransferase [Kallotenue papyrolyticum] diamond 219 43.9 1 Bacteria   Bacillati Chloroflexota Chloroflexia Kallotenuales Kallotenuaceae Kallotenue Kallotenue papyrolyticum
30974985 30974985 PRJEB83711_P_NODE_68154_length_247_cov_1.666667_g67888_i0 PRJEB83711 68154 247 1.666667 4.11666749 Chloroflexota 200795 Bacteria Bacteria 100 4.23e-24   NR OQY22844.1 1971624 g67888 i0 61 5.00404858299595 82 32 99.6 0 247 2 76 157 OQY22844.1 MAG: lysine transporter LysE [Anaerolineaceae bacterium 4572_32.2] diamond 1236 100 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales Anaerolineaceae   Anaerolineaceae bacterium 4572_32.2
31045735 31045735 PRJEB83711_P_NODE_75255_length_244_cov_0.912281_g74989_i0 PRJEB83711 75255 244 0.912281 2.22596564 Chloroflexota bacterium 2026724 Bacteria Bacteria 51.2 2.64e-5   NR MDQ4075549.1 2026724 g74989 i0 57.1 0.516393442622951 42 18 51.6 0 117 242 1 42 MDQ4075549.1 1-acyl-sn-glycerol-3-phosphate acyltransferase [Chloroflexota bacterium] diamond 126 51.2 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31077128 31077128 PRJEB83711_P_NODE_44115_length_279_cov_1.587379_g43849_i0 PRJEB83711 44115 279 1.587379 4.42878741 Chloroflexota bacterium 2026724 Bacteria Bacteria 102 6.48e-23   NR PLS79330.1 2026724 g43849 i0 54.7 1.8494623655914 86 39 92.5 0 10 267 69 154 PLS79330.1 MAG: alpha-mannosidase, partial [Chloroflexota bacterium] diamond 516 102 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31202916 31202916 PRJEB83711_P_NODE_64115_length_250_cov_0.870056_g63849_i0 PRJEB83711 64115 250 0.870056 2.17514 Herpetosiphonaceae bacterium 2720503 Bacteria Bacteria 122 4.2e-32   NR HEX6289244.1 2720503 g63849 i0 74.1 1.02 85 19 98.4 1 248 3 73 157 HEX6289244.1 ABC-2 family transporter protein [Herpetosiphonaceae bacterium] diamond 255 122 1 Bacteria   Bacillati Chloroflexota Chloroflexia Herpetosiphonales Herpetosiphonaceae   Herpetosiphonaceae bacterium
31298216 31298216 PRJEB83711_P_NODE_61955_length_251_cov_0.876404_g61689_i0 PRJEB83711 61955 251 0.876404 2.19977404 Ktedonobacteraceae bacterium 2740538 Bacteria Bacteria 77 2.39e-15   NR MFL5660112.1 2740538 g61689 i0 45.2 2.00796812749004 84 45 99.2 1 1 249 24 107 MFL5660112.1 hypothetical protein [Ktedonobacteraceae bacterium] diamond 504 77 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales Ktedonobacteraceae   Ktedonobacteraceae bacterium
31456524 31456524 PRJEB83711_P_NODE_68956_length_247_cov_0.896552_g68690_i0 PRJEB83711 68956 247 0.896552 2.21448344 Phototrophicaceae bacterium 3069543 Bacteria Bacteria 80.1 8.93e-17   NR HLT84399.1 3069543 g68690 i0 54.3 2.05263157894737 70 32 85 0 2 211 35 104 HLT84399.1 GNAT family N-acetyltransferase [Phototrophicaceae bacterium] diamond 507 80.1 1 Bacteria   Bacillati Chloroflexota Candidatus Thermofontia Phototrophicales Phototrophicaceae   Phototrophicaceae bacterium
31551557 31551557 PRJEB83711_P_NODE_70856_length_246_cov_0.901734_g70590_i0 PRJEB83711 70856 246 0.901734 2.21826564 Phototrophicaceae bacterium 3069543 Bacteria Bacteria 120 7.6e-31   NR HYO05837.1 3069543 g70590 i0 88.4 1.69512195121951 69 8 84.1 0 36 242 194 262 HYO05837.1 IS630 family transposase [Phototrophicaceae bacterium] diamond 417 120 1 Bacteria   Bacillati Chloroflexota Candidatus Thermofontia Phototrophicales Phototrophicaceae   Phototrophicaceae bacterium
31614533 31614533 PRJEB83711_P_NODE_58676_length_253_cov_0.866667_g58410_i0 PRJEB83711 58676 253 0.866667 2.19266751 Dictyobacter arantiisoli 2014874 Bacteria Bacteria 71.6 1.46e-12   NR WP_149404124.1 2014874 g58410 i0 53.4 0.687747035573123 58 27 68.8 0 174 1 38 95 WP_149404124.1 aminoglycoside 6-adenylyltransferase [Dictyobacter arantiisoli] diamond 174 71.6 1 Bacteria   Bacillati Chloroflexota Ktedonobacteria Ktedonobacterales Dictyobacteraceae Dictyobacter Dictyobacter arantiisoli
31772636 31772636 PRJEB83711_P_NODE_38817_length_292_cov_1.324201_g38551_i0 PRJEB83711 38817 292 1.324201 3.86666692 Chloroflexota bacterium 2026724 Bacteria Bacteria 149 2.88e-42   NR PLS79867.1 2026724 g38551 i0 87.1 1.91095890410959 93 12 95.5 0 279 1 1 93 PLS79867.1 MAG: hypothetical protein CYG59_11130, partial [Chloroflexota bacterium] diamond 558 149 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
31867461 31867461 PRJEB83711_P_NODE_64997_length_249_cov_0.886364_g64731_i0 PRJEB83711 64997 249 0.886364 2.20704636 Chloroflexia bacterium 2448782 Bacteria Bacteria 70.5 7.08e-12   NR HKP51139.1 2448782 g64731 i0 58.9 0.674698795180723 56 23 67.5 0 22 189 698 753 HKP51139.1 tetratricopeptide repeat protein [Chloroflexia bacterium] diamond 168 70.5 1 Bacteria   Bacillati Chloroflexota Chloroflexia       Chloroflexia bacterium
31891857 31891857 PRJEB83711_P_NODE_48877_length_269_cov_1.586735_g48611_i0 PRJEB83711 48877 269 1.586735 4.26831715 Bacillati 1783272 Bacteria Bacteria 82.4 3.57e-16   NR OQB88080.1 1852856 g48611 i0 62.1 1.94052044609665 58 22 64.7 0 178 5 9 66 OQB88080.1 MAG: putative diguanylate cyclase AdrA [Chloroflexi bacterium ADurb.Bin120] diamond 522 82.8 0.995169082125604 Bacteria   Bacillati Chloroflexota         Chloroflexi bacterium ADurb.Bin120
32050052 32050052 PRJEB83711_P_NODE_43838_length_280_cov_1.222222_g43572_i0 PRJEB83711 43838 280 1.222222 3.4222216 Bacteria 2 Bacteria Bacteria 123 3.5799999999999995e-31   NR MBV9790486.1 2026724 g43572 i0 65.2 1.97142857142857 92 32 98.6 0 4 279 273 364 MBV9790486.1 polysaccharide biosynthesis C-terminal domain-containing protein [Chloroflexota bacterium] diamond 552 123 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32152415 32152415 PRJEB83711_P_NODE_63738_length_250_cov_0.881356_g63472_i0 PRJEB83711 63738 250 0.881356 2.20339 Chloroflexia bacterium 2448782 Bacteria Bacteria 124 4.26e-34   NR MBL8128962.1 2448782 g63472 i0 92.6 0.816 68 5 81.6 0 46 249 1 68 MBL8128962.1 aminotransferase class III-fold pyridoxal phosphate-dependent enzyme [Chloroflexia bacterium] diamond 204 124 1 Bacteria   Bacillati Chloroflexota Chloroflexia       Chloroflexia bacterium
32437405 32437405 PRJEB83711_P_NODE_58739_length_253_cov_0.866667_g58473_i0 PRJEB83711 58739 253 0.866667 2.19266751 Chloroflexota bacterium 2026724 Bacteria Bacteria 86.3 1.95e-17   NR MFM8321615.1 2026724 g58473 i0 57.5 0.948616600790514 80 34 94.9 0 11 250 395 474 MFM8321615.1 hypothetical protein [Chloroflexota bacterium] diamond 240 86.3 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32689540 32689540 PRJEB83711_P_NODE_42180_length_284_cov_0.976303_g41914_i0 PRJEB83711 42180 284 0.976303 2.77270052 Chloroflexota bacterium 2026724 Bacteria Bacteria 111 1.1300000000000002e-27   NR MBI1882005.1 2026724 g41914 i0 89.7 0.612676056338028 58 6 61.3 0 283 110 204 261 MBI1882005.1 SIS domain-containing protein [Chloroflexota bacterium] diamond 174 111 1 Bacteria   Bacillati Chloroflexota         Chloroflexota bacterium
32752652 32752652 PRJEB83711_P_NODE_69260_length_247_cov_0.896552_g68994_i0 PRJEB83711 69260 247 0.896552 2.21448344 Anaerolineales bacterium 2073117 Bacteria Bacteria 126 2.48e-35   NR MCK4901406.1 2073117 g68994 i0 73.2 4.97975708502024 82 22 99.6 0 247 2 14 95 MCK4901406.1 RusA family crossover junction endodeoxyribonuclease [Anaerolineales bacterium] diamond 1230 126 1 Bacteria   Bacillati Chloroflexota Anaerolineae Anaerolineales     Anaerolineales 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);;