contig_metadata
6 rows where bioproject = "PRJNA896973" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7251140 | 7251140 | PRJNA896973_P_NODE_13326_length_306_cov_2.545064_g13232_i0 | PRJNA896973 | 13326 | 306 | 2.545064 | 7.78789584 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 246 | 1.22e-60 | NTclustered | gi|2874253860|emb|OY969916.1| | 1672391 | g13232 | i0 | 81.41 | 174.107843137255 | 312 | 48 | 100 | 9 | 1 | 306 | 274891 | 274584 | MAG: uncultured Chloroflexia bacterium isolate MFD01916.bin.3.39 genome assembly, chromosome: 1 | blastn | 53277 | 246 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 18724919 | 18724919 | PRJNA896973_S_NODE_1255_length_336_cov_1.349810_g1241_i0 | PRJNA896973 | 1255 | 336 | 1.34981 | 4.5353616 | Dehalococcoidia bacterium | 2026734 | Bacteria | Bacteria | 84.2 | 1.12e-11 | NTclustered | gi|2621704923|emb|OY762210.1| | 2026734 | g1241 | i0 | 84.444 | 26.3214285714286 | 90 | 8 | 26 | 5 | 186 | 273 | 855132 | 855217 | MAG: Dehalococcoidia bacterium isolate 6876e8b5-2850-4095-a133-48836ebfd8cd genome assembly, chromosome: 1 | blastn | 8844 | 84.2 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidia bacterium | |||||
| 26707218 | 26707218 | PRJNA896973_P_NODE_17601_length_274_cov_1.273632_g17507_i0 | PRJNA896973 | 17601 | 274 | 1.273632 | 3.48975168 | Dehalococcoides mccartyi | 61435 | Bacteria | Bacteria | 46.6 | 0.00236 | NR | WP_278533022.1 | 61435 | g17507 | i0 | 52.3 | 0.481751824817518 | 44 | 21 | 48.2 | 0 | 125 | 256 | 415 | 458 | WP_278533022.1 Eco57I restriction-modification methylase domain-containing protein [Dehalococcoides mccartyi] | diamond | 132 | 46.6 | 1 | Bacteria | Bacillati | Chloroflexota | Dehalococcoidia | Dehalococcoidales | Dehalococcoidaceae | Dehalococcoides | Dehalococcoides mccartyi | ||
| 27498211 | 27498211 | PRJNA896973_P_NODE_23483_length_248_cov_0.880000_g23389_i0 | PRJNA896973 | 23483 | 248 | 0.88 | 2.1824 | Herpetosiphonaceae bacterium | 2720503 | Bacteria | Bacteria | 112 | 3.28e-29 | NR | HZG68542.1 | 2720503 | g23389 | i0 | 70.7 | 1.98387096774194 | 82 | 20 | 99.2 | 1 | 247 | 2 | 107 | 184 | HZG68542.1 IS630 family transposase [Herpetosiphonaceae bacterium] | diamond | 492 | 112 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Herpetosiphonales | Herpetosiphonaceae | Herpetosiphonaceae bacterium | |||
| 29329347 | 29329347 | PRJNA896973_S_NODE_149_length_1011_cov_3.554371_g143_i0 | PRJNA896973 | 149 | 1011 | 3.554371 | 35.93469081 | Anaerolineae bacterium | 2052143 | Bacteria | Bacteria | 331 | 3.9999999999999996e-110 | NR | MCL6509824.1 | 2052143 | g143 | i0 | 79.2 | 1.22848664688427 | 207 | 43 | 61.4 | 0 | 704 | 84 | 50 | 256 | MCL6509824.1 conjugal transfer protein TraL [Anaerolineae bacterium] | diamond | 1242 | 331 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineae bacterium | |||||
| 31192785 | 31192785 | PRJNA896973_P_NODE_12495_length_315_cov_0.772727_g12401_i0 | PRJNA896973 | 12495 | 315 | 0.772727 | 2.43409005 | SAR202 cluster bacterium | 2030829 | Bacteria | Bacteria | 43.1 | 0.0348 | NR | MDP6422530.1 | 2030829 | g12401 | i0 | 39.3 | 0.533333333333333 | 56 | 33 | 53.3 | 1 | 256 | 89 | 111 | 165 | MDP6422530.1 hypothetical protein [SAR202 cluster bacterium] | diamond | 168 | 43.1 | 1 | Bacteria | SAR202 cluster | Bacillati | Chloroflexota | Dehalococcoidia | SAR202 cluster 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);;