contig_metadata
3 rows where bioproject = "PRJNA340009", tax_clade = "Opisthokonta" and tax_phylum = "Bryozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5495825 | 5495825 | PRJNA340009_P_NODE_40645_length_200_cov_1.298013_g40338_i0 | PRJNA340009 | 40645 | 200 | 1.298013 | 2.596026 | Stylopoma viride | 2865421 | Bryozoa | other_Eukaryota | 82.4 | 2.22e-11 | NTclustered | gi|2075442493|gb|MZ677775.1| | 2865421 | g40338 | i0 | 96 | 14.36 | 50 | 2 | 25 | 0 | 56 | 105 | 3609 | 3658 | Stylopoma viride voucher BLEED1541 large subunit ribosomal RNA gene, partial sequence | blastn | 2872 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Schizoporellidae | Stylopoma | Stylopoma viride | |
| 8045656 | 8045656 | PRJNA340009_P_NODE_59667_length_169_cov_9.116667_g59360_i0 | PRJNA340009 | 59667 | 169 | 9.116667 | 15.40716723 | Plumatella sp. ZHY-2005 | 365321 | Bryozoa | other_Eukaryota | 91.6 | 2.99e-14 | NTclustered | gi|90992874|gb|DQ333339.1| | 365321 | g59360 | i0 | 91.176 | 3.36686390532544 | 68 | 4 | 40 | 2 | 1 | 67 | 355 | 289 | Plumatella sp. ZHY-2005 28S ribosomal RNA gene, partial sequence | blastn | 569 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Phylactolaemata | Plumatellidae | Plumatella | Plumatella sp. ZHY-2005 | ||
| 9998076 | 9998076 | PRJNA340009_P_NODE_16208_length_295_cov_14.658537_g15901_i0 | PRJNA340009 | 16208 | 295 | 14.658537 | 43.24268415 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 88.6 | 2.29e-18 | NR | KAF6024418.1 | 10212 | g15901 | i0 | 75.9 | 15.9254237288136 | 58 | 14 | 59 | 0 | 188 | 15 | 296 | 353 | KAF6024418.1 PSMC1 [Bugula neritina] | diamond | 4698 | 89.4 | 0.991051454138702 | Eukaryota | Opisthokonta | Metazoa | Bryozoa | Gymnolaemata | Cheilostomatida | Bugulidae | Bugula | Bugula neritina |
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);;