contig_metadata
18 rows where analysis = "blastn", bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 901943 | 901943 | PRJNA928559_P_NODE_102081_length_353_cov_1.921429_g100512_i0 | PRJNA928559 | 102081 | 353 | 1.921429 | 6.78264437 | Elisolimax flavescens | 424226 | Mollusca | Mollusca | 102 | 3.27e-17 | NTclustered | gi|145652941|gb|EF015440.1| | 424226 | g100512 | i0 | 84.762 | 21.371104815864 | 105 | 12 | 29 | 3 | 252 | 353 | 1419 | 1522 | Elisolimax flavescens cytochrome oxidase subunit I (COI) gene, partial cds; tRNA-Val gene, complete sequence; and 16S ribosomal RNA gene, partial sequence; mitochondrial | blastn | 7544 | 102 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Urocyclidae | Elisolimax | Elisolimax flavescens | |
| 3453514 | 3453514 | PRJNA928559_P_NODE_153343_length_284_cov_2.104265_g151774_i0 | PRJNA928559 | 153343 | 284 | 2.104265 | 5.9761126 | Euconulus dentatus | 2498204 | Mollusca | Mollusca | 62.1 | 4.36e-5 | NTclustered | gi|1540839805|gb|MK299640.1| | 2498204 | g151774 | i0 | 97.222 | 0.443661971830986 | 36 | 1 | 13 | 0 | 7 | 42 | 132 | 97 | Euconulus dentatus isolate E157 cytochrome oxidase subunit II (COII) gene, partial cds; mitochondrial | blastn | 126 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Euconulidae | Euconulus | Euconulus dentatus | |
| 6006757 | 6006757 | PRJNA928559_P_NODE_213345_length_242_cov_2.650888_g211776_i0 | PRJNA928559 | 213345 | 242 | 2.650888 | 6.41514896 | Mytilus edulis | 6550 | Mollusca | Mollusca | 158 | 4.49e-34 | NTclustered | gi|2912390618|ref|XM_071307892.1| | 6550 | g211776 | i0 | 81.675 | 50.1322314049587 | 191 | 33 | 79 | 2 | 53 | 242 | 578 | 389 | PREDICTED: Mytilus edulis calmodulin-like (LOC139517171), mRNA | blastn | 12132 | 158 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 6007272 | 6007272 | PRJNA928559_P_NODE_42745_length_516_cov_1.823928_g41187_i0 | PRJNA928559 | 42745 | 516 | 1.823928 | 9.41146848 | Physella acuta | 109671 | Mollusca | Mollusca | 106 | 3.82e-18 | NTclustered | gi|2572452002|ref|XR_009385349.1| | 109671 | g41187 | i0 | 83.621 | 22.672480620155 | 116 | 16 | 22 | 3 | 218 | 333 | 2197 | 2085 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933954), rRNA | blastn | 11699 | 106 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 8905927 | 8905927 | PRJNA928559_P_NODE_43007_length_514_cov_26.539683_g41449_i0 | PRJNA928559 | 43007 | 514 | 26.539683 | 136.41397062 | Metazoa | 33208 | Mollusca | Mollusca | 206 | 3.65e-48 | NTclustered | gi|2022611928|dbj|LC597644.1| | 6613 | g41449 | i0 | 86.885 | 35.6459143968872 | 183 | 24 | 36 | 0 | 220 | 402 | 1793 | 1975 | Euprymna scolopes 2020GS-euscolo gene for 28S rRNA, partial sequence | blastn | 18322 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiolidae | Euprymna | Euprymna scolopes | |
| 9829873 | 9829873 | PRJNA928559_P_NODE_11548_length_908_cov_11.976048_g10293_i0 | PRJNA928559 | 11548 | 908 | 11.976048 | 108.74251584 | Leptochiton asellus | 211853 | Mollusca | Mollusca | 202 | 8.6e-47 | NTclustered | gi|34369208|gb|AY145414.1| | 211853 | g10293 | i0 | 85.864 | 19.4603524229075 | 191 | 26 | 21 | 1 | 718 | 908 | 2713 | 2524 | Leptochiton asellus 28S ribosomal RNA gene, partial sequence | blastn | 17670 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Lepidopleurida | Lepidopleuridae | Leptochiton | Leptochiton asellus | |
| 11108154 | 11108154 | PRJNA928559_P_NODE_8689_length_1032_cov_3.465068_g7578_i0 | PRJNA928559 | 8689 | 1032 | 3.465068 | 35.75950176 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 80.5 | 4.81e-10 | NTclustered | gi|2669106401|ref|XM_062732311.1| | 36930 | g7578 | i0 | 73.913 | 0.222868217054264 | 230 | 46 | 22 | 13 | 526 | 748 | 546 | 324 | PREDICTED: Saccostrea cucullata large ribosomal subunit protein uL1-like (LOC134249968), mRNA | blastn | 230 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 11456608 | 11456608 | PRJNA928559_P_NODE_178649_length_260_cov_1.925134_g177080_i0 | PRJNA928559 | 178649 | 260 | 1.925134 | 5.0053484 | Bivalvia | 6544 | Mollusca | Mollusca | 198 | 2.88e-46 | NTclustered | gi|1104599609|gb|KX713374.1| | 74448 | g177080 | i0 | 91.096 | 58.5653846153846 | 146 | 13 | 56 | 0 | 115 | 260 | 180 | 325 | Dendostrea frons voucher BivAToL-54 28S ribosomal RNA gene, partial sequence | blastn | 15227 | 198 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Dendostrea | Dendostrea frons | |
| 14006996 | 14006996 | PRJNA928559_P_NODE_216811_length_239_cov_24.957831_g215242_i0 | PRJNA928559 | 216811 | 239 | 24.957831 | 59.64921609 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 78.7 | 3.54e-10 | NTclustered | gi|1772640078|gb|MN644814.1| | 6523 | g215242 | i0 | 97.826 | 19.2468619246862 | 46 | 0 | 19 | 1 | 1 | 46 | 2730 | 2774 | Lymnaea stagnalis isolate lyms2 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence. | blastn | 4600 | 78.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 14931167 | 14931167 | PRJNA928559_P_NODE_193132_length_251_cov_0.876404_g191563_i0 | PRJNA928559 | 193132 | 251 | 0.876404 | 2.19977404 | Haliotis asinina | 109174 | Mollusca | Mollusca | 119 | 2.21e-22 | NTclustered | gi|2793411565|ref|XM_067818344.1| | 109174 | g191563 | i0 | 84 | 36.573705179282904 | 125 | 18 | 49 | 2 | 43 | 166 | 5109 | 4986 | PREDICTED: Haliotis asinina dynein axonemal heavy chain 1-like (LOC137286460), mRNA | blastn | 9180 | 119 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 14932100 | 14932100 | PRJNA928559_P_NODE_52272_length_475_cov_148.027363_g50706_i0 | PRJNA928559 | 52272 | 475 | 148.027363 | 703.12997425 | Physella acuta | 109671 | Mollusca | Mollusca | 821 | 0 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g50706 | i0 | 99.776 | 4.66947368421053 | 447 | 1 | 94 | 0 | 1 | 447 | 3323 | 3769 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 2218 | 821 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 17481572 | 17481572 | PRJNA928559_P_NODE_207474_length_245_cov_0.906977_g205905_i0 | PRJNA928559 | 207474 | 245 | 0.906977 | 2.22209365 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 122 | 1.66e-23 | NTclustered | gi|2669122868|ref|XM_062738512.1| | 36930 | g205905 | i0 | 85.47 | 40.7755102040816 | 117 | 17 | 48 | 0 | 1 | 117 | 242 | 126 | PREDICTED: Saccostrea cucullata histone H2A-like (LOC134255913), mRNA | blastn | 9990 | 122 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 17482800 | 17482800 | PRJNA928559_P_NODE_9094_length_1011_cov_5.123667_g7967_i0 | PRJNA928559 | 9094 | 1011 | 5.123667 | 51.80027337 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.029 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g7967 | i0 | 100 | 0.0286844708209693 | 29 | 0 | 3 | 0 | 57 | 85 | 2498689 | 2498661 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 21304165 | 21304165 | PRJNA928559_P_NODE_11877_length_896_cov_12.106926_g10293_i1 | PRJNA928559 | 11877 | 896 | 12.106926 | 108.47805696 | Leptochiton asellus | 211853 | Mollusca | Mollusca | 202 | 8.489999999999998e-47 | NTclustered | gi|34369208|gb|AY145414.1| | 211853 | g10293 | i1 | 85.864 | 19.7209821428571 | 191 | 26 | 21 | 1 | 1 | 191 | 2524 | 2713 | Leptochiton asellus 28S ribosomal RNA gene, partial sequence | blastn | 17670 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Lepidopleurida | Lepidopleuridae | Leptochiton | Leptochiton asellus | |
| 21306428 | 21306428 | PRJNA928559_P_NODE_71097_length_417_cov_7.005814_g69528_i0 | PRJNA928559 | 71097 | 417 | 7.005814 | 29.21424438 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 52.8 | 0.04 | NTclustered | gi|2441958246|ref|XR_008369117.1| | 6596 | g69528 | i0 | 94.286 | 0.167865707434053 | 35 | 1 | 8 | 1 | 154 | 188 | 1556 | 1523 | PREDICTED: Mercenaria mercenaria uncharacterized LOC128552594 (LOC128552594), ncRNA | blastn | 70 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 21655365 | 21655365 | PRJNA928559_P_NODE_45357_length_503_cov_35.044186_g43796_i0 | PRJNA928559 | 45357 | 503 | 35.044186 | 176.27225558 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67.6 | 1.76e-6 | NTclustered | gi|2693871861|ref|XR_010104559.1| | 6551 | g43796 | i0 | 100 | 8.21868787276342 | 36 | 0 | 7 | 0 | 1 | 36 | 3282 | 3317 | PREDICTED: Mytilus trossulus large subunit ribosomal RNA (LOC134702777), rRNA | blastn | 4134 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 22930479 | 22930479 | PRJNA928559_P_NODE_140258_length_298_cov_13.920000_g138689_i0 | PRJNA928559 | 140258 | 298 | 13.92 | 41.4816 | Ctena | 102298 | Mollusca | Mollusca | 148 | 3.4299999999999996e-31 | NTclustered | gi|2129023951|gb|OL361786.1| | 2892552 | g138689 | i0 | 91.589 | 6.57046979865772 | 107 | 9 | 36 | 0 | 186 | 292 | 4053 | 4159 | Ctena cf. galapagana NHMUK 20210086 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 1958 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Lucinida | Lucinidae | Ctena | Ctena cf. galapagana NHMUK 20210086 | |
| 25128833 | 25128833 | PRJNA928559_P_NODE_160260_length_277_cov_1.911765_g158691_i0 | PRJNA928559 | 160260 | 277 | 1.911765 | 5.29558905 | Austrolittorina unifasciata | 69680 | Mollusca | Mollusca | 154 | 6.790000000000001e-33 | NTclustered | gi|2287625817|gb|ON491722.1| | 69680 | g158691 | i0 | 79.812 | 6.83754512635379 | 213 | 41 | 77 | 2 | 3 | 214 | 76 | 287 | Austrolittorina unifasciata voucher G1.1 adenine nucleotide translocase (ANT) gene, partial cds | blastn | 1894 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Austrolittorina | Austrolittorina 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);;