contig_metadata
20 rows where bioproject = "PRJNA788929", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2045116 | 2045116 | PRJNA788929_P_NODE_19782_length_368_cov_5.966102_g19122_i0 | PRJNA788929 | 19782 | 368 | 5.966102 | 21.95525536 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 197 | 8.56e-56 | NR | MDP9316679.1 | 2026724 | g19122 | i0 | 82.5 | 0.929347826086957 | 114 | 20 | 92.9 | 0 | 344 | 3 | 394 | 507 | MDP9316679.1 molybdopterin-dependent oxidoreductase [Chloroflexota bacterium] | diamond | 342 | 197 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 4597501 | 4597501 | PRJNA788929_P_NODE_23164_length_335_cov_29.683206_g22503_i0 | PRJNA788929 | 23164 | 335 | 29.683206 | 99.4387401 | Phototrophicaceae bacterium | 3069543 | Bacteria | Bacteria | 189 | 2.31e-43 | NTclustered | gi|2893358443|emb|OZ220735.1| | 3069543 | g22503 | i0 | 78.233 | 121.185074626866 | 317 | 53 | 92 | 11 | 22 | 330 | 2360761 | 2360453 | MAG: Phototrophicaceae bacterium isolate 252cb3c6-93c9-4785-98a9-44529c25b936 genome assembly, chromosome: 1 | blastn | 40597 | 189 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Thermofontia | Phototrophicales | Phototrophicaceae | Phototrophicaceae bacterium | |||
| 4597607 | 4597607 | PRJNA788929_P_NODE_30184_length_287_cov_7.663551_g29523_i0 | PRJNA788929 | 30184 | 287 | 7.663551 | 21.99439137 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 307 | 5.13e-79 | NTclustered | gi|2874253698|emb|OY969424.1| | 1672391 | g29523 | i0 | 88.889 | 151.721254355401 | 252 | 25 | 87 | 3 | 28 | 278 | 971186 | 971435 | MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1 | blastn | 43544 | 307 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 7147586 | 7147586 | PRJNA788929_P_NODE_12486_length_489_cov_120.685096_g11829_i0 | PRJNA788929 | 12486 | 489 | 120.685096 | 590.15011944 | Phototrophicus methaneseepsis | 2710758 | Bacteria | Bacteria | 383 | 1.4899999999999994e-101 | NTclustered | gi|1932369605|gb|CP062983.1| | 2710758 | g11829 | i0 | 81.612 | 175.934560327198 | 484 | 70 | 96 | 12 | 1 | 470 | 2827346 | 2826868 | Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome | blastn | 86032 | 383 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Thermofontia | Phototrophicales | Phototrophicaceae | Phototrophicus | Phototrophicus methaneseepsis | ||
| 11418122 | 11418122 | PRJNA788929_P_NODE_19929_length_366_cov_19.027304_g19269_i0 | PRJNA788929 | 19929 | 366 | 19.027304 | 69.63993264 | Chloroflexus | 1107 | Bacteria | Bacteria | 270 | 8.81e-68 | NTclustered | gi|470483916|ref|NR_076619.1| | 152260 | g19269 | i0 | 81.902 | 3.55464480874317 | 326 | 54 | 88 | 4 | 45 | 366 | 1337 | 1661 | Chloroflexus aggregans strain MD-66 23S ribosomal RNA gene, complete sequence | blastn | 1301 | 270 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexus | Chloroflexus aggregans | ||
| 13523400 | 13523400 | PRJNA788929_P_NODE_49711_length_200_cov_6.425197_g49050_i0 | PRJNA788929 | 49711 | 200 | 6.425197 | 12.850394 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 113 | 7.860000000000001e-21 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g49050 | i0 | 80.986 | 1.52 | 142 | 27 | 71 | 0 | 19 | 160 | 1451891 | 1452032 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 304 | 113 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 17347309 | 17347309 | PRJNA788929_P_NODE_11014_length_531_cov_43.683406_g10361_i0 | PRJNA788929 | 11014 | 531 | 43.683406 | 231.95888586 | Phototrophicus methaneseepsis | 2710758 | Bacteria | Bacteria | 736 | 0 | NTclustered | gi|1932369605|gb|CP062983.1| | 2710758 | g10361 | i0 | 94.715 | 114.69868173258 | 473 | 25 | 89 | 0 | 36 | 508 | 4993626 | 4994098 | Phototrophicus methaneseepsis strain ZRK33 chromosome, complete genome | blastn | 60905 | 736 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Thermofontia | Phototrophicales | Phototrophicaceae | Phototrophicus | Phototrophicus methaneseepsis | ||
| 17347857 | 17347857 | PRJNA788929_P_NODE_43894_length_234_cov_22.310559_g43233_i0 | PRJNA788929 | 43894 | 234 | 22.310559 | 52.20670806 | Aggregatilineales bacterium | 2952883 | Bacteria | Bacteria | 124 | 4.38e-24 | NTclustered | gi|2621701642|emb|OY760398.1| | 2952883 | g43233 | i0 | 80.114 | 4.76495726495726 | 176 | 27 | 73 | 8 | 64 | 234 | 380999 | 381171 | MAG: Aggregatilineales bacterium isolate 948f1344-b363-40c2-9c6d-9b25e8b84bf3 genome assembly, chromosome: 1 | blastn | 1115 | 124 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Aggregatilineales | Aggregatilineales bacterium | ||||
| 17347918 | 17347918 | PRJNA788929_P_NODE_48914_length_205_cov_7.772727_g48253_i0 | PRJNA788929 | 48914 | 205 | 7.772727 | 15.93409035 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 68.6 | 8.48e-13 | NR | MDX1520193.1 | 2052143 | g48253 | i0 | 64.7 | 1.24390243902439 | 51 | 17 | 73.2 | 1 | 36 | 185 | 3 | 53 | MDX1520193.1 thioredoxin [Anaerolineae bacterium] | diamond | 255 | 68.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 23722258 | 23722258 | PRJNA788929_P_NODE_35699_length_260_cov_1.336898_g35038_i0 | PRJNA788929 | 35699 | 260 | 1.336898 | 3.4759348 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 112 | 3.11e-28 | NR | MCX7681007.1 | 2052143 | g35038 | i0 | 66.7 | 3.76153846153846 | 84 | 23 | 91.2 | 1 | 260 | 24 | 43 | 126 | MCX7681007.1 hypothetical protein [Anaerolineae bacterium] | diamond | 978 | 112 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 24995892 | 24995892 | PRJNA788929_P_NODE_31340_length_280_cov_33.429952_g30679_i0 | PRJNA788929 | 31340 | 280 | 33.429952 | 93.6038656 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 169 | 2.46e-37 | NTclustered | gi|2874254132|emb|OY970217.1| | 1672391 | g30679 | i0 | 80.617 | 211.132142857143 | 227 | 37 | 80 | 5 | 33 | 257 | 3521942 | 3521721 | MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1 | blastn | 59117 | 169 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 26736767 | 26736767 | PRJNA788929_P_NODE_48321_length_209_cov_5.551471_g47660_i0 | PRJNA788929 | 48321 | 209 | 5.551471 | 11.60257439 | Roseiflexaceae bacterium | 2762507 | Bacteria | Bacteria | 65.1 | 4.76e-11 | NR | HEX9369688.1 | 2762507 | g47660 | i0 | 59.2 | 1.36363636363636 | 49 | 20 | 70.3 | 0 | 3 | 149 | 119 | 167 | HEX9369688.1 protease inhibitor I42 family protein [Roseiflexaceae bacterium] | diamond | 285 | 65.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexaceae bacterium | |||
| 26958575 | 26958575 | PRJNA788929_P_NODE_45962_length_224_cov_6.668874_g45301_i0 | PRJNA788929 | 45962 | 224 | 6.668874 | 14.93827776 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 80.5 | 1.46e-15 | NR | TME72274.1 | 2026724 | g45301 | i0 | 63 | 2.87946428571429 | 54 | 20 | 72.3 | 0 | 185 | 24 | 154 | 207 | TME72274.1 MAG: alpha/beta fold hydrolase [Chloroflexota bacterium] | diamond | 645 | 80.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27053777 | 27053777 | PRJNA788929_P_NODE_25142_length_319_cov_14.764228_g24481_i0 | PRJNA788929 | 25142 | 319 | 14.764228 | 47.09788732 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 127 | 1.4e-35 | NR | PLS82506.1 | 2026724 | g24481 | i0 | 68.1 | 1.57993730407524 | 91 | 27 | 85.6 | 1 | 39 | 311 | 1 | 89 | PLS82506.1 MAG: FmdB family transcriptional regulator [Chloroflexota bacterium] | diamond | 504 | 127 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 28001463 | 28001463 | PRJNA788929_P_NODE_21905_length_347_cov_18.540146_g21244_i0 | PRJNA788929 | 21905 | 347 | 18.540146 | 64.33430662 | Caldilineaceae bacterium | 2614250 | Bacteria | Bacteria | 43.1 | 0.04 | NR | MCB0075671.1 | 2614250 | g21244 | i0 | 29.6 | 1.8328530259366 | 108 | 65 | 89 | 4 | 2 | 310 | 52 | 153 | MCB0075671.1 sugar ABC transporter permease [Caldilineaceae bacterium] | diamond | 636 | 43.1 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | Caldilineaceae bacterium | |||
| 28948726 | 28948726 | PRJNA788929_P_NODE_31508_length_280_cov_1.280193_g30847_i0 | PRJNA788929 | 31508 | 280 | 1.280193 | 3.5845404 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 151 | 1.59e-41 | NR | MEP7081584.1 | 2026724 | g30847 | i0 | 82.8 | 2.98928571428571 | 93 | 16 | 99.6 | 0 | 1 | 279 | 40 | 132 | MEP7081584.1 MFS transporter [Chloroflexota bacterium] | diamond | 837 | 151 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29864143 | 29864143 | PRJNA788929_P_NODE_20151_length_364_cov_12.604811_g19491_i0 | PRJNA788929 | 20151 | 364 | 12.604811 | 45.88151204 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 154 | 1.84e-43 | NR | MCA9913853.1 | 2052143 | g19491 | i0 | 69.4 | 3.64285714285714 | 108 | 33 | 89 | 0 | 347 | 24 | 164 | 271 | MCA9913853.1 hydantoinase/oxoprolinase family protein [Anaerolineae bacterium] | diamond | 1326 | 154 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 30275144 | 30275144 | PRJNA788929_P_NODE_28972_length_294_cov_2.420814_g28311_i0 | PRJNA788929 | 28972 | 294 | 2.420814 | 7.11719316 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 55.8 | 1.06e-7 | NR | HKZ82086.1 | 2052143 | g28311 | i0 | 51.9 | 0.551020408163265 | 54 | 25 | 55.1 | 1 | 246 | 85 | 4 | 56 | HKZ82086.1 hypothetical protein [Anaerolineae bacterium] | diamond | 162 | 55.8 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31381089 | 31381089 | PRJNA788929_P_NODE_39456_length_247_cov_11.344828_g38795_i0 | PRJNA788929 | 39456 | 247 | 11.344828 | 28.02172516 | Chloroflexaceae bacterium | 2562117 | Bacteria | Bacteria | 120 | 1.15e-29 | NR | MCU0490747.1 | 2562117 | g38795 | i0 | 72.2 | 0.874493927125506 | 72 | 20 | 87.4 | 0 | 225 | 10 | 76 | 147 | MCU0490747.1 glucose-6-phosphate dehydrogenase [Chloroflexaceae bacterium] | diamond | 216 | 120 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Chloroflexaceae | Chloroflexaceae bacterium | |||
| 31453541 | 31453541 | PRJNA788929_P_NODE_25116_length_319_cov_21.743902_g24455_i0 | PRJNA788929 | 25116 | 319 | 21.743902 | 69.36304738 | Bacillati | 1783272 | Bacteria | Bacteria | 75.9 | 2.87e-15 | NR | HKV59494.1 | 2740538 | g24455 | i0 | 60.8 | 1.52351097178683 | 51 | 20 | 48 | 0 | 282 | 130 | 44 | 94 | HKV59494.1 endo-1,4-beta-xylanase [Ktedonobacteraceae bacterium] | diamond | 486 | 76.6 | 0.990861618798956 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium |
Advanced export
JSON shape: default, array, newline-delimited
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);;