contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA533623" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 506191 | 506191 | PRJNA533623_P_NODE_23421_length_478_cov_6.443645_g21663_i0 | PRJNA533623 | 23421 | 478 | 6.443645 | 30.8006231 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 2.15e-5 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g21663 | i0 | 91.304 | 0.589958158995816 | 46 | 4 | 10 | 0 | 9 | 54 | 21251882 | 21251927 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 282 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4333313 | 4333313 | PRJNA533623_P_NODE_34264_length_380_cov_17.119122_g32493_i0 | PRJNA533623 | 34264 | 380 | 17.119122 | 65.0526636 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 52.8 | 0.036 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g32493 | i0 | 100 | 0.0736842105263158 | 28 | 0 | 7 | 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 | |
| 6884637 | 6884637 | PRJNA533623_P_NODE_62806_length_244_cov_1.562842_g61025_i0 | PRJNA533623 | 62806 | 244 | 1.562842 | 3.81333448 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g61025 | i0 | 100 | 0.233606557377049 | 29 | 0 | 12 | 0 | 216 | 244 | 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 | ||
| 6884689 | 6884689 | PRJNA533623_P_NODE_65226_length_235_cov_6.551724_g63445_i0 | PRJNA533623 | 65226 | 235 | 6.551724 | 15.3965514 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g63445 | i0 | 96.774 | 0.131914893617021 | 31 | 1 | 13 | 0 | 29 | 59 | 2 | 32 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 8159408 | 8159408 | PRJNA533623_P_NODE_44487_length_320_cov_17.621622_g42713_i0 | PRJNA533623 | 44487 | 320 | 17.621622 | 56.3891904 | Deroceras laeve | 147581 | Mollusca | Mollusca | 355 | 2.04e-93 | NTclustered | gi|1273386105|gb|KX959509.1| | 147581 | g42713 | i0 | 98.515 | 62.2125 | 202 | 2 | 72 | 1 | 29 | 230 | 310 | 510 | Deroceras laeve isolate DLEMV_C1 28S ribosomal RNA gene, partial sequence | blastn | 19908 | 355 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Agriolimacidae | Deroceras | Deroceras laeve | |
| 9434368 | 9434368 | PRJNA533623_P_NODE_21628_length_499_cov_35.529680_g19878_i0 | PRJNA533623 | 21628 | 499 | 35.52968 | 177.2931032 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.049 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g19878 | i0 | 100 | 0.0561122244488978 | 28 | 0 | 6 | 0 | 472 | 499 | 32 | 5 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 9435660 | 9435660 | PRJNA533623_P_NODE_8068_length_820_cov_48.940711_g6624_i0 | PRJNA533623 | 8068 | 820 | 48.940711 | 401.3138302 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 56.5 | 0.006 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g6624 | i0 | 100 | 0.0365853658536585 | 30 | 0 | 4 | 0 | 781 | 810 | 35 | 6 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 30 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 10710546 | 10710546 | PRJNA533623_P_NODE_39289_length_349_cov_2.663194_g37515_i0 | PRJNA533623 | 39289 | 349 | 2.663194 | 9.29454706 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 52.8 | 0.033 | NTclustered | gi|451805751|gb|KC355397.1| | 220873 | g37515 | i0 | 100 | 0.0802292263610315 | 28 | 0 | 8 | 0 | 1 | 28 | 770 | 797 | Tegillarca granosa clone isotig2184 microsatellite sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 11984822 | 11984822 | PRJNA533623_P_NODE_22370_length_490_cov_23.860140_g20616_i0 | PRJNA533623 | 22370 | 490 | 23.86014 | 116.914686 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.004 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g20616 | i0 | 100 | 0.23469387755102 | 30 | 0 | 6 | 0 | 461 | 490 | 58 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 115 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 14535651 | 14535651 | PRJNA533623_P_NODE_55412_length_271_cov_11.719048_g53632_i0 | PRJNA533623 | 55412 | 271 | 11.719048 | 31.75862008 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g53632 | i0 | 100 | 0.420664206642066 | 29 | 0 | 11 | 0 | 79 | 107 | 42848507 | 42848479 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 114 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 15808603 | 15808603 | PRJNA533623_P_NODE_16273_length_584_cov_16.143403_g7805_i1 | PRJNA533623 | 16273 | 584 | 16.143403 | 94.27747352 | Argopecten irradians | 31199 | Mollusca | Mollusca | 254 | 1.47e-62 | NTclustered | gi|2835364972|ref|XM_069256555.1| | 31199 | g7805 | i1 | 84.03 | 18.2243150684932 | 263 | 42 | 45 | 0 | 223 | 485 | 373 | 111 | PREDICTED: Argopecten irradians ras-related protein Rab-2 (LOC138315494), mRNA | blastn | 10643 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 15809768 | 15809768 | PRJNA533623_P_NODE_64793_length_237_cov_1.869318_g63012_i0 | PRJNA533623 | 64793 | 237 | 1.869318 | 4.43028366 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g63012 | i0 | 92.105 | 0.160337552742616 | 38 | 2 | 16 | 1 | 201 | 237 | 68 | 31 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 38 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 17083206 | 17083206 | PRJNA533623_P_NODE_10894_length_711_cov_29.333846_g9307_i0 | PRJNA533623 | 10894 | 711 | 29.333846 | 208.56364506 | Loliolus sp. JMS-2004 | 279086 | Mollusca | Mollusca | 91.6 | 1.51e-13 | NTclustered | gi|48994372|gb|AY616920.1| | 279086 | g9307 | i0 | 93.443 | 0.478199718706048 | 61 | 4 | 9 | 0 | 424 | 484 | 877 | 817 | Loliolus sp. JMS-2004 rhodopsin gene, partial cds | blastn | 340 | 91.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Myopsida | Loliginidae | Loliolus | Loliolus sp. JMS-2004 | |
| 18358406 | 18358406 | PRJNA533623_P_NODE_58655_length_259_cov_1.823232_g56875_i0 | PRJNA533623 | 58655 | 259 | 1.823232 | 4.72217088 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g56875 | i0 | 100 | 0.22007722007722 | 29 | 0 | 11 | 0 | 1 | 29 | 10 | 38 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 57 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 19632046 | 19632046 | PRJNA533623_P_NODE_19316_length_533_cov_2.086864_g17575_i0 | PRJNA533623 | 19316 | 533 | 2.086864 | 11.12298512 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 71.3 | 1.44e-7 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g17575 | i0 | 97.561 | 7.0093808630394 | 41 | 1 | 8 | 0 | 400 | 440 | 11984272 | 11984312 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 3736 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19632353 | 19632353 | PRJNA533623_P_NODE_30856_length_407_cov_6.572254_g29085_i0 | PRJNA533623 | 30856 | 407 | 6.572254 | 26.74907378 | Haliotis rubra | 36100 | Mollusca | Mollusca | 54.7 | 0.011 | NTclustered | gi|2194130499|ref|XM_046721287.1| | 36100 | g29085 | i0 | 100 | 0.285012285012285 | 29 | 0 | 7 | 0 | 187 | 215 | 1846 | 1874 | PREDICTED: Haliotis rubra collagen alpha-1(I) chain-like (LOC124285131), transcript variant X3, mRNA | blastn | 116 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 19633319 | 19633319 | PRJNA533623_P_NODE_73836_length_209_cov_2.074324_g72055_i0 | PRJNA533623 | 73836 | 209 | 2.074324 | 4.33533716 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 52.8 | 0.018 | NTclustered | gi|451805751|gb|KC355397.1| | 220873 | g72055 | i0 | 100 | 0.133971291866029 | 28 | 0 | 13 | 0 | 181 | 208 | 797 | 770 | Tegillarca granosa clone isotig2184 microsatellite sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 20908156 | 20908156 | PRJNA533623_P_NODE_24597_length_465_cov_11.705446_g22835_i0 | PRJNA533623 | 24597 | 465 | 11.705446 | 54.4303239 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 52.8 | 0.045 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g22835 | i0 | 100 | 0.0602150537634409 | 28 | 0 | 6 | 0 | 438 | 465 | 58 | 31 | 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 | |
| 20908712 | 20908712 | PRJNA533623_P_NODE_49357_length_297_cov_3.737288_g47578_i0 | PRJNA533623 | 49357 | 297 | 3.737288 | 11.09974536 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g47578 | i0 | 96.875 | 0.202020202020202 | 32 | 1 | 11 | 0 | 247 | 278 | 31487885 | 31487916 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 60 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22183082 | 22183082 | PRJNA533623_P_NODE_33678_length_385_cov_2.604938_g31907_i0 | PRJNA533623 | 33678 | 385 | 2.604938 | 10.0290113 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 141 | 7.62e-29 | NTclustered | gi|2364271592|ref|XM_052414852.1| | 45954 | g31907 | i0 | 81.871 | 9.89350649350649 | 171 | 28 | 44 | 3 | 6 | 174 | 376 | 207 | PREDICTED: Dreissena polymorpha protein arginine N-methyltransferase 1-like (LOC127871709), mRNA | blastn | 3809 | 141 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 22795188 | 22795188 | PRJNA533623_P_NODE_51998_length_285_cov_5.821429_g50219_i0 | PRJNA533623 | 51998 | 285 | 5.821429 | 16.59107265 | Stylommatophora | 6527 | Mollusca | Mollusca | 448 | 2.8699999999999997e-121 | NTclustered | gi|1700712075|gb|MN022666.1| | 145789 | g50219 | i0 | 98.431 | 137.40701754386 | 255 | 2 | 89 | 2 | 10 | 263 | 2999 | 2746 | Caryodes dufresnii 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 39161 | 451 | 0.993348115299335 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Caryodidae | Caryodes | Caryodes dufresnii |
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);;