contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA627467" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9527556 | 9527556 | PRJNA627467_P_NODE_16628_length_166_cov_2.495726_g16559_i0 | PRJNA627467 | 16628 | 166 | 2.495726 | 4.14290516 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 182 | 1.7e-41 | NTclustered | gi|2874254066|emb|OY970149.1| | 1672391 | g16559 | i0 | 86.957 | 1.93975903614458 | 161 | 21 | 97 | 0 | 6 | 166 | 523504 | 523344 | MAG: uncultured Chloroflexia bacterium isolate MFD05747.bin.c.2 genome assembly, chromosome: 1 | blastn | 322 | 182 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 10079393 | 10079393 | PRJNA627467_P_NODE_5528_length_316_cov_1.539326_g5460_i0 | PRJNA627467 | 5528 | 316 | 1.539326 | 4.86427016 | Bacteria | 2 | Bacteria | Bacteria | 135 | 2.86e-27 | NTclustered | gi|297181775|gb|GU474878.1| | 710736 | g5460 | i0 | 92.632 | 44.8037974683544 | 95 | 6 | 30 | 1 | 217 | 310 | 9308 | 9214 | Uncultured Chloroflexi bacterium HF0200_09I09 genomic sequence | blastn | 14158 | 135 | 1 | Bacteria | Bacillati | Chloroflexota | uncultured Chloroflexi bacterium HF0200_09I09 | ||||||
| 12078462 | 12078462 | PRJNA627467_P_NODE_10010_length_188_cov_1.136691_g9941_i0 | PRJNA627467 | 10010 | 188 | 1.136691 | 2.13697908 | Anaerolineaceae bacterium | 2024896 | Bacteria | Bacteria | 56.5 | 0.001 | NTclustered | gi|2621713652|emb|OY771913.1| | 2024896 | g9941 | i0 | 94.595 | 0.393617021276596 | 37 | 0 | 20 | 1 | 5 | 41 | 1891097 | 1891131 | MAG: Anaerolineaceae bacterium isolate c74f872c-e933-4053-8305-e1536b6d7914 genome assembly, chromosome: 1 | blastn | 74 | 56.5 | 1 | Bacteria | Bacillati | Chloroflexota | Anaerolineae | Anaerolineales | Anaerolineaceae | Anaerolineaceae bacterium | |||
| 17177088 | 17177088 | PRJNA627467_P_NODE_15794_length_168_cov_2.436975_g15725_i0 | PRJNA627467 | 15794 | 168 | 2.436975 | 4.094118 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 143 | 8.139999999999998e-30 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g15725 | i0 | 95.506 | 40.4285714285714 | 89 | 4 | 53 | 0 | 80 | 168 | 2760394 | 2760482 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 6792 | 143 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 21001508 | 21001508 | PRJNA627467_P_NODE_16457_length_167_cov_0.864407_g16388_i0 | PRJNA627467 | 16457 | 167 | 0.864407 | 1.44355969 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 250 | 4.63e-62 | NTclustered | gi|2874254102|emb|OY970185.1| | 1672391 | g16388 | i0 | 94.444 | 48.9760479041916 | 162 | 9 | 97 | 0 | 4 | 165 | 2477024 | 2476863 | MAG: uncultured Chloroflexia bacterium isolate MFD06435.bin.c.3 genome assembly, chromosome: 1 | blastn | 8179 | 250 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 22276303 | 22276303 | PRJNA627467_P_NODE_18698_length_162_cov_1.769912_g18629_i0 | PRJNA627467 | 18698 | 162 | 1.769912 | 2.86725744 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 235 | 1.25e-57 | NTclustered | gi|2874254132|emb|OY970217.1| | 1672391 | g18629 | i0 | 93.631 | 507.191358024691 | 157 | 10 | 97 | 0 | 5 | 161 | 3523321 | 3523477 | MAG: uncultured Chloroflexia bacterium isolate MFD05684.bin.1.130 genome assembly, chromosome: 1 | blastn | 82165 | 235 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia 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);;