contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA857857" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 844910 | 844910 | PRJNA857857_P_NODE_25281_length_309_cov_2.283898_g24832_i0 | PRJNA857857 | 25281 | 309 | 2.283898 | 7.05724482 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 102 | 2.82e-17 | NTclustered | gi|2694137334|ref|XM_063544526.1| | 6551 | g24832 | i0 | 83.962 | 8.71844660194175 | 106 | 17 | 34 | 0 | 15 | 120 | 327 | 222 | PREDICTED: Mytilus trossulus protein arginine N-methyltransferase 1-like (LOC134685094), transcript variant X2, mRNA | blastn | 2694 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 3395346 | 3395346 | PRJNA857857_P_NODE_12383_length_448_cov_0.776000_g11939_i0 | PRJNA857857 | 12383 | 448 | 0.776 | 3.47648 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.012 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g11939 | i0 | 100 | 0.0647321428571429 | 29 | 0 | 6 | 0 | 5 | 33 | 7207772 | 7207744 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7222919 | 7222919 | PRJNA857857_P_NODE_16326_length_389_cov_1.462025_g15879_i0 | PRJNA857857 | 16326 | 389 | 1.462025 | 5.68727725 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 2.22e-4 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g15879 | i0 | 100 | 1.6401028277635 | 32 | 0 | 8 | 0 | 224 | 255 | 23348388 | 23348357 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 638 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12324304 | 12324304 | PRJNA857857_P_NODE_34530_length_260_cov_0.796791_g34081_i0 | PRJNA857857 | 34530 | 260 | 0.796791 | 2.0716566 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 3.94e-5 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g34081 | i0 | 89.796 | 15.0346153846154 | 49 | 3 | 18 | 2 | 121 | 168 | 23247323 | 23247370 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 3909 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12324320 | 12324320 | PRJNA857857_P_NODE_36090_length_253_cov_1.094444_g35641_i0 | PRJNA857857 | 36090 | 253 | 1.094444 | 2.76894332 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g35641 | i0 | 100 | 0.110671936758893 | 28 | 0 | 11 | 0 | 224 | 251 | 44563727 | 44563754 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19971345 | 19971345 | PRJNA857857_P_NODE_17936_length_371_cov_1.016779_g17488_i0 | PRJNA857857 | 17936 | 371 | 1.016779 | 3.77225009 | Haliotis asinina | 109174 | Mollusca | Mollusca | 54.7 | 0.01 | NTclustered | gi|2793377972|ref|XM_067800243.1| | 109174 | g17488 | i0 | 100 | 0.078167115902965 | 29 | 0 | 8 | 0 | 307 | 335 | 2140 | 2112 | PREDICTED: Haliotis asinina E3 ubiquitin-protein ligase TM129-like (LOC137264888), transcript variant X1, mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 19971877 | 19971877 | PRJNA857857_P_NODE_44796_length_246_cov_0.890173_g44347_i0 | PRJNA857857 | 44796 | 246 | 0.890173 | 2.18982558 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g44347 | i0 | 96.875 | 2.41463414634146 | 32 | 1 | 13 | 0 | 25 | 56 | 23842211 | 23842242 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 594 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22521678 | 22521678 | PRJNA857857_P_NODE_27658_length_294_cov_1.719457_g27209_i0 | PRJNA857857 | 27658 | 294 | 1.719457 | 5.05520358 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 171 | 7.22e-38 | NTclustered | gi|2616578099|ref|XM_060719915.1| | 129788 | g27209 | i0 | 81.773 | 17.6054421768707 | 203 | 37 | 69 | 0 | 1 | 203 | 360 | 158 | PREDICTED: Ruditapes philippinarum ras-related protein Rab-1A (LOC132733296), transcript variant X2, mRNA | blastn | 5176 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum |
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);;