contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA168635" and tax_phylum = "Xenacoelomorpha"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8017678 | 8017678 | PRJNA168635_P_NODE_14667_length_210_cov_2.906832_g14251_i0 | PRJNA168635 | 14667 | 210 | 2.906832 | 6.1043472 | Nemertoderma westbladi | 172109 | Xenacoelomorpha | other_Eukaryota | 139 | 1.38e-28 | NTclustered | gi|157100013|emb|AM747482.1| | 172109 | g14251 | i0 | 89.815 | 51.4809523809524 | 108 | 11 | 51 | 0 | 1 | 108 | 2081 | 1974 | Nemertoderma westbladi partial 28S rRNA gene, isolate 1 | blastn | 10811 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Nemertodermatida | Nemertodermatidae | Nemertoderma | Nemertoderma westbladi | ||
| 8707154 | 8707154 | PRJNA168635_P_NODE_8787_length_283_cov_5.529915_g8372_i0 | PRJNA168635 | 8787 | 283 | 5.529915 | 15.64965945 | Metazoa | 33208 | Xenacoelomorpha | other_Eukaryota | 71.3 | 7.21e-8 | NTclustered | gi|378781070|emb|FR837824.1| | 996672 | g8372 | i0 | 83.784 | 16.8197879858657 | 74 | 12 | 26 | 0 | 204 | 277 | 1566 | 1639 | Proporus bermudensis partial 28S rRNA gene, specimen voucher AWBer02 | blastn | 4760 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Proporidae | Proporus | Proporus bermudensis | ||
| 18216382 | 18216382 | PRJNA168635_P_NODE_35575_length_150_cov_4.940594_g35159_i0 | PRJNA168635 | 35575 | 150 | 4.940594 | 7.410891 | Symsagittifera roscoffensis | 84072 | Xenacoelomorpha | other_Eukaryota | 121 | 3.3e-23 | NTclustered | gi|2701322754|ref|XR_010164694.1| | 84072 | g35159 | i0 | 91.011 | 30.58 | 89 | 8 | 59 | 0 | 38 | 126 | 111 | 23 | PREDICTED: Symsagittifera roscoffensis large subunit ribosomal RNA (LOC134855907), rRNA | blastn | 4587 | 121 | 1 | Eukaryota | Opisthokonta | Metazoa | Xenacoelomorpha | Acoela | Sagittiferidae | Symsagittifera | Symsagittifera roscoffensis |
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);;