contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA977246" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9879507 | 9879507 | PRJNA977246_S_NODE_34208_length_205_cov_2.289773_g33216_i0 | PRJNA977246 | 34208 | 205 | 2.289773 | 4.69403465 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 185 | 1.69e-42 | NTclustered | gi|2874253698|emb|OY969424.1| | 1672391 | g33216 | i0 | 83.673 | 1.36585365853659 | 196 | 32 | 96 | 0 | 1 | 196 | 431349 | 431154 | MAG: uncultured Chloroflexia bacterium isolate MFD06229.bin.c.1 genome assembly, chromosome: 1 | blastn | 280 | 185 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 11472659 | 11472659 | PRJNA977246_S_NODE_2609_length_1082_cov_8.146249_g2231_i0 | PRJNA977246 | 2609 | 1082 | 8.146249 | 88.14241418 | Bacillati | 1783272 | Bacteria | Bacteria | 409 | 5.67e-109 | NTclustered | gi|470481958|ref|NR_076505.1| | 357808 | g2231 | i0 | 74.333 | 335.125693160813 | 1087 | 221 | 98 | 53 | 21 | 1082 | 8 | 1061 | Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence | blastn | 362606 | 412 | 0.992718446601942 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | Chloroflexales | Roseiflexaceae | Roseiflexus | Roseiflexus sp. RS-1 | ||
| 13704767 | 13704767 | PRJNA977246_S_NODE_24271_length_268_cov_4.200837_g23279_i0 | PRJNA977246 | 24271 | 268 | 4.200837 | 11.25824316 | Phototrophicaceae bacterium | 3069543 | Bacteria | Bacteria | 122 | 1.8399999999999998e-23 | NTclustered | gi|2893358443|emb|OZ220735.1| | 3069543 | g23279 | i0 | 87.619 | 44.7350746268657 | 105 | 13 | 39 | 0 | 1 | 105 | 2878307 | 2878411 | MAG: Phototrophicaceae bacterium isolate 252cb3c6-93c9-4785-98a9-44529c25b936 genome assembly, chromosome: 1 | blastn | 11989 | 122 | 1 | Bacteria | Bacillati | Chloroflexota | Candidatus Thermofontia | Phototrophicales | Phototrophicaceae | Phototrophicaceae bacterium | |||
| 13705137 | 13705137 | PRJNA977246_S_NODE_40011_length_181_cov_5.019737_g39019_i0 | PRJNA977246 | 40011 | 181 | 5.019737 | 9.08572397 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 191 | 3.12e-44 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g39019 | i0 | 90.345 | 5.56353591160221 | 145 | 14 | 80 | 0 | 1 | 145 | 1959140 | 1959284 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 1007 | 191 | 1 | Bacteria | Bacillati | Chloroflexota | Chloroflexia | uncultured Chloroflexia bacterium | |||||
| 18803350 | 18803350 | PRJNA977246_S_NODE_45175_length_165_cov_20.036765_g44183_i0 | PRJNA977246 | 45175 | 165 | 20.036765 | 33.06066225 | uncultured Chloroflexota bacterium | 166587 | Bacteria | Bacteria | 279 | 5.81e-71 | NTclustered | gi|371779831|emb|HE614790.1| | 166587 | g44183 | i0 | 98.125 | 92.9090909090909 | 160 | 3 | 97 | 0 | 1 | 160 | 160 | 1 | Uncultured Chloroflexi bacterium partial 16S rRNA gene, clone H06L-1 | blastn | 15330 | 279 | 1 | Bacteria | Bacillati | Chloroflexota | uncultured Chloroflexota bacterium | ||||||
| 22628000 | 22628000 | PRJNA977246_S_NODE_16578_length_352_cov_3.557276_g15587_i0 | PRJNA977246 | 16578 | 352 | 3.557276 | 12.52161152 | uncultured Chloroflexia bacterium | 1672391 | Bacteria | Bacteria | 429 | 1.32e-115 | NTclustered | gi|2874253981|emb|OY970306.1| | 1672391 | g15587 | i0 | 88.636 | 6.40909090909091 | 352 | 40 | 100 | 0 | 1 | 352 | 1959167 | 1958816 | MAG: uncultured Chloroflexia bacterium isolate MFD02134.bin.c.1 genome assembly, chromosome: 1 | blastn | 2256 | 429 | 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);;