contig_metadata
17 rows where bioproject = "PRJNA1240804", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5452564 | 5452564 | PRJNA1240804_P_NODE_83225_length_184_cov_1.533333_g82859_i0 | PRJNA1240804 | 83225 | 184 | 1.533333 | 2.82133272 | Deroceras reticulatum | 145610 | Mollusca | Mollusca | 296 | 6.57e-76 | NTclustered | gi|1273386133|gb|KX959514.1| | 145610 | g82859 | i0 | 98.795 | 91.5380434782609 | 166 | 2 | 90 | 0 | 5 | 170 | 720 | 555 | Deroceras reticulatum 28S ribosomal RNA gene, partial sequence | blastn | 16843 | 296 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Agriolimacidae | Deroceras | Deroceras reticulatum | |
| 9275116 | 9275116 | PRJNA1240804_P_NODE_111008_length_169_cov_0.866667_g110642_i0 | PRJNA1240804 | 111008 | 169 | 0.866667 | 1.46466723 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|1397726079|ref|XM_025254298.1| | 400727 | g110642 | i0 | 90 | 0.236686390532544 | 40 | 4 | 24 | 0 | 61 | 100 | 861 | 900 | PREDICTED: Pomacea canaliculata protein DEK-like (LOC112573717), mRNA | blastn | 40 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 9275993 | 9275993 | PRJNA1240804_P_NODE_21248_length_304_cov_3.462745_g20882_i0 | PRJNA1240804 | 21248 | 304 | 3.462745 | 10.5267448 | Cornu aspersum | 6535 | Mollusca | Mollusca | 523 | 4.989999999999998e-144 | NTclustered | gi|2644119680|gb|PP069353.1| | 6535 | g20882 | i0 | 99.308 | 146.611842105263 | 289 | 2 | 95 | 0 | 3 | 291 | 3024 | 2736 | Cornu aspersum isolate hlxa 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 44570 | 523 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Helicidae | Cornu | Cornu aspersum | |
| 10552178 | 10552178 | PRJNA1240804_P_NODE_3669_length_605_cov_4.787770_g3328_i0 | PRJNA1240804 | 3669 | 605 | 4.78777 | 28.9660085 | Cornu aspersum | 6535 | Mollusca | Mollusca | 1112 | 0 | NTclustered | gi|2644119680|gb|PP069353.1| | 6535 | g3328 | i0 | 99.835 | 154.695867768595 | 605 | 1 | 100 | 0 | 1 | 605 | 1004 | 1608 | Cornu aspersum isolate hlxa 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 93591 | 1112 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Helicidae | Cornu | Cornu aspersum | |
| 11253219 | 11253219 | PRJNA1240804_P_NODE_122049_length_167_cov_0.881356_g121683_i0 | PRJNA1240804 | 122049 | 167 | 0.881356 | 1.47186452 | Cephalopoda | 6605 | Mollusca | Mollusca | 283 | 4.56e-72 | NTclustered | gi|1707061938|dbj|LC458522.1| | 34570 | g121683 | i0 | 100 | 77.4491017964072 | 153 | 0 | 92 | 0 | 1 | 153 | 647 | 495 | Sepioteuthis lessoniana Lessoniana-11 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence | blastn | 12934 | 283 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Myopsida | Loliginidae | Sepioteuthis | Sepioteuthis lessoniana | |
| 13101598 | 13101598 | PRJNA1240804_P_NODE_21071_length_305_cov_3.484375_g20705_i0 | PRJNA1240804 | 21071 | 305 | 3.484375 | 10.62734375 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 460 | 3.99e-125 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g20705 | i0 | 95.189 | 170.937704918033 | 291 | 14 | 95 | 0 | 15 | 305 | 1529 | 1239 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 52136 | 460 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 13803664 | 13803664 | PRJNA1240804_P_NODE_52931_length_214_cov_3.327273_g52565_i0 | PRJNA1240804 | 52931 | 214 | 3.327273 | 7.12036422 | Helicidae | 6533 | Mollusca | Mollusca | 370 | 4.58e-98 | NTclustered | gi|2644119680|gb|PP069353.1| | 6535 | g52565 | i0 | 100 | 144.710280373832 | 200 | 0 | 93 | 0 | 15 | 214 | 2038 | 2237 | Cornu aspersum isolate hlxa 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 30968 | 370 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Helicidae | Cornu | Cornu aspersum | |
| 15077831 | 15077831 | PRJNA1240804_P_NODE_54712_length_212_cov_1.453988_g54346_i0 | PRJNA1240804 | 54712 | 212 | 1.453988 | 3.08245456 | Metazoa | 33208 | Mollusca | Mollusca | 366 | 5.86e-97 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g54346 | i0 | 100 | 93.3962264150943 | 198 | 0 | 93 | 0 | 15 | 212 | 1121 | 1318 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 19800 | 366 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 18198694 | 18198694 | PRJNA1240804_P_NODE_117415_length_167_cov_1.762712_g117049_i0 | PRJNA1240804 | 117415 | 167 | 1.762712 | 2.94372904 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 2.33e-5 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g117049 | i0 | 82.192 | 0.437125748502994 | 73 | 11 | 43 | 1 | 28 | 98 | 63097219 | 63097147 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 73 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20176386 | 20176386 | PRJNA1240804_P_NODE_42856_length_231_cov_3.456044_g42490_i0 | PRJNA1240804 | 42856 | 231 | 3.456044 | 7.98346164 | Stylommatophora | 6527 | Mollusca | Mollusca | 425 | 1.0599999999999999e-114 | NTclustered | gi|2644119680|gb|PP069353.1| | 6535 | g42490 | i0 | 100 | 99.5670995670996 | 230 | 0 | 99 | 0 | 2 | 231 | 825 | 596 | Cornu aspersum isolate hlxa 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 23000 | 425 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Helicidae | Cornu | Cornu aspersum | |
| 22727385 | 22727385 | PRJNA1240804_P_NODE_97898_length_175_cov_0.968254_g97532_i0 | PRJNA1240804 | 97898 | 175 | 0.968254 | 1.6944445 | Nudibranchia | 70849 | Mollusca | Mollusca | 52.8 | 0.015 | NTclustered | gi|13591651|gb|AF249196.1| | 71480 | g97532 | i0 | 100 | 9.76 | 28 | 0 | 16 | 0 | 15 | 42 | 92 | 119 | Armina lovenii 18S ribosomal RNA gene, complete sequence | blastn | 1708 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Nudibranchia | Arminidae | Armina | Armina lovenii | |
| 24573303 | 24573303 | PRJNA1240804_P_NODE_11800_length_383_cov_1.850299_g11435_i0 | PRJNA1240804 | 11800 | 383 | 1.850299 | 7.08664517 | Cornu aspersum | 6535 | Mollusca | Mollusca | 459 | 1.84e-124 | NTclustered | gi|298573172|gb|HM179145.1| | 6535 | g11435 | i0 | 99.602 | 100.21409921671 | 251 | 1 | 66 | 0 | 1 | 251 | 346 | 96 | Helix aspersa 18S ribosomal RNA gene, partial sequence | blastn | 38382 | 459 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Helicidae | Cornu | Cornu aspersum | |
| 27249699 | 27249699 | PRJNA1240804_P_NODE_41523_length_234_cov_2.248649_g41157_i0 | PRJNA1240804 | 41523 | 234 | 2.248649 | 5.26183866 | Opisthokonta | 33154 | Mollusca | Mollusca | 65.5 | 3.23e-10 | NR | KAK6167008.1 | 87958 | g41157 | i0 | 44.3 | 4.64102564102564 | 70 | 39 | 89.7 | 0 | 9 | 218 | 405 | 474 | KAK6167008.1 hypothetical protein SNE40_021121 [Patella caerulea] | diamond | 1086 | 65.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 28589498 | 28589498 | PRJNA1240804_P_NODE_119347_length_167_cov_0.881356_g118981_i0 | PRJNA1240804 | 119347 | 167 | 0.881356 | 1.47186452 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 70.5 | 2.19e-12 | NR | XP_022315529.1 | 6565 | g118981 | i0 | 90.6 | 2.29940119760479 | 32 | 3 | 57.5 | 0 | 70 | 165 | 939 | 970 | XP_022315529.1 DNA-directed RNA polymerase I subunit RPA1-like [Crassostrea virginica] | diamond | 384 | 70.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 30768654 | 30768654 | PRJNA1240804_P_NODE_150974_length_162_cov_0.920354_g150608_i0 | PRJNA1240804 | 150974 | 162 | 0.920354 | 1.49097348 | Magallana gigas | 29159 | Mollusca | Mollusca | 52.4 | 5.04e-6 | NR | XP_011416541.3 | 29159 | g150608 | i0 | 52.3 | 4.05555555555556 | 44 | 21 | 81.5 | 0 | 19 | 150 | 261 | 304 | XP_011416541.3 diacylglycerol kinase epsilon [Magallana gigas] | diamond | 657 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 32146522 | 32146522 | PRJNA1240804_P_NODE_67338_length_196_cov_1.734694_g66972_i0 | PRJNA1240804 | 67338 | 196 | 1.734694 | 3.40000024 | Opisthokonta | 33154 | Mollusca | Mollusca | 43.1 | 0.0147 | NR | CAG2204468.1 | 6550 | g66972 | i0 | 32.1 | 1.53061224489796 | 56 | 38 | 85.7 | 0 | 172 | 5 | 105 | 160 | CAG2204468.1 unnamed protein product [Mytilus edulis] | diamond | 300 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 32620768 | 32620768 | PRJNA1240804_P_NODE_131020_length_165_cov_0.896552_g130654_i0 | PRJNA1240804 | 131020 | 165 | 0.896552 | 1.4793108 | Metazoa | 33208 | Mollusca | Mollusca | 59.3 | 1.81e-8 | NR | XP_052816977.1 | 6604 | g130654 | i0 | 52 | 35.4545454545455 | 50 | 24 | 90.9 | 0 | 151 | 2 | 189 | 238 | XP_052816977.1 H(+)/Cl(-) exchange transporter 7-like [Mya arenaria] | diamond | 5850 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria |
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);;