contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1092581" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1472799 | 1472799 | PRJNA1092581_P_NODE_94142_length_262_cov_3.481481_g93609_i0 | PRJNA1092581 | 94142 | 262 | 3.481481 | 9.12148022 | Pecten maximus | 6579 | Mollusca | Mollusca | 95.3 | 3.92e-15 | NTclustered | gi|1835451240|ref|XR_004531328.1| | 6579 | g93609 | i0 | 92.647 | 34.1335877862595 | 68 | 2 | 26 | 3 | 153 | 219 | 1896 | 1961 | PREDICTED: Pecten maximus large subunit ribosomal RNA (LOC117321358), rRNA | blastn | 8943 | 95.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 2748189 | 2748189 | PRJNA1092581_P_NODE_62883_length_333_cov_4.930769_g62350_i0 | PRJNA1092581 | 62883 | 333 | 4.930769 | 16.41946077 | Ellobium scheepmakeri | 1628041 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|766945716|gb|KJ920304.1| | 1628041 | g62350 | i0 | 94.444 | 0.108108108108108 | 36 | 2 | 11 | 0 | 239 | 274 | 138 | 103 | Ellobium scheepmakeri 12S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 36 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Ellobiida | Ellobiidae | Ellobium | Ellobium scheepmakeri | |
| 4022774 | 4022774 | PRJNA1092581_P_NODE_14164_length_732_cov_5.884674_g13674_i0 | PRJNA1092581 | 14164 | 732 | 5.884674 | 43.07581368 | Physella acuta | 109671 | Mollusca | Mollusca | 54.7 | 0.02 | NTclustered | gi|2572323583|ref|XM_059298071.1| | 109671 | g13674 | i0 | 100 | 0.0396174863387978 | 29 | 0 | 4 | 0 | 511 | 539 | 5701 | 5729 | PREDICTED: Physella acuta uncharacterized LOC131939637 (LOC131939637), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 6573623 | 6573623 | PRJNA1092581_P_NODE_111406_length_237_cov_102.073171_g110873_i0 | PRJNA1092581 | 111406 | 237 | 102.073171 | 241.91341527 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 115 | 2.67e-21 | NTclustered | gi|161210401|gb|EU272074.1| | 98310 | g110873 | i0 | 97.059 | 0.40506329113924 | 68 | 2 | 29 | 0 | 168 | 235 | 1 | 68 | Sinonovacula constricta clone 450 microsatellite sequence | blastn | 96 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 6575067 | 6575067 | PRJNA1092581_P_NODE_53046_length_367_cov_5.210884_g52513_i0 | PRJNA1092581 | 53046 | 367 | 5.210884 | 19.12394428 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 632 | 9.79e-177 | NTclustered | gi|1207953728|ref|XM_021511295.1| | 6573 | g52513 | i0 | 99.71 | 32.5994550408719 | 345 | 1 | 94 | 0 | 1 | 345 | 401 | 57 | PREDICTED: Mizuhopecten yessoensis heat shock protein HSP 90-beta-like (LOC110459169), transcript variant X1, mRNA | blastn | 11964 | 632 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 11675786 | 11675786 | PRJNA1092581_P_NODE_50490_length_378_cov_5.685246_g49957_i0 | PRJNA1092581 | 50490 | 378 | 5.685246 | 21.49022988 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 54.7 | 0.01 | NTclustered | gi|2616662691|ref|XM_060749585.1| | 129788 | g49957 | i0 | 100 | 0.0767195767195767 | 29 | 0 | 8 | 0 | 340 | 368 | 2102 | 2130 | PREDICTED: Ruditapes philippinarum neuroligin-4, X-linked-like (LOC132758072), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 12949253 | 12949253 | PRJNA1092581_P_NODE_103171_length_248_cov_11.788571_g102638_i0 | PRJNA1092581 | 103171 | 248 | 11.788571 | 29.23565608 | Zachrysia provisoria | 1498573 | Mollusca | Mollusca | 316 | 7.2e-82 | NTclustered | gi|649967336|gb|KF246993.1| | 1498573 | g102638 | i0 | 100 | 75.3991935483871 | 171 | 0 | 69 | 0 | 1 | 171 | 283 | 453 | Zachrysia provisoria isolate A18973 voucher ANSP:400324 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 18699 | 316 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Zachrysia | Zachrysia provisoria | |
| 12950846 | 12950846 | PRJNA1092581_P_NODE_51071_length_376_cov_1.924092_g50538_i0 | PRJNA1092581 | 51071 | 376 | 1.924092 | 7.23458592 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 695 | 0 | NTclustered | gi|1207953730|ref|XM_021511297.1| | 6573 | g50538 | i0 | 100 | 38.2712765957447 | 376 | 0 | 100 | 0 | 1 | 376 | 678 | 303 | PREDICTED: Mizuhopecten yessoensis heat shock protein HSP 90-beta-like (LOC110459169), transcript variant X2, mRNA | blastn | 14390 | 695 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 14226813 | 14226813 | PRJNA1092581_P_NODE_88852_length_271_cov_6.893939_g88319_i0 | PRJNA1092581 | 88852 | 271 | 6.893939 | 18.68257469 | Acusta ravida | 2603701 | Mollusca | Mollusca | 339 | 1.7e-88 | NTclustered | gi|2785812303|gb|PQ166711.1| | 2603701 | g88319 | i0 | 91.498 | 59.7121771217712 | 247 | 20 | 91 | 1 | 25 | 270 | 2351 | 2597 | Acusta ravida mitochondrion, complete genome | blastn | 16182 | 339 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Acusta | Acusta ravida | |
| 16320700 | 16320700 | PRJNA1092581_P_NODE_35613_length_461_cov_4.605670_g35081_i0 | PRJNA1092581 | 35613 | 461 | 4.60567 | 21.2321387 | Opisthokonta | 33154 | Mollusca | Mollusca | 65.8 | 5.75e-6 | NTclustered | gi|1131301285|gb|KX898115.1| | 72687 | g35081 | i0 | 97.368 | 8.27331887201735 | 38 | 1 | 8 | 0 | 424 | 461 | 39 | 2 | Nacella magellanica isolate 61 28S ribosomal RNA gene, partial sequence | blastn | 3814 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Nacellidae | Nacella | Nacella magellanica | ||
| 18047206 | 18047206 | PRJNA1092581_P_NODE_100995_length_251_cov_4.000000_g100462_i0 | PRJNA1092581 | 100995 | 251 | 4 | 10.04 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 52.8 | 0.023 | NTclustered | gi|2592076434|ref|XM_060218341.1| | 509963 | g100462 | i0 | 100 | 0.111553784860558 | 28 | 0 | 11 | 0 | 166 | 193 | 161 | 134 | PREDICTED: Ylistrum balloti stAR-related lipid transfer protein 7, mitochondrial-like (LOC132554044), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 18049352 | 18049352 | PRJNA1092581_P_NODE_71235_length_310_cov_1.299578_g70702_i0 | PRJNA1092581 | 71235 | 310 | 1.299578 | 4.0286918 | Lottia gigantea | 225164 | Mollusca | Mollusca | 274 | 5.679999999999998e-69 | NTclustered | gi|676475860|ref|XM_009062356.1| | 225164 | g70702 | i0 | 89.401 | 71.5516129032258 | 217 | 23 | 70 | 0 | 1 | 217 | 267 | 51 | Lottia gigantea hypothetical protein mRNA | blastn | 22181 | 274 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 20144268 | 20144268 | PRJNA1092581_P_NODE_118536_length_226_cov_2.915033_g118003_i0 | PRJNA1092581 | 118536 | 226 | 2.915033 | 6.58797458 | Camaenidae | 83226 | Mollusca | Mollusca | 370 | 4.89e-98 | NTclustered | gi|2644119648|gb|PP069321.1| | 120488 | g118003 | i0 | 98.571 | 143.221238938053 | 210 | 2 | 92 | 1 | 1 | 209 | 3098 | 2889 | Acusta despecta isolate acuc 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 32368 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Acusta | Acusta despecta | |
| 20598365 | 20598365 | PRJNA1092581_P_NODE_57817_length_349_cov_21.782609_g57284_i0 | PRJNA1092581 | 57817 | 349 | 21.782609 | 76.02130541 | Meghimatium bilineatum | 318265 | Mollusca | Mollusca | 608 | 1.5599999999999995e-169 | NTclustered | gi|2327913037|gb|OP311642.1| | 318265 | g57284 | i0 | 100 | 58.4756446991404 | 329 | 0 | 94 | 0 | 21 | 349 | 2250 | 2578 | Meghimatium bilineatum mitochondrion, complete genome | blastn | 20408 | 608 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Philomycidae | Meghimatium | Meghimatium bilineatum | |
| 21872621 | 21872621 | PRJNA1092581_P_NODE_113038_length_235_cov_2.796296_g112505_i0 | PRJNA1092581 | 113038 | 235 | 2.796296 | 6.5712956 | Aplysia californica | 6500 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|1897909680|ref|XM_013090154.2| | 6500 | g112505 | i0 | 100 | 0.119148936170213 | 28 | 0 | 12 | 0 | 32 | 59 | 2880 | 2853 | PREDICTED: Aplysia californica serine-rich adhesin for platelets (LOC101852969), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 21874488 | 21874488 | PRJNA1092581_P_NODE_71278_length_309_cov_15.461864_g70745_i0 | PRJNA1092581 | 71278 | 309 | 15.461864 | 47.77715976 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 126 | 1.68e-24 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g70745 | i0 | 75.954 | 0.84789644012945 | 262 | 54 | 83 | 9 | 32 | 288 | 47028102 | 47027845 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 262 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris |
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);;