contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA382357" and tax_phylum = "Euglenozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10002838 | 10002838 | PRJNA382357_P_NODE_151428_length_204_cov_0.909091_g150689_i0 | PRJNA382357 | 151428 | 204 | 0.909091 | 1.85454564 | Leishmania | 5658 | Euglenozoa | other_Eukaryota | 54.7 | 0.005 | NTclustered | gi|1751371445|tpg|BK010876.1| | 5670 | g150689 | i0 | 100 | 1.26470588235294 | 29 | 0 | 14 | 0 | 39 | 67 | 5131 | 5159 | TPA_asm: Leishmania guyanensis strain MCAN kinetoplast, complete sequence | blastn | 258 | 54.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leishmania | Leishmania guyanensis | ||
| 11882528 | 11882528 | PRJNA382357_P_NODE_44510_length_346_cov_1.291228_g43771_i0 | PRJNA382357 | 44510 | 346 | 1.291228 | 4.46764888 | Trypanosoma cruzi | 5693 | Euglenozoa | other_Eukaryota | 54.7 | 0.009 | NTclustered | gi|1031970226|gb|CP015660.1| | 85057 | g43771 | i0 | 100 | 0.0838150289017341 | 29 | 0 | 8 | 0 | 185 | 213 | 966345 | 966373 | Trypanosoma cruzi cruzi strain Sylvio X10/cl1 chromosome TcI10, partial sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Trypanosoma | Trypanosoma cruzi | ||
| 16979708 | 16979708 | PRJNA382357_P_NODE_105254_length_236_cov_23.531429_g104515_i0 | PRJNA382357 | 105254 | 236 | 23.531429 | 55.53417244 | Procryptobia sorokini | 351715 | Euglenozoa | other_Eukaryota | 246 | 9.05e-61 | NTclustered | gi|197723538|gb|EF681923.2| | 351715 | g104515 | i0 | 96.026 | 149.970338983051 | 151 | 6 | 100 | 0 | 86 | 236 | 424 | 274 | Procryptobia sorokini strain HFCC98 28S ribosomal RNA gene, partial sequence | blastn | 35393 | 246 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Parabodonida | Procryptobia | Procryptobia sorokini |
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);;