contig_metadata
19 rows where analysis = "blastn", bioproject = "PRJNA781196" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 759338 | 759338 | PRJNA781196_P_NODE_43181_length_273_cov_1.000000_g42804_i0 | PRJNA781196 | 43181 | 273 | 1 | 2.73 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 119 | 2.44e-22 | NTclustered | gi|2442043959|ref|XM_045303941.2| | 6596 | g42804 | i0 | 82.143 | 8.26739926739927 | 140 | 23 | 51 | 2 | 119 | 257 | 936 | 798 | PREDICTED: Mercenaria mercenaria calreticulin-like (LOC123525149), mRNA | blastn | 2257 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 2034989 | 2034989 | PRJNA781196_P_NODE_15882_length_415_cov_1.441520_g15505_i0 | PRJNA781196 | 15882 | 415 | 1.44152 | 5.982308 | Mya arenaria | 6604 | Mollusca | Mollusca | 326 | 2.13e-84 | NTclustered | gi|2427471026|ref|XM_052941382.1| | 6604 | g15505 | i0 | 80.872 | 20.6939759036145 | 413 | 79 | 99 | 0 | 1 | 413 | 563 | 975 | PREDICTED: Mya arenaria serine/threonine-protein phosphatase alpha-2 isoform (LOC128229620), mRNA | blastn | 8588 | 326 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 2035334 | 2035334 | PRJNA781196_P_NODE_39802_length_283_cov_2.761905_g39425_i0 | PRJNA781196 | 39802 | 283 | 2.761905 | 7.81619115 | Tridacna squamosa | 80830 | Mollusca | Mollusca | 213 | 1.13e-50 | NTclustered | gi|999964412|gb|KT962826.1| | 80830 | g39425 | i0 | 80.351 | 3.00706713780919 | 285 | 52 | 100 | 4 | 1 | 283 | 2136 | 1854 | Tridacna squamosa glutamine synthetase isoform 1 (GS) mRNA, complete cds | blastn | 851 | 213 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Cardiidae | Tridacna | Tridacna squamosa | |
| 3310160 | 3310160 | PRJNA781196_P_NODE_13603_length_443_cov_3.818919_g13226_i0 | PRJNA781196 | 13603 | 443 | 3.818919 | 16.91781117 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 209 | 2.4e-49 | NTclustered | gi|2442017659|ref|XM_053527748.1| | 6596 | g13226 | i0 | 87.709 | 35.0406320541761 | 179 | 22 | 40 | 0 | 53 | 231 | 102 | 280 | PREDICTED: Mercenaria mercenaria 60S ribosomal protein L27a-like (LOC128549953), mRNA | blastn | 15523 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 4587950 | 4587950 | PRJNA781196_P_NODE_61304_length_246_cov_0.901734_g60927_i0 | PRJNA781196 | 61304 | 246 | 0.901734 | 2.21826564 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|1914633244|ref|XM_029790130.2| | 2607531 | g60927 | i0 | 100 | 0.479674796747967 | 29 | 0 | 12 | 0 | 198 | 226 | 4899 | 4927 | PREDICTED: Octopus sinensis SR-related and CTD-associated factor 4 (LOC115219845), transcript variant X1, mRNA | blastn | 118 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 7137945 | 7137945 | PRJNA781196_P_NODE_39046_length_286_cov_1.140845_g38669_i0 | PRJNA781196 | 39046 | 286 | 1.140845 | 3.2628167 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 444 | 3.73e-120 | NTclustered | gi|2245724695|ref|XM_046506304.2| | 6454 | g38669 | i0 | 95.035 | 4.95804195804196 | 282 | 14 | 99 | 0 | 5 | 286 | 2402 | 2121 | PREDICTED: Haliotis rufescens sushi, von Willebrand factor type A, EGF and pentraxin domain-containing protein 1-like (LOC124139316), transcript variant X1, mRNA | blastn | 1418 | 444 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 8412133 | 8412133 | PRJNA781196_P_NODE_18187_length_392_cov_1.956113_g17810_i0 | PRJNA781196 | 18187 | 392 | 1.956113 | 7.66796296 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 283 | 1.22e-71 | NTclustered | gi|1207946694|ref|XM_021507527.1| | 6573 | g17810 | i0 | 80.601 | 14.1964285714286 | 366 | 71 | 93 | 0 | 1 | 366 | 447 | 82 | PREDICTED: Mizuhopecten yessoensis 40S ribosomal protein S3 (LOC110456667), mRNA | blastn | 5565 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 8412400 | 8412400 | PRJNA781196_P_NODE_37227_length_292_cov_1.031963_g36850_i0 | PRJNA781196 | 37227 | 292 | 1.031963 | 3.01333196 | Haliotis cracherodii | 6455 | Mollusca | Mollusca | 483 | 8.1e-132 | NTclustered | gi|2911916353|ref|XM_071234910.1| | 6455 | g36850 | i0 | 96.886 | 5.98972602739726 | 289 | 8 | 99 | 1 | 5 | 292 | 389 | 101 | PREDICTED: Haliotis cracherodii salivary peroxidase/catechol oxidase-like (LOC139453276), mRNA | blastn | 1749 | 483 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis cracherodii | |
| 12239237 | 12239237 | PRJNA781196_P_NODE_56350_length_249_cov_0.886364_g55973_i0 | PRJNA781196 | 56350 | 249 | 0.886364 | 2.20704636 | Haliotis discus | 36094 | Mollusca | Mollusca | 455 | 1.47e-123 | NTclustered | gi|379318219|gb|JN899240.1| | 42344 | g55973 | i0 | 99.598 | 10.6345381526104 | 249 | 1 | 100 | 0 | 1 | 249 | 808 | 1056 | Haliotis discus hannai chaperonin containing T-complex polypeptide subunit zeta mRNA, complete cds | blastn | 2648 | 455 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis discus | |
| 12690945 | 12690945 | PRJNA781196_P_NODE_52390_length_252_cov_0.871508_g52013_i0 | PRJNA781196 | 52390 | 252 | 0.871508 | 2.19620016 | Haliotis | 6452 | Mollusca | Mollusca | 466 | 6.89e-127 | NTclustered | gi|2409668597|dbj|LC613488.1| | 36094 | g52013 | i0 | 100 | 100 | 252 | 0 | 100 | 0 | 1 | 252 | 232 | 483 | Haliotis discus HDHD_Iwaki11 mitochondrial gene for 16S ribosomal RNA, partial sequence | blastn | 25200 | 466 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis discus | |
| 13512722 | 13512722 | PRJNA781196_P_NODE_12151_length_466_cov_1.480916_g11775_i0 | PRJNA781196 | 12151 | 466 | 1.480916 | 6.90106856 | Haliotis discus | 36094 | Mollusca | Mollusca | 789 | 0 | NTclustered | gi|91992321|gb|DQ453711.1| | 42344 | g11775 | i0 | 100 | 6.8519313304721 | 427 | 0 | 92 | 0 | 1 | 427 | 427 | 1 | Haliotis discus hannai vitelline envelope zona pellucida domain 2 (VEZP2) mRNA, complete cds | blastn | 3193 | 789 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis discus | |
| 14787537 | 14787537 | PRJNA781196_P_NODE_12252_length_464_cov_3.416880_g11876_i0 | PRJNA781196 | 12252 | 464 | 3.41688 | 15.8543232 | Physella acuta | 109671 | Mollusca | Mollusca | 228 | 6.979999999999998e-55 | NTclustered | gi|2572299341|ref|XM_059292545.1| | 109671 | g11876 | i0 | 77.519 | 33.8318965517241 | 387 | 81 | 83 | 6 | 54 | 437 | 145 | 528 | PREDICTED: Physella acuta large ribosomal subunit protein uL15-like (LOC131935845), mRNA | blastn | 15698 | 228 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 16514096 | 16514096 | PRJNA781196_P_NODE_13173_length_450_cov_1.233422_g12796_i0 | PRJNA781196 | 13173 | 450 | 1.233422 | 5.550399 | Opisthokonta | 33154 | Mollusca | Mollusca | 183 | 1.48e-41 | NTclustered | gi|320461654|dbj|AB543997.1| | 200186 | g12796 | i0 | 81.116 | 46.2711111111111 | 233 | 40 | 51 | 4 | 220 | 450 | 83 | 313 | Coccopigya punctoradiata H3 gene for histone3, partial cds, specimen_voucher: NUGB L266 | blastn | 20822 | 183 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Cocculinidae | Coccopigya | Coccopigya punctoradiata | ||
| 18611100 | 18611100 | PRJNA781196_P_NODE_52035_length_252_cov_0.871508_g51658_i0 | PRJNA781196 | 52035 | 252 | 0.871508 | 2.19620016 | Aplysia californica | 6500 | Mollusca | Mollusca | 122 | 1.7199999999999995e-23 | NTclustered | gi|1897931265|ref|XM_013085028.2| | 6500 | g51658 | i0 | 81.169 | 8.69047619047619 | 154 | 27 | 61 | 2 | 34 | 186 | 393 | 241 | PREDICTED: Aplysia californica heat shock protein 83 (LOC101859343), mRNA | blastn | 2190 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 21613463 | 21613463 | PRJNA781196_P_NODE_47137_length_260_cov_3.695187_g46760_i0 | PRJNA781196 | 47137 | 260 | 3.6951870000000002 | 9.6074862 | Haliotis | 6452 | Mollusca | Mollusca | 202 | 2.2199999999999996e-47 | NTclustered | gi|2245630193|ref|XM_046509055.2| | 6454 | g46760 | i0 | 82.609 | 25.0923076923077 | 230 | 38 | 88 | 2 | 14 | 242 | 437 | 209 | PREDICTED: Haliotis rufescens 40S ribosomal protein S24-like (LOC124141143), transcript variant X2, mRNA | blastn | 6524 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 23712229 | 23712229 | PRJNA781196_P_NODE_45739_length_265_cov_1.218750_g45362_i0 | PRJNA781196 | 45739 | 265 | 1.21875 | 3.2296875 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|2616668871|ref|XM_060752449.1| | 129788 | g45362 | i0 | 100 | 0.316981132075472 | 28 | 0 | 11 | 0 | 223 | 250 | 851 | 824 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132760473 (LOC132760473), transcript variant X2, mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 24163018 | 24163018 | PRJNA781196_P_NODE_56739_length_249_cov_0.886364_g56362_i0 | PRJNA781196 | 56739 | 249 | 0.886364 | 2.20704636 | Haliotis | 6452 | Mollusca | Mollusca | 449 | 6.840000000000001e-122 | NTclustered | gi|2245713013|ref|XM_046470007.2| | 6454 | g56362 | i0 | 99.197 | 4 | 249 | 2 | 100 | 0 | 1 | 249 | 707 | 459 | PREDICTED: Haliotis rufescens mediator of RNA polymerase II transcription subunit 4-like (LOC124110670), mRNA | blastn | 996 | 449 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 24985411 | 24985411 | PRJNA781196_P_NODE_14240_length_435_cov_1.292818_g13863_i0 | PRJNA781196 | 14240 | 435 | 1.292818 | 5.6237583 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.042 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g13863 | i0 | 100 | 0.064367816091954 | 28 | 0 | 6 | 0 | 63 | 90 | 2800657 | 2800684 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24985749 | 24985749 | PRJNA781196_P_NODE_35560_length_298_cov_0.871111_g35183_i0 | PRJNA781196 | 35560 | 298 | 0.871111 | 2.59591078 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2693856106|ref|XM_063560975.1| | 6551 | g35183 | i0 | 100 | 0.100671140939597 | 30 | 0 | 10 | 0 | 44 | 73 | 1766 | 1737 | PREDICTED: Mytilus trossulus uncharacterized protein DDB_G0290685-like (LOC134699371), mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus |
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);;