contig_metadata
16 rows where bioproject = "PRJNA498309" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 481494 | 481494 | PRJNA498309_P_NODE_88361_length_224_cov_42.620321_g86212_i0 | PRJNA498309 | 88361 | 224 | 42.620321 | 95.46951904 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g86212 | i0 | 100 | 0.379464285714286 | 29 | 0 | 13 | 0 | 4 | 32 | 6 | 34 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 85 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 4307465 | 4307465 | PRJNA498309_P_NODE_34644_length_477_cov_10.304545_g32601_i0 | PRJNA498309 | 34644 | 477 | 10.304545 | 49.15267965 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 67.6 | 1.66e-6 | NTclustered | gi|2616504246|ref|XR_009624436.1| | 129788 | g32601 | i0 | 84.848 | 0.138364779874214 | 66 | 10 | 14 | 0 | 55 | 120 | 112 | 177 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132721255 (LOC132721255), ncRNA | blastn | 66 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 4308355 | 4308355 | PRJNA498309_P_NODE_89544_length_221_cov_2.440217_g87395_i0 | PRJNA498309 | 89544 | 221 | 2.440217 | 5.39287957 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 60.2 | 1.17e-4 | NTclustered | gi|2245691288|ref|XM_048381680.1| | 6454 | g87395 | i0 | 97.143 | 21.3800904977376 | 35 | 1 | 16 | 0 | 128 | 162 | 4002 | 3968 | PREDICTED: Haliotis rufescens uncharacterized LOC124115498 (LOC124115498), transcript variant X19, mRNA | blastn | 4725 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 7487383 | 7487383 | PRJNA498309_P_NODE_94846_length_207_cov_1.264706_g92697_i0 | PRJNA498309 | 94846 | 207 | 1.264706 | 2.61794142 | Stylommatophora | 6527 | Mollusca | Mollusca | 377 | 2.63e-100 | NTclustered | gi|1700712075|gb|MN022666.1| | 145789 | g92697 | i0 | 99.517 | 100.033816425121 | 207 | 1 | 100 | 0 | 1 | 207 | 2729 | 2935 | Caryodes dufresnii 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 20707 | 377 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Caryodidae | Caryodes | Caryodes dufresnii | |
| 8133753 | 8133753 | PRJNA498309_P_NODE_36847_length_460_cov_8.257683_g34784_i0 | PRJNA498309 | 36847 | 460 | 8.257683 | 37.9853418 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 67.6 | 1.59e-6 | NTclustered | gi|2616504246|ref|XR_009624436.1| | 129788 | g34784 | i0 | 84.848 | 0.143478260869565 | 66 | 10 | 14 | 0 | 341 | 406 | 177 | 112 | PREDICTED: Ruditapes philippinarum uncharacterized LOC132721255 (LOC132721255), ncRNA | blastn | 66 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 9410030 | 9410030 | PRJNA498309_S_NODE_19168_length_475_cov_487.354545_g17077_i0 | PRJNA498309 | 19168 | 475 | 487.354545 | 2314.93408875 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 82.4 | 5.9e-11 | NTclustered | gi|2245688928|ref|XM_048381009.1| | 6454 | g17077 | i0 | 100 | 20.2547368421053 | 44 | 0 | 9 | 0 | 89 | 132 | 4562 | 4605 | PREDICTED: Haliotis rufescens uncharacterized LOC125372073 (LOC125372073), partial mRNA | blastn | 9621 | 82.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 10036840 | 10036840 | PRJNA498309_P_NODE_101448_length_190_cov_39.928105_g99299_i0 | PRJNA498309 | 101448 | 190 | 39.928105 | 75.8633995 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.005 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g99299 | i0 | 100 | 0.747368421052632 | 29 | 0 | 15 | 0 | 1 | 29 | 29 | 57 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 142 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 10038150 | 10038150 | PRJNA498309_S_NODE_39088_length_218_cov_11.202186_g36920_i0 | PRJNA498309 | 39088 | 218 | 11.202186 | 24.42076548 | Gastropoda | 6448 | Mollusca | Mollusca | 403 | 4.62e-108 | NTclustered | gi|973291008|gb|KU341311.1| | 6532 | g36920 | i0 | 100 | 100 | 218 | 0 | 100 | 0 | 1 | 218 | 3419 | 3202 | Limicolaria kambeul isolate O_lim_c 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 21800 | 403 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Achatinidae | Limicolaria | Limicolaria kambeul | |
| 10685326 | 10685326 | PRJNA498309_P_NODE_97329_length_200_cov_6.680982_g95180_i0 | PRJNA498309 | 97329 | 200 | 6.680982 | 13.361964 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.017 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g95180 | i0 | 100 | 0.14 | 28 | 0 | 14 | 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 | |
| 15784202 | 15784202 | PRJNA498309_P_NODE_92653_length_212_cov_3.400000_g90504_i0 | PRJNA498309 | 92653 | 212 | 3.4 | 7.208 | Sinonovacula constricta | 98310 | Mollusca | Mollusca | 52.8 | 0.019 | NTclustered | gi|937961735|gb|KR534869.1| | 98310 | g90504 | i0 | 100 | 0.132075471698113 | 28 | 0 | 13 | 0 | 185 | 212 | 33 | 6 | Sinonovacula constricta insulin-like peptide 1 mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Solecurtidae | Sinonovacula | Sinonovacula constricta | |
| 17057552 | 17057552 | PRJNA498309_P_NODE_118514_length_157_cov_2.791667_g116365_i0 | PRJNA498309 | 118514 | 157 | 2.791667 | 4.38291719 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 71.3 | 3.58e-8 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g116365 | i0 | 75.524 | 52.7643312101911 | 143 | 35 | 96 | 0 | 15 | 157 | 53747342 | 53747200 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 8284 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 17059914 | 17059914 | PRJNA498309_S_NODE_53674_length_152_cov_1.982906_g51506_i0 | PRJNA498309 | 53674 | 152 | 1.982906 | 3.01401712 | Potamilus streckersoni | 2493646 | Mollusca | Mollusca | 103 | 5.44e-24 | NR | KAK3604820.1 | 2493646 | g51506 | i0 | 96 | 1.97368421052632 | 50 | 2 | 98.7 | 0 | 152 | 3 | 549 | 598 | KAK3604820.1 hypothetical protein CHS0354_000482 [Potamilus streckersoni] | diamond | 300 | 103 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 28166464 | 28166464 | PRJNA498309_P_NODE_96625_length_202_cov_2.606061_g94476_i0 | PRJNA498309 | 96625 | 202 | 2.606061 | 5.26424322 | Metazoa | 33208 | Mollusca | Mollusca | 61.2 | 6.51e-9 | NR | XP_005109163.1 | 6500 | g94476 | i0 | 66.7 | 13.7079207920792 | 36 | 12 | 53.5 | 0 | 16 | 123 | 141 | 176 | XP_005109163.1 cyclin-L1 [Aplysia californica] | diamond | 2769 | 61.6 | 0.993506493506494 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 29003857 | 29003857 | PRJNA498309_P_NODE_85968_length_232_cov_1.379487_g83819_i0 | PRJNA498309 | 85968 | 232 | 1.379487 | 3.20040984 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 50.4 | 6.19e-5 | NR | BFZ13139.1 | 145626 | g83819 | i0 | 47.5 | 0.762931034482759 | 59 | 25 | 68.5 | 1 | 74 | 232 | 2 | 60 | BFZ13139.1 hypothetical protein BsWGS_16177 [Bradybaena similaris] | diamond | 177 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 29761049 | 29761049 | PRJNA498309_P_NODE_99451_length_195_cov_2.449367_g97302_i0 | PRJNA498309 | 99451 | 195 | 2.449367 | 4.77626565 | Elysia marginata | 1093978 | Mollusca | Mollusca | 42.4 | 0.0274 | NR | GFR89747.1 | 1093978 | g97302 | i0 | 53.6 | 0.430769230769231 | 28 | 13 | 43.1 | 0 | 72 | 155 | 806 | 833 | GFR89747.1 polycystic kidney disease protein 1-like 2 [Elysia marginata] | diamond | 84 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 32889453 | 32889453 | PRJNA498309_P_NODE_39820_length_438_cov_19.543641_g37715_i0 | PRJNA498309 | 39820 | 438 | 19.543641 | 85.60114758 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 115 | 8.530000000000001e-27 | NR | CAG5134995.1 | 100452 | g37715 | i0 | 41.7 | 1.87671232876712 | 132 | 76 | 89.7 | 1 | 396 | 4 | 218 | 349 | CAG5134995.1 unnamed protein product [Candidula unifasciata] | diamond | 822 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata |
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);;