contig_metadata
7 rows where bioproject = "PRJNA1240805", tax_clade = "Opisthokonta" and tax_phylum = "Mollusca"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1624082 | 1624082 | PRJNA1240805_P_NODE_1842_length_357_cov_393.503247_g1793_i0 | PRJNA1240805 | 1842 | 357 | 393.503247 | 1404.80659179 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.034 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g1793 | i0 | 100 | 0.0784313725490196 | 28 | 0 | 8 | 0 | 123 | 150 | 1 | 28 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 4176588 | 4176588 | PRJNA1240805_P_NODE_3284_length_257_cov_4.735577_g3235_i0 | PRJNA1240805 | 3284 | 257 | 4.735577 | 12.17043289 | Leptochiton asellus | 211853 | Mollusca | Mollusca | 161 | 3.72e-35 | NTclustered | gi|34369208|gb|AY145414.1| | 211853 | g3235 | i0 | 85.35 | 5.78210116731517 | 157 | 22 | 61 | 1 | 19 | 175 | 2546 | 2701 | Leptochiton asellus 28S ribosomal RNA gene, partial sequence | blastn | 1486 | 161 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Lepidopleurida | Lepidopleuridae | Leptochiton | Leptochiton asellus | |
| 10553513 | 10553513 | PRJNA1240805_P_NODE_4769_length_209_cov_7.837500_g4720_i0 | PRJNA1240805 | 4769 | 209 | 7.8375 | 16.380375 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 79 | 7.84e-17 | NR | XP_022294349.1 | 6565 | g4720 | i0 | 68.6 | 6.58851674641148 | 51 | 16 | 73.2 | 0 | 189 | 37 | 79 | 129 | XP_022294349.1 uncharacterized protein LOC111104616 [Crassostrea virginica] | diamond | 1377 | 79 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 13103262 | 13103262 | PRJNA1240805_P_NODE_3551_length_245_cov_6.540816_g3502_i0 | PRJNA1240805 | 3551 | 245 | 6.540816 | 16.0249992 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g3502 | i0 | 100 | 0.114285714285714 | 28 | 0 | 11 | 0 | 5 | 32 | 1 | 28 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 23301866 | 23301866 | PRJNA1240805_P_NODE_4679_length_211_cov_13.265432_g4630_i0 | PRJNA1240805 | 4679 | 211 | 13.265432 | 27.99006152 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 52.8 | 0.019 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g4630 | i0 | 100 | 0.132701421800948 | 28 | 0 | 13 | 0 | 1 | 28 | 31 | 58 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 24575728 | 24575728 | PRJNA1240805_P_NODE_1200_length_455_cov_5.610837_g1152_i0 | PRJNA1240805 | 1200 | 455 | 5.610837 | 25.52930835 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 54.7 | 0.012 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g1152 | i0 | 100 | 0.125274725274725 | 29 | 0 | 6 | 0 | 427 | 455 | 38 | 10 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 24575753 | 24575753 | PRJNA1240805_P_NODE_3180_length_261_cov_24.603774_g3131_i0 | PRJNA1240805 | 3180 | 261 | 24.603774 | 64.21585014 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g3131 | i0 | 100 | 0.111111111111111 | 29 | 0 | 11 | 0 | 1 | 29 | 31 | 59 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii |
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);;