contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA983848" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2243479 | 2243479 | PRJNA983848_P_NODE_161162_length_240_cov_3.185629_g155279_i0 | PRJNA983848 | 161162 | 240 | 3.185629 | 7.6455096 | uncultured Chloroflexota bacterium | 166587 | Bacteria | Bacteria | 261 | 3.2900000000000007e-65 | NTclustered | gi|374855139|dbj|AP011791.1| | 166587 | g155279 | i0 | 86.42 | 169.2625 | 243 | 28 | 100 | 5 | 1 | 240 | 9165 | 8925 | Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06 | blastn | 40623 | 261 | 1 | Bacteria | Bacillati | Chloroflexota | uncultured Chloroflexota bacterium | ||||||
| 3521814 | 3521814 | PRJNA983848_P_NODE_92743_length_316_cov_2.534979_g86860_i0 | PRJNA983848 | 92743 | 316 | 2.534979 | 8.01053364 | uncultured Caldilineaceae bacterium | 543031 | Bacteria | Bacteria | 562 | 1.11e-155 | NTclustered | gi|998645892|gb|KU690221.1| | 543031 | g86860 | i0 | 98.734 | 98.2025316455696 | 316 | 4 | 100 | 0 | 1 | 316 | 389 | 74 | Uncultured Caldilineaceae bacterium clone OTU_2262 16S ribosomal RNA gene, partial sequence | blastn | 31032 | 562 | 1 | Bacteria | Bacillati | Chloroflexota | Caldilineae | Caldilineales | Caldilineaceae | uncultured Caldilineaceae bacterium | |||
| 4795494 | 4795494 | PRJNA983848_P_NODE_140024_length_252_cov_0.871508_g134141_i0 | PRJNA983848 | 140024 | 252 | 0.871508 | 2.19620016 | uncultured Chloroflexota bacterium | 166587 | Bacteria | Bacteria | 237 | 5.88e-58 | NTclustered | gi|374855139|dbj|AP011791.1| | 166587 | g134141 | i0 | 83.73 | 276.52380952381 | 252 | 39 | 99 | 2 | 1 | 251 | 10571 | 10821 | Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF053_H06 | blastn | 69684 | 237 | 1 | Bacteria | Bacillati | Chloroflexota | uncultured Chloroflexota bacterium | ||||||
| 7344650 | 7344650 | PRJNA983848_P_NODE_121226_length_272_cov_1.301508_g115343_i0 | PRJNA983848 | 121226 | 272 | 1.301508 | 3.54010176 | Candidatus Promineifilum breve | 1806508 | Bacteria | Bacteria | 366 | 7.85e-97 | NTclustered | gi|1041165931|emb|LN890655.2| | 1806508 | g115343 | i0 | 91.144 | 127.801470588235 | 271 | 22 | 99 | 2 | 3 | 272 | 597772 | 598041 | Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I | blastn | 34762 | 366 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilum | Candidatus Promineifilum breve | ||
| 17545314 | 17545314 | PRJNA983848_P_NODE_136954_length_253_cov_2.744444_g131071_i0 | PRJNA983848 | 136954 | 253 | 2.744444 | 6.94344332 | Leptolinea sp. HRD-7 | 2830982 | Bacteria | Bacteria | 154 | 6.12e-33 | NTclustered | gi|2250018340|dbj|AP024710.1| | 2830982 | g131071 | i0 | 78.189 | 141.490118577075 | 243 | 51 | 96 | 2 | 4 | 246 | 1243853 | 1243613 | Leptolinea sp. HRD-7 DNA, complete genome | blastn | 35797 | 154 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Leptolinea | Leptolinea sp. HRD-7 | ||
| 22949227 | 22949227 | PRJNA983848_P_NODE_112858_length_283_cov_1.423810_g106975_i0 | PRJNA983848 | 112858 | 283 | 1.42381 | 4.0293823 | Thermobaculum | 262406 | Bacteria | Bacteria | 309 | 1.4e-79 | NTclustered | gi|470485526|ref|NR_076705.1| | 166501 | g106975 | i0 | 89.157 | 124.109540636042 | 249 | 26 | 88 | 1 | 4 | 252 | 2687 | 2934 | Thermobaculum terrenum strain ATCC BAA-798 23S ribosomal RNA gene, complete sequence | blastn | 35123 | 311 | 0.993569131832797 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Candidatus Thermobaculales | Candidatus Thermobaculaceae | Thermobaculum | Thermobaculum terrenum | ||
| 25192705 | 25192705 | PRJNA983848_P_NODE_110720_length_286_cov_1.328638_g104837_i0 | PRJNA983848 | 110720 | 286 | 1.328638 | 3.79990468 | uncultured Anaerolineae bacterium | 452435 | Bacteria | Bacteria | 424 | 4.86e-114 | NTclustered | gi|998644381|gb|KU688710.1| | 452435 | g104837 | i0 | 93.357 | 95.6503496503497 | 286 | 19 | 100 | 0 | 1 | 286 | 143 | 428 | Uncultured Anaerolineae bacterium clone OTU_596 16S ribosomal RNA gene, partial sequence | blastn | 27356 | 424 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | uncultured Anaerolineae bacterium | |||||
| 25192764 | 25192764 | PRJNA983848_P_NODE_112340_length_283_cov_3.595238_g106457_i0 | PRJNA983848 | 112340 | 283 | 3.595238 | 10.17452354 | Candidatus Promineifilum breve | 1806508 | Bacteria | Bacteria | 326 | 1.39e-84 | NTclustered | gi|1041165931|emb|LN890655.2| | 1806508 | g106457 | i0 | 88.722 | 436.427561837456 | 266 | 30 | 94 | 0 | 7 | 272 | 597725 | 597460 | Ardenticatena sp. Cfx-K strain Cfx-K genome assembly, chromosome: I | blastn | 123509 | 326 | 1 | Bacteria | Bacillati | Chloroflexota | Ardenticatenia | Candidatus Promineifilales | Candidatus Promineifilaceae | Candidatus Promineifilum | Candidatus Promineifilum breve |
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);;