contig_metadata
3 rows where bioproject = "PRJNA429937", tax_kingdom = "Metazoa" and tax_phylum = "Platyhelminthes"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 10015903 | 10015903 | PRJNA429937_P_NODE_85588_length_347_cov_8928.490566_g63058_i0 | PRJNA429937 | 85588 | 347 | 8928.490566 | 30981.86226402 | Macrostomum | 39217 | Platyhelminthes | Platyhelminthes | 479 | 1.2699999999999996e-130 | NTclustered | gi|926460157|gb|KR132223.1| | 282301 | g63058 | i0 | 92.353 | 65.2478386167147 | 340 | 20 | 97 | 4 | 10 | 346 | 5549 | 5213 | Macrostomum lignano clone c100550_g1_i1 mRNA sequence | blastn | 22641 | 479 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Rhabditophora | Macrostomida | Macrostomidae | Macrostomum | Macrostomum lignano | |
| 30186908 | 30186908 | PRJNA429937_P_NODE_101932_length_296_cov_6.614232_g79318_i0 | PRJNA429937 | 101932 | 296 | 6.614232 | 19.57812672 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 48.1 | 4.1e-4 | NR | CAH8482491.1 | 57078 | g79318 | i0 | 78.6 | 1.42905405405405 | 28 | 6 | 28.4 | 0 | 48 | 131 | 82 | 109 | CAH8482491.1 unnamed protein product [Dicrocoelium dendriticum] | diamond | 423 | 48.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Dicrocoeliidae | Dicrocoelium | Dicrocoelium dendriticum | |
| 32178866 | 32178866 | PRJNA429937_P_NODE_101778_length_297_cov_2.582090_g79164_i0 | PRJNA429937 | 101778 | 297 | 2.58209 | 7.6688073 | root | 1 | Root_unresolved | Root_unresolved | 45.4 | 0.00798 | NR | KAA3680735.1 | 34504 | g79164 | i0 | 34.6 | 1.90909090909091 | 81 | 49 | 77.8 | 2 | 254 | 24 | 255 | 335 | KAA3680735.1 ATP-dependent DNA helicase Q4 [Paragonimus westermani] | diamond | 567 | 45.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Platyhelminthes | Trematoda | Plagiorchiida | Troglotrematidae | Paragonimus | Paragonimus westermani |
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);;