contig_metadata
21 rows where bioproject = "PRJEB75017", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2270677 | 2270677 | PRJEB75017_P_NODE_14662_length_251_cov_0.876404_g14533_i0 | PRJEB75017 | 14662 | 251 | 0.876404 | 2.19977404 | Bacteria | 2 | Bacteria | Bacteria | 68.2 | 4.15e-11 | NR | MCI0395476.1 | 2026724 | g14533 | i0 | 60 | 6.37051792828685 | 45 | 18 | 53.8 | 0 | 251 | 117 | 231 | 275 | MCI0395476.1 acetylornithine transaminase [Chloroflexota bacterium] | diamond | 1599 | 68.6 | 0.994169096209913 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 2685392 | 2685392 | PRJEB75017_P_NODE_12823_length_261_cov_1.659574_g12694_i0 | PRJEB75017 | 12823 | 261 | 1.659574 | 4.33148814 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 318 | 2.1299999999999995e-82 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g12694 | i0 | 90.496 | 324.785440613027 | 242 | 21 | 93 | 2 | 1 | 242 | 1028361 | 1028600 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 84769 | 318 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 15437902 | 15437902 | PRJEB75017_P_NODE_7853_length_320_cov_1.578947_g7724_i0 | PRJEB75017 | 7853 | 320 | 1.578947 | 5.0526304 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 61.6 | 2.01e-8 | NR | MBX3080779.1 | 2052143 | g7724 | i0 | 56 | 2.08125 | 50 | 22 | 46.9 | 0 | 151 | 2 | 3 | 52 | MBX3080779.1 ornithine--oxo-acid transaminase [Anaerolineae bacterium] | diamond | 666 | 61.6 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 19261000 | 19261000 | PRJEB75017_P_NODE_7236_length_332_cov_1.200772_g7107_i0 | PRJEB75017 | 7236 | 332 | 1.200772 | 3.98656304 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 544 | 4.23e-150 | NTclustered | gi|2874253812|emb|OY969796.1| | 1672391 | g7107 | i0 | 96.364 | 699.388554216867 | 330 | 12 | 99 | 0 | 1 | 330 | 3032482 | 3032153 | MAG: uncultured Chloroflexia bacterium isolate MFD01872.bin.1.103 genome assembly, chromosome: 1 | blastn | 232197 | 544 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 20122098 | 20122098 | PRJEB75017_P_NODE_9036_length_301_cov_1.026316_g8907_i0 | PRJEB75017 | 9036 | 301 | 1.026316 | 3.08921116 | Anaerolinea sp. | 1872519 | Bacteria | Bacteria | 181 | 1.99e-51 | NR | MFQ3647495.1 | 1872519 | g8907 | i0 | 82.7 | 8.90033222591362 | 98 | 17 | 97.7 | 0 | 2 | 295 | 268 | 365 | MFQ3647495.1 phosphoenolpyruvate carboxykinase (GTP) [Anaerolinea sp.] | diamond | 2679 | 181 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolinea | Anaerolinea sp. | ||
| 23087154 | 23087154 | PRJEB75017_P_NODE_17539_length_244_cov_0.912281_g17410_i0 | PRJEB75017 | 17539 | 244 | 0.912281 | 2.22596564 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 67.6 | 7.86e-7 | NTclustered | gi|2621704004|emb|OY762959.1| | 2026734 | g17410 | i0 | 100 | 7.62704918032787 | 36 | 0 | 15 | 0 | 209 | 244 | 2311566 | 2311531 | MAG: Dehalococcoidia bacterium isolate a8fc5444-7059-4be1-bdcb-92646be6befe genome assembly, chromosome: 1 | blastn | 1861 | 67.6 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 26907591 | 26907591 | PRJEB75017_P_NODE_14242_length_252_cov_0.871508_g14113_i0 | PRJEB75017 | 14242 | 252 | 0.871508 | 2.19620016 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 63.5 | 2e-9 | NR | MCB9078591.1 | 2024896 | g14113 | i0 | 39.3 | 1 | 84 | 51 | 100 | 0 | 252 | 1 | 626 | 709 | MCB9078591.1 MFS transporter [Anaerolineaceae bacterium] | diamond | 252 | 63.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 27255334 | 27255334 | PRJEB75017_P_NODE_17543_length_244_cov_0.912281_g17414_i0 | PRJEB75017 | 17543 | 244 | 0.912281 | 2.22596564 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 53.9 | 4.12e-6 | NR | MDQ3655600.1 | 2026724 | g17414 | i0 | 88.9 | 0.663934426229508 | 27 | 3 | 33.2 | 0 | 83 | 3 | 1 | 27 | MDQ3655600.1 nicotinate phosphoribosyltransferase [Chloroflexota bacterium] | diamond | 162 | 53.9 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 27539803 | 27539803 | PRJEB75017_P_NODE_4004_length_438_cov_1.282192_g3875_i0 | PRJEB75017 | 4004 | 438 | 1.282192 | 5.61600096 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 84.7 | 7.15e-16 | NR | MBN1921620.1 | 2052143 | g3875 | i0 | 41.7 | 0.73972602739726 | 108 | 61 | 73.3 | 2 | 328 | 8 | 244 | 350 | MBN1921620.1 hypothetical protein [Anaerolineae bacterium] | diamond | 324 | 84.7 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 27697971 | 27697971 | PRJEB75017_P_NODE_4404_length_418_cov_1.130435_g4275_i0 | PRJEB75017 | 4404 | 418 | 1.130435 | 4.7252183 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 77.4 | 1.4e-13 | NR | MEO8610839.1 | 2026724 | g4275 | i0 | 40 | 1.81578947368421 | 130 | 75 | 93.3 | 3 | 395 | 6 | 1 | 127 | MEO8610839.1 NAD(P)/FAD-dependent oxidoreductase [Chloroflexota bacterium] | diamond | 759 | 77.4 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 29679193 | 29679193 | PRJEB75017_P_NODE_11950_length_270_cov_1.142132_g11821_i0 | PRJEB75017 | 11950 | 270 | 1.142132 | 3.0837564 | PVC group | 1783257 | Bacteria | Bacteria | 93.6 | 1.9600000000000003e-21 | NR | RPI87655.1 | 2026724 | g11821 | i0 | 51.1 | 4 | 90 | 44 | 100 | 0 | 270 | 1 | 93 | 182 | RPI87655.1 MAG: fasciclin domain-containing protein [Chloroflexota bacterium] | diamond | 1080 | 93.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30634282 | 30634282 | PRJEB75017_P_NODE_12193_length_267_cov_2.206186_g12064_i0 | PRJEB75017 | 12193 | 267 | 2.206186 | 5.89051662 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 43.5 | 0.0258 | NR | MCH7554365.1 | 2026724 | g12064 | i0 | 55.3 | 0.853932584269663 | 38 | 17 | 42.7 | 0 | 2 | 115 | 455 | 492 | MCH7554365.1 CCA tRNA nucleotidyltransferase [Chloroflexota bacterium] | diamond | 228 | 43.5 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 30919049 | 30919049 | PRJEB75017_P_NODE_3154_length_493_cov_1.297619_g3025_i0 | PRJEB75017 | 3154 | 493 | 1.297619 | 6.39726167 | Dehalococcoidia bacterium SG8_51_3 | 1703394 | Bacteria | Bacteria | 104 | 1.57e-22 | NR | KPK19135.1 | 1703394 | g3025 | i0 | 42.7 | 1.91683569979716 | 157 | 84 | 95.5 | 5 | 21 | 491 | 262 | 412 | KPK19135.1 MAG: hypothetical protein AMJ70_09185 [Dehalococcoidia bacterium SG8_51_3] | diamond | 945 | 104 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium SG8_51_3 | |||||
| 30943347 | 30943347 | PRJEB75017_P_NODE_9514_length_294_cov_1.411765_g9385_i0 | PRJEB75017 | 9514 | 294 | 1.411765 | 4.1505891 | Bacteria | 2 | Bacteria | Bacteria | 44.7 | 0.0129 | NR | MEA2546052.1 | 2026724 | g9385 | i0 | 41.5 | 1.66326530612245 | 53 | 31 | 54.1 | 0 | 129 | 287 | 45 | 97 | MEA2546052.1 hypothetical protein [Chloroflexota bacterium] | diamond | 489 | 44.7 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31171361 | 31171361 | PRJEB75017_P_NODE_7695_length_323_cov_1.248000_g7566_i0 | PRJEB75017 | 7695 | 323 | 1.248 | 4.03104 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 53.1 | 2.16e-5 | NR | MCX6029514.1 | 2026724 | g7566 | i0 | 38.9 | 0.835913312693498 | 90 | 42 | 77.1 | 4 | 56 | 304 | 857 | 940 | MCX6029514.1 carboxypeptidase regulatory-like domain-containing protein [Chloroflexota bacterium] | diamond | 270 | 53.1 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31202735 | 31202735 | PRJEB75017_P_NODE_4695_length_405_cov_1.156627_g4566_i0 | PRJEB75017 | 4695 | 405 | 1.156627 | 4.68433935 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 56.6 | 2.5e-6 | NR | HEY85541.1 | 2026724 | g4566 | i0 | 59.5 | 2.80740740740741 | 42 | 17 | 31.1 | 0 | 403 | 278 | 276 | 317 | HEY85541.1 DnaJ domain-containing protein [Chloroflexota bacterium] | diamond | 1137 | 56.6 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31393138 | 31393138 | PRJEB75017_P_NODE_16676_length_246_cov_0.901734_g16547_i0 | PRJEB75017 | 16676 | 246 | 0.901734 | 2.21826564 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 152 | 5.51e-44 | NR | MCX6044186.1 | 2026724 | g16547 | i0 | 82.9 | 2 | 82 | 14 | 100 | 0 | 1 | 246 | 168 | 249 | MCX6044186.1 glycosyltransferase family 2 protein [Chloroflexota bacterium] | diamond | 492 | 152 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31645861 | 31645861 | PRJEB75017_P_NODE_6077_length_358_cov_1.750877_g5948_i0 | PRJEB75017 | 6077 | 358 | 1.750877 | 6.26813966 | Chloroflexota bacterium | 2026724 | Bacteria | Bacteria | 140 | 6.81e-36 | NR | MDQ4074795.1 | 2026724 | g5948 | i0 | 63 | 4.06424581005587 | 119 | 43 | 99.7 | 1 | 358 | 2 | 93 | 210 | MDQ4074795.1 sodium-translocating pyrophosphatase [Chloroflexota bacterium] | diamond | 1455 | 140 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 31702041 | 31702041 | PRJEB75017_P_NODE_7337_length_330_cov_1.214008_g7208_i0 | PRJEB75017 | 7337 | 330 | 1.214008 | 4.0062264 | FCB group | 1783270 | Bacteria | Bacteria | 52.4 | 4.01e-5 | NR | NPA91048.1 | 2026724 | g7208 | i0 | 44.4 | 3.78181818181818 | 72 | 36 | 63.6 | 4 | 80 | 289 | 163 | 232 | NPA91048.1 DUF4139 domain-containing protein [Chloroflexota bacterium] | diamond | 1248 | 52.8 | 0.992424242424242 | Bacteria | Bacillati | Chloroflexota | Chloroflexota bacterium | ||||||
| 32057238 | 32057238 | PRJEB75017_P_NODE_18458_length_242_cov_0.923077_g18329_i0 | PRJEB75017 | 18458 | 242 | 0.923077 | 2.23384634 | Ktedonobacteraceae bacterium | 2740538 | Bacteria | Bacteria | 57 | 9.16e-8 | NR | HEY5005937.1 | 2740538 | g18329 | i0 | 60 | 0.495867768595041 | 40 | 16 | 49.6 | 0 | 122 | 241 | 45 | 84 | HEY5005937.1 arylamine N-acetyltransferase [Ktedonobacteraceae bacterium] | diamond | 120 | 57 | 1 | Bacteria | Bacillati | Chloroflexota | Ktedonobacteria | Ktedonobacterales | Ktedonobacteraceae | Ktedonobacteraceae bacterium | |||
| 32745353 | 32745353 | PRJEB75017_P_NODE_15080_length_250_cov_0.881356_g14951_i0 | PRJEB75017 | 15080 | 250 | 0.881356 | 2.20339 | PVC group | 1783257 | Bacteria | Bacteria | 45.8 | 0.00324 | NR | MBI1281963.1 | 2024896 | g14951 | i0 | 41.3 | 1.752 | 63 | 37 | 75.6 | 0 | 34 | 222 | 290 | 352 | MBI1281963.1 SH3 domain-containing protein [Anaerolineaceae bacterium] | diamond | 438 | 46.2 | 0.991341991341991 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae 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);;