contig_metadata
2 rows where analysis = "blastn", bioproject = "PRJNA229468" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4884540 | 4884540 | PRJNA229468_S_NODE_144_length_403_cov_3.576271_g131_i0 | PRJNA229468 | 144 | 403 | 3.576271 | 14.41237213 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 499 | 1.15e-136 | NTclustered | gi|330841829|ref|XM_003292845.1| | 5786 | g131 | i0 | 89.421 | 97.8957816377171 | 397 | 40 | 98 | 2 | 8 | 403 | 550 | 945 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_73394), mRNA | blastn | 39452 | 499 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 14396337 | 14396337 | PRJNA229468_S_NODE_412_length_244_cov_2.041026_g399_i0 | PRJNA229468 | 412 | 244 | 2.041026 | 4.98010344 | Lamproderma scintillans | 1115720 | Evosea | other_Eukaryota | 254 | 5.62e-63 | NTclustered | gi|2306687673|gb|MZ234286.1| | 1115720 | g399 | i0 | 85.597 | 73.0409836065574 | 243 | 33 | 99 | 2 | 3 | 244 | 161 | 402 | Lamproderma scintillans voucher LE297459 translation elongation factor EF-1 alpha (EF1A) gene, partial cds | blastn | 17822 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Lamproderma | Lamproderma scintillans |
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);;