contig_metadata
3 rows where bioproject = "PRJNA594101", tax_clade = "Amoebozoa" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 14595987 | 14595987 | PRJNA594101_S_NODE_34832_length_293_cov_1.209091_g34530_i0 | PRJNA594101 | 34832 | 293 | 1.209091 | 3.54263663 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 438 | 1.7799999999999999e-118 | NTclustered | gi|844573744|gb|KP411223.1| | 5775 | g34530 | i0 | 93.603 | 1.01365187713311 | 297 | 14 | 100 | 3 | 1 | 293 | 317 | 22 | Amoeba proteus Tom40 mRNA, complete cds | blastn | 297 | 438 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 27142588 | 27142588 | PRJNA594101_S_NODE_25902_length_333_cov_1.319231_g25600_i0 | PRJNA594101 | 25902 | 333 | 1.319231 | 4.39303923 | Heleopera sphagni | 318526 | Tubulinea | other_Eukaryota | 50.4 | 1.82e-4 | NR | AFX84544.1 | 318526 | g25600 | i0 | 30.9 | 0.990990990990991 | 110 | 75 | 99.1 | 1 | 4 | 333 | 179 | 287 | AFX84544.1 alpha tubulin, partial [Heleopera sphagni] | diamond | 330 | 50.4 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Arcellinida | Heleoperidae | Heleopera | Heleopera sphagni | ||
| 29209130 | 29209130 | PRJNA594101_S_NODE_35389_length_291_cov_1.059633_g35087_i0 | PRJNA594101 | 35389 | 291 | 1.059633 | 3.08353203 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 105 | 1.15e-25 | NR | ABD46563.1 | 5778 | g35087 | i0 | 46.2 | 3.75257731958763 | 93 | 50 | 95.9 | 0 | 287 | 9 | 49 | 141 | ABD46563.1 succinyl-diaminopimelate desuccinylase-like protein A, partial [Vermamoeba vermiformis] | diamond | 1092 | 106 | 0.990566037735849 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis |
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);;