contig_metadata
16 rows where bioproject = "PRJEB673", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3961054 | 3961054 | PRJEB673_P_NODE_7244_length_321_cov_1.527972_g6895_i0 | PRJEB673 | 7244 | 321 | 1.527972 | 4.90479012 | Mya arenaria | 6604 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|2427419089|ref|XM_052927617.1| | 6604 | g6895 | i0 | 96.875 | 0.0996884735202492 | 32 | 1 | 10 | 0 | 186 | 217 | 8333 | 8364 | PREDICTED: Mya arenaria uncharacterized LOC128219697 (LOC128219697), mRNA | blastn | 32 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 6512965 | 6512965 | PRJEB673_P_NODE_10106_length_180_cov_2.593103_g9757_i0 | PRJEB673 | 10106 | 180 | 2.593103 | 4.6675854 | Sthenoteuthis oualaniensis | 34553 | Mollusca | Mollusca | 171 | 4.0399999999999996e-38 | NTclustered | gi|186920083|ref|NC_010636.1| | 34553 | g9757 | i0 | 84.659 | 89.6111111111111 | 176 | 22 | 96 | 5 | 1 | 173 | 2362 | 2189 | Sthenoteuthis oualaniensis mitochondrion, complete genome | blastn | 16130 | 171 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Oegopsida | Ommastrephidae | Sthenoteuthis | Sthenoteuthis oualaniensis | |
| 7787325 | 7787325 | PRJEB673_P_NODE_8227_length_291_cov_1.875000_g7878_i0 | PRJEB673 | 8227 | 291 | 1.875 | 5.45625 | Metazoa | 33208 | Mollusca | Mollusca | 163 | 5.809999999999998e-48 | NR | XP_050413940.1 | 6465 | g7878 | i0 | 74 | 89.0721649484536 | 96 | 25 | 99 | 0 | 290 | 3 | 87 | 182 | XP_050413940.1 60S ribosomal protein L8 [Patella vulgata] | diamond | 25920 | 164 | 0.99390243902439 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 10337972 | 10337972 | PRJEB673_P_NODE_4709_length_427_cov_2.380102_g4361_i0 | PRJEB673 | 4709 | 427 | 2.380102 | 10.16303554 | Amphioctopus fangsiao | 515817 | Mollusca | Mollusca | 137 | 1.1e-27 | NTclustered | gi|2186270437|gb|MT180322.1| | 515817 | g4361 | i0 | 86.885 | 28.3044496487119 | 122 | 16 | 29 | 0 | 125 | 246 | 9712 | 9591 | Amphioctopus fangsiao mitochondrion, complete genome | blastn | 12086 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Amphioctopus | Amphioctopus fangsiao | |
| 14163339 | 14163339 | PRJEB673_P_NODE_732_length_1064_cov_2.483965_g569_i0 | PRJEB673 | 732 | 1064 | 2.483965 | 26.4293876 | Aplysia californica | 6500 | Mollusca | Mollusca | 179 | 6.97e-49 | NR | XP_012937301.1 | 6500 | g569 | i0 | 44.5 | 0.620300751879699 | 220 | 112 | 60.3 | 4 | 45 | 686 | 8 | 223 | XP_012937301.1 dnaJ homolog subfamily A member 1 [Aplysia californica] | diamond | 660 | 179 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 19260540 | 19260540 | PRJEB673_P_NODE_6956_length_328_cov_2.313993_g6607_i0 | PRJEB673 | 6956 | 328 | 2.313993 | 7.58989704 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 187 | 8.11e-43 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g6607 | i0 | 87.273 | 4.41158536585366 | 165 | 20 | 50 | 1 | 1 | 164 | 55579203 | 55579367 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 1447 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 19260568 | 19260568 | PRJEB673_P_NODE_9956_length_183_cov_2.432432_g9607_i0 | PRJEB673 | 9956 | 183 | 2.432432 | 4.45135056 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 143 | 8.989999999999998e-30 | NTclustered | gi|1914622278|ref|XM_029795136.2| | 2607531 | g9607 | i0 | 88.235 | 22.4590163934426 | 119 | 14 | 65 | 0 | 1 | 119 | 1487 | 1605 | PREDICTED: Octopus sinensis tubulin alpha-1B chain (LOC115224301), mRNA | blastn | 4110 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 20121789 | 20121789 | PRJEB673_P_NODE_6216_length_350_cov_7.400000_g5867_i0 | PRJEB673 | 6216 | 350 | 7.4 | 25.9 | Cephalaspidea | 69554 | Mollusca | Mollusca | 159 | 1.8899999999999998e-34 | NTclustered | gi|1704728144|gb|MK473569.1| | 413673 | g5867 | i0 | 76.512 | 54.1628571428571 | 281 | 56 | 79 | 9 | 4 | 280 | 326 | 52 | Lamprohaminoea ovalis isolate TH74 histone 3 (H3) gene, partial cds | blastn | 18957 | 159 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Cephalaspidea | Haminoeidae | Lamprohaminoea | Lamprohaminoea ovalis | |
| 20535872 | 20535872 | PRJEB673_P_NODE_8877_length_229_cov_0.948454_g8528_i0 | PRJEB673 | 8877 | 229 | 0.948454 | 2.17195966 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2442010133|ref|XM_045346008.2| | 6596 | g8528 | i0 | 96.97 | 2.52401746724891 | 33 | 1 | 14 | 0 | 35 | 67 | 1028 | 996 | PREDICTED: Mercenaria mercenaria uncharacterized LOC123555358 (LOC123555358), transcript variant X1, mRNA | blastn | 578 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 26741620 | 26741620 | PRJEB673_P_NODE_3281_length_551_cov_2.352713_g2965_i0 | PRJEB673 | 3281 | 551 | 2.352713 | 12.96344863 | Opisthokonta | 33154 | Mollusca | Mollusca | 199 | 2.56e-59 | NR | XP_052270358.1 | 45954 | g2965 | i0 | 61 | 8.92921960072595 | 164 | 50 | 89.3 | 2 | 3 | 494 | 234 | 383 | XP_052270358.1 4-hydroxyphenylpyruvate dioxygenase-like [Dreissena polymorpha] | diamond | 4920 | 201 | 0.990049751243781 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 27152895 | 27152895 | PRJEB673_P_NODE_8462_length_273_cov_1.491597_g8113_i0 | PRJEB673 | 8462 | 273 | 1.491597 | 4.07205981 | Metazoa | 33208 | Mollusca | Mollusca | 53.1 | 1.24e-5 | NR | KAH9512959.1 | 55810 | g8113 | i0 | 63.2 | 1.38461538461538 | 38 | 14 | 41.8 | 0 | 25 | 138 | 1536 | 1573 | KAH9512959.1 Stabilin-2 [Bulinus truncatus] | diamond | 378 | 53.5 | 0.992523364485981 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 27160255 | 27160255 | PRJEB673_P_NODE_4522_length_442_cov_1.535627_g4176_i0 | PRJEB673 | 4522 | 442 | 1.535627 | 6.78747134 | Elysia marginata | 1093978 | Mollusca | Mollusca | 107 | 1.83e-27 | NR | GFS19501.1 | 1093978 | g4176 | i0 | 77.8 | 2.56561085972851 | 54 | 12 | 36.7 | 0 | 393 | 232 | 1 | 54 | GFS19501.1 40S ribosomal protein S29 [Elysia marginata] | diamond | 1134 | 107 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 28297378 | 28297378 | PRJEB673_P_NODE_9726_length_189_cov_1.259740_g9377_i0 | PRJEB673 | 9726 | 189 | 1.25974 | 2.3809086 | Aplysia californica | 6500 | Mollusca | Mollusca | 42.7 | 0.0186 | NR | XP_005097974.2 | 6500 | g9377 | i0 | 54.1 | 4.92063492063492 | 37 | 17 | 58.7 | 0 | 117 | 7 | 104 | 140 | XP_005097974.2 collagen alpha-1(XII) chain [Aplysia californica] | diamond | 930 | 42.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 28613201 | 28613201 | PRJEB673_P_NODE_9367_length_200_cov_1.309091_g9018_i0 | PRJEB673 | 9367 | 200 | 1.309091 | 2.618182 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 54.7 | 2.02e-7 | NR | XP_025092844.1 | 400727 | g9018 | i0 | 43.9 | 0.615 | 41 | 23 | 61.5 | 0 | 137 | 15 | 36 | 76 | XP_025092844.1 antistasin-like [Pomacea canaliculata] | diamond | 123 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 31108213 | 31108213 | PRJEB673_P_NODE_9515_length_195_cov_1.162500_g9166_i0 | PRJEB673 | 9515 | 195 | 1.1625 | 2.266875 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 52.4 | 2.01e-6 | NR | XP_014776945.1 | 37653 | g9166 | i0 | 42.6 | 2.09230769230769 | 68 | 33 | 95.4 | 3 | 9 | 194 | 21 | 88 | XP_014776945.1 actophorin-like [Octopus bimaculoides] | diamond | 408 | 52.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 31139569 | 31139569 | PRJEB673_P_NODE_8955_length_221_cov_1.865591_g8606_i0 | PRJEB673 | 8955 | 221 | 1.865591 | 4.12295611 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 42.7 | 0.0233 | NR | BFY99874.1 | 145626 | g8606 | i0 | 57.7 | 0.705882352941177 | 52 | 19 | 70.6 | 1 | 3 | 158 | 54 | 102 | BFY99874.1 hypothetical protein BsWGS_02914 [Bradybaena similaris] | diamond | 156 | 42.7 | 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);;