contig_metadata
22 rows where bioproject = "PRJNA293022", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1647915 | 1647915 | PRJNA293022_P_NODE_1342_length_1087_cov_4.688825_g1002_i0 | PRJNA293022 | 1342 | 1087 | 4.688825 | 50.96752775 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 63.9 | 5.11e-5 | NTclustered | gi|2034306571|ref|XM_041494631.1| | 1735272 | g1002 | i0 | 95 | 0.263109475620975 | 40 | 2 | 4 | 0 | 1048 | 1087 | 2453 | 2492 | PREDICTED: Gigantopelta aegis glycosyltransferase family 92 protein F13G3.3-like (LOC121369521), mRNA | blastn | 286 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 2334901 | 2334901 | PRJNA293022_P_NODE_16702_length_349_cov_2.283333_g15965_i0 | PRJNA293022 | 16702 | 349 | 2.283333 | 7.96883217 | Metazoa | 33208 | Mollusca | Mollusca | 52.8 | 0.033 | NTclustered | gi|2427390617|ref|XM_052917999.1| | 6604 | g15965 | i0 | 100 | 1.59885386819484 | 28 | 0 | 8 | 0 | 247 | 274 | 5153 | 5126 | PREDICTED: Mya arenaria protein mono-ADP-ribosyltransferase PARP14-like (LOC128212513), mRNA | blastn | 558 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 4200579 | 4200579 | PRJNA293022_P_NODE_71344_length_166_cov_6.017094_g70607_i0 | PRJNA293022 | 71344 | 166 | 6.017094 | 9.98837604 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 71.3 | 3.84e-8 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g70607 | i0 | 79.798 | 9.59036144578313 | 99 | 19 | 60 | 1 | 52 | 150 | 1526015 | 1526112 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 1592 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6750867 | 6750867 | PRJNA293022_P_NODE_17946_length_337_cov_2.760417_g17209_i0 | PRJNA293022 | 17946 | 337 | 2.760417 | 9.30260529 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.032 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g17209 | i0 | 100 | 0.0830860534124629 | 28 | 0 | 8 | 0 | 89 | 116 | 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 | |
| 10577288 | 10577288 | PRJNA293022_P_NODE_55309_length_187_cov_2.079710_g54572_i0 | PRJNA293022 | 55309 | 187 | 2.07971 | 3.8890577 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 73.1 | 1.23e-8 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g54572 | i0 | 92.157 | 26.7272727272727 | 51 | 4 | 27 | 0 | 137 | 187 | 40994331 | 40994381 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 4998 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11851926 | 11851926 | PRJNA293022_P_NODE_36150_length_232_cov_3.191257_g35413_i0 | PRJNA293022 | 36150 | 232 | 3.191257 | 7.40371624 | Aplysia californica | 6500 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|1897936549|ref|XM_005106389.3| | 6500 | g35413 | i0 | 100 | 0.120689655172414 | 28 | 0 | 12 | 0 | 23 | 50 | 3646 | 3673 | PREDICTED: Aplysia californica RRP12-like protein (LOC101856684), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 16950700 | 16950700 | PRJNA293022_P_NODE_45734_length_206_cov_2.337580_g44997_i0 | PRJNA293022 | 45734 | 206 | 2.33758 | 4.8154148 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g44997 | i0 | 100 | 0.140776699029126 | 29 | 0 | 14 | 0 | 172 | 200 | 34542891 | 34542863 | 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 | |
| 16950856 | 16950856 | PRJNA293022_P_NODE_78594_length_162_cov_1.486726_g77857_i0 | PRJNA293022 | 78594 | 162 | 1.486726 | 2.40849612 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.004 | NTclustered | gi|2912987826|dbj|AP039592.1| | 145626 | g77857 | i0 | 100 | 0.358024691358025 | 29 | 0 | 18 | 0 | 110 | 138 | 12703195 | 12703167 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 11, sequence | blastn | 58 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 18225008 | 18225008 | PRJNA293022_P_NODE_50655_length_196_cov_1.000000_g49918_i0 | PRJNA293022 | 50655 | 196 | 1 | 1.96 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 80.5 | 7.78e-11 | NTclustered | gi|2912984370|dbj|AP039589.1| | 145626 | g49918 | i0 | 84.146 | 4.04591836734694 | 82 | 13 | 42 | 0 | 83 | 164 | 74259630 | 74259711 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 8, sequence | blastn | 793 | 80.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19499173 | 19499173 | PRJNA293022_P_NODE_35836_length_233_cov_3.347826_g35099_i0 | PRJNA293022 | 35836 | 233 | 3.347826 | 7.80043458 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 71.3 | 5.76e-8 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g35099 | i0 | 77.099 | 2.4206008583691 | 131 | 25 | 55 | 5 | 104 | 232 | 52173515 | 52173388 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 564 | 71.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20774780 | 20774780 | PRJNA293022_P_NODE_44737_length_208_cov_5.119497_g44000_i0 | PRJNA293022 | 44737 | 208 | 5.119497 | 10.64855376 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 8.42e-6 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g44000 | i0 | 100 | 16.4759615384615 | 34 | 0 | 21 | 0 | 58 | 91 | 25479221 | 25479254 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 3427 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22049673 | 22049673 | PRJNA293022_P_NODE_31058_length_251_cov_4.410891_g30321_i0 | PRJNA293022 | 31058 | 251 | 4.410891 | 11.07133641 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 104 | 6.19e-18 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g30321 | i0 | 74.79 | 11.199203187251 | 238 | 56 | 94 | 4 | 14 | 250 | 2531839 | 2531605 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 2811 | 104 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22049762 | 22049762 | PRJNA293022_P_NODE_46358_length_205_cov_1.307692_g45621_i0 | PRJNA293022 | 46358 | 205 | 1.307692 | 2.6807686 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 113 | 3.64e-29 | NR | XP_052279311.1 | 45954 | g45621 | i0 | 89.1 | 4.68292682926829 | 64 | 7 | 93.7 | 0 | 4 | 195 | 120 | 183 | XP_052279311.1 40S ribosomal protein S6-like [Dreissena polymorpha] | diamond | 960 | 113 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 23325377 | 23325377 | PRJNA293022_P_NODE_54959_length_188_cov_1.345324_g54222_i0 | PRJNA293022 | 54959 | 188 | 1.345324 | 2.52920912 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 67.6 | 5.75e-7 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g54222 | i0 | 93.478 | 43.9521276595745 | 46 | 1 | 29 | 1 | 3 | 48 | 38292041 | 38292084 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 8263 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 24599287 | 24599287 | PRJNA293022_P_NODE_18220_length_334_cov_3.368421_g17483_i0 | PRJNA293022 | 18220 | 334 | 3.368421 | 11.25052614 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 5.23e-5 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g17483 | i0 | 77.57 | 0.82934131736527 | 107 | 21 | 31 | 2 | 119 | 223 | 8051560 | 8051665 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 277 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 27136972 | 27136972 | PRJNA293022_P_NODE_75702_length_164_cov_0.904348_g74965_i0 | PRJNA293022 | 75702 | 164 | 0.904348 | 1.48313072 | Liolophura japonica | 13599 | Mollusca | Mollusca | 43.9 | 0.00505 | NR | XP_064612331.1 | 13599 | g74965 | i0 | 59.5 | 0.676829268292683 | 37 | 15 | 67.7 | 0 | 112 | 2 | 288 | 324 | XP_064612331.1 LOW QUALITY PROTEIN: eukaryotic translation initiation factor 3 subunit C-like [Liolophura japonica] | diamond | 111 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 27358841 | 27358841 | PRJNA293022_P_NODE_37923_length_227_cov_1.117978_g37186_i0 | PRJNA293022 | 37923 | 227 | 1.117978 | 2.53781006 | Saccostrea cuccullata | 36930 | Mollusca | Mollusca | 47.4 | 6.71e-4 | NR | XP_062599881.1 | 36930 | g37186 | i0 | 32.2 | 1.70484581497797 | 59 | 40 | 78 | 0 | 24 | 200 | 21 | 79 | XP_062599881.1 uncharacterized protein LOC134261454 [Saccostrea cuccullata] | diamond | 387 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea cuccullata | |
| 28368978 | 28368978 | PRJNA293022_P_NODE_59306_length_180_cov_3.129771_g58569_i0 | PRJNA293022 | 59306 | 180 | 3.129771 | 5.6335878 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 41.2 | 0.0496 | NR | CAE1281722.1 | 158019 | g58569 | i0 | 51 | 0.85 | 51 | 16 | 75 | 3 | 44 | 178 | 4 | 51 | CAE1281722.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 153 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 31102715 | 31102715 | PRJNA293022_P_NODE_81415_length_157_cov_2.833333_g80678_i0 | PRJNA293022 | 81415 | 157 | 2.833333 | 4.44833281 | Metazoa | 33208 | Mollusca | Mollusca | 44.7 | 0.00246 | NR | XP_052103364.1 | 6549 | g80678 | i0 | 81 | 34.9108280254777 | 21 | 4 | 40.1 | 0 | 50 | 112 | 652 | 672 | XP_052103364.1 uncharacterized protein LOC127736809 [Mytilus californianus] | diamond | 5481 | 45.1 | 0.991130820399113 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 31211171 | 31211171 | PRJNA293022_P_NODE_38155_length_226_cov_1.768362_g37418_i0 | PRJNA293022 | 38155 | 226 | 1.768362 | 3.99649812 | Liolophura japonica | 13599 | Mollusca | Mollusca | 52.4 | 1.25e-5 | NR | XP_064599930.1 | 13599 | g37418 | i0 | 38.2 | 0.902654867256637 | 68 | 42 | 90.3 | 0 | 226 | 23 | 288 | 355 | XP_064599930.1 LOW QUALITY PROTEIN: spectrin beta chain-like [Liolophura japonica] | diamond | 204 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 31464900 | 31464900 | PRJNA293022_P_NODE_43876_length_210_cov_7.819876_g43139_i0 | PRJNA293022 | 43876 | 210 | 7.819876 | 16.4217396 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 42.4 | 0.0335 | NR | CAE1162969.1 | 158019 | g43139 | i0 | 52.2 | 0.957142857142857 | 67 | 16 | 92.9 | 5 | 2 | 196 | 606 | 658 | CAE1162969.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 201 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 32002443 | 32002443 | PRJNA293022_P_NODE_30378_length_254_cov_5.790244_g29641_i0 | PRJNA293022 | 30378 | 254 | 5.790244 | 14.70721976 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.9 | 0.0159 | NR | XP_067657806.1 | 109174 | g29641 | i0 | 35.4 | 1.51181102362205 | 65 | 36 | 75.6 | 2 | 19 | 210 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 384 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina |
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);;