contig_metadata
15 rows where bioproject = "PRJNA1022392", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6540160 | 6540160 | PRJNA1022392_P_NODE_28886_length_206_cov_4.144654_g28217_i0 | PRJNA1022392 | 28886 | 206 | 4.144654 | 8.53798724 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g28217 | i0 | 100 | 0.427184466019417 | 30 | 0 | 15 | 0 | 68 | 97 | 41445040 | 41445011 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 88 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7814481 | 7814481 | PRJNA1022392_P_NODE_19867_length_240_cov_1.953368_g19198_i0 | PRJNA1022392 | 19867 | 240 | 1.953368 | 4.6880832 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g19198 | i0 | 100 | 0.116666666666667 | 28 | 0 | 12 | 0 | 108 | 135 | 34723434 | 34723407 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12916081 | 12916081 | PRJNA1022392_P_NODE_60451_length_176_cov_6.449612_g59782_i0 | PRJNA1022392 | 60451 | 176 | 6.449612 | 11.35131712 | Mya arenaria | 6604 | Mollusca | Mollusca | 52.8 | 0.015 | NTclustered | gi|2427347820|ref|XM_052943611.1| | 6604 | g59782 | i0 | 100 | 0.159090909090909 | 28 | 0 | 16 | 0 | 148 | 175 | 4314 | 4287 | PREDICTED: Mya arenaria integrin beta-1-like (LOC128231151), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 19287939 | 19287939 | PRJNA1022392_P_NODE_49096_length_191_cov_3.701389_g48427_i0 | PRJNA1022392 | 49096 | 191 | 3.701389 | 7.06965299 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g48427 | i0 | 90.698 | 0.225130890052356 | 43 | 1 | 21 | 3 | 14 | 54 | 1610128 | 1610169 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 43 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23956090 | 23956090 | PRJNA1022392_P_NODE_31299_length_206_cov_3.238994_g30630_i0 | PRJNA1022392 | 31299 | 206 | 3.238994 | 6.67232764 | Calyptogena | 6589 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|1237088178|dbj|AP014549.1| | 43209 | g30630 | i0 | 100 | 0.29126213592233 | 30 | 0 | 15 | 0 | 38 | 67 | 6740 | 6769 | Calyptogena fausta mitochondrial DNA, partial sequence | blastn | 60 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Vesicomyidae | Calyptogena | Calyptogena fausta | |
| 27287833 | 27287833 | PRJNA1022392_P_NODE_62263_length_174_cov_2.566929_g61594_i0 | PRJNA1022392 | 62263 | 174 | 2.566929 | 4.46645646 | Mya arenaria | 6604 | Mollusca | Mollusca | 54.3 | 1.26e-6 | NR | WAR17153.1 | 6604 | g61594 | i0 | 44 | 3.3448275862069 | 50 | 28 | 86.2 | 0 | 4 | 153 | 535 | 584 | WAR17153.1 LOW QUALITY PROTEIN: ZN845-like protein [Mya arenaria] | diamond | 582 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 27603919 | 27603919 | PRJNA1022392_P_NODE_54524_length_184_cov_2.525547_g53855_i0 | PRJNA1022392 | 54524 | 184 | 2.525547 | 4.64700648 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 78.6 | 4.02e-15 | NR | PVD32243.1 | 400727 | g53855 | i0 | 63.6 | 3.68478260869565 | 55 | 20 | 89.7 | 0 | 8 | 172 | 94 | 148 | PVD32243.1 hypothetical protein C0Q70_07676 [Pomacea canaliculata] | diamond | 678 | 78.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 27943266 | 27943266 | PRJNA1022392_P_NODE_57365_length_180_cov_7.045113_g56696_i0 | PRJNA1022392 | 57365 | 180 | 7.045113 | 12.6812034 | Metazoa | 33208 | Mollusca | Mollusca | 42.7 | 0.0166 | NR | KAK6189789.1 | 87958 | g56696 | i0 | 65.4 | 4.35 | 26 | 9 | 43.3 | 0 | 88 | 165 | 391 | 416 | KAK6189789.1 hypothetical protein SNE40_001782 [Patella caerulea] | diamond | 783 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 29214207 | 29214207 | PRJNA1022392_P_NODE_42729_length_195_cov_3.385135_g42060_i0 | PRJNA1022392 | 42729 | 195 | 3.385135 | 6.60101325 | Lottia gigantea | 225164 | Mollusca | Mollusca | 41.6 | 0.0492 | NR | XP_009058232.1 | 225164 | g42060 | i0 | 55.6 | 0.415384615384615 | 27 | 10 | 41.5 | 1 | 75 | 155 | 157 | 181 | XP_009058232.1 hypothetical protein LOTGIDRAFT_217488 [Lottia gigantea] | diamond | 81 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 29584686 | 29584686 | PRJNA1022392_P_NODE_33730_length_206_cov_2.679245_g33061_i0 | PRJNA1022392 | 33730 | 206 | 2.679245 | 5.5192447 | Bivalvia | 6544 | Mollusca | Mollusca | 43.9 | 0.00884 | NR | VDI02709.1 | 29158 | g33061 | i0 | 59.3 | 0.786407766990291 | 27 | 11 | 39.3 | 0 | 84 | 4 | 74 | 100 | VDI02709.1 Hypothetical predicted protein [Mytilus galloprovincialis] | diamond | 162 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 29647758 | 29647758 | PRJNA1022392_P_NODE_63190_length_173_cov_2.000000_g62521_i0 | PRJNA1022392 | 63190 | 173 | 2 | 3.46 | Metazoa | 33208 | Mollusca | Mollusca | 68.9 | 7.06e-12 | NR | WAR15801.1 | 6604 | g62521 | i0 | 58.5 | 7.57803468208092 | 53 | 21 | 91.9 | 1 | 6 | 164 | 304 | 355 | WAR15801.1 YMD3-like protein [Mya arenaria] | diamond | 1311 | 68.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 29742642 | 29742642 | PRJNA1022392_P_NODE_83190_length_153_cov_2.367925_g82521_i0 | PRJNA1022392 | 83190 | 153 | 2.367925 | 3.62292525 | Metazoa | 33208 | Mollusca | Mollusca | 69.7 | 3.28e-12 | NR | KAL5012489.1 | 13268 | g82521 | i0 | 74.4 | 16.6078431372549 | 43 | 11 | 84.3 | 0 | 24 | 152 | 797 | 839 | KAL5012489.1 hypothetical protein ScPMuIL_011040 [Solemya velum] | diamond | 2541 | 70.1 | 0.994293865905849 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 31069978 | 31069978 | PRJNA1022392_P_NODE_32355_length_206_cov_2.968553_g31686_i0 | PRJNA1022392 | 32355 | 206 | 2.968553 | 6.11521918 | Metazoa | 33208 | Mollusca | Mollusca | 46.6 | 9.96e-4 | NR | CAG2232531.1 | 6550 | g31686 | i0 | 73.3 | 4.80582524271845 | 30 | 8 | 43.7 | 0 | 112 | 23 | 303 | 332 | CAG2232531.1 Transmembrane protein 145 [Mytilus edulis] | diamond | 990 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 31773270 | 31773270 | PRJNA1022392_P_NODE_72017_length_163_cov_2.456897_g71348_i0 | PRJNA1022392 | 72017 | 163 | 2.456897 | 4.00474211 | Pecten maximus | 6579 | Mollusca | Mollusca | 51.6 | 9.45e-6 | NR | XP_033727799.1 | 6579 | g71348 | i0 | 51.9 | 0.957055214723926 | 52 | 25 | 95.7 | 0 | 156 | 1 | 349 | 400 | XP_033727799.1 uncharacterized protein LOC117317109 [Pecten maximus] | diamond | 156 | 51.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 32619451 | 32619451 | PRJNA1022392_P_NODE_81000_length_157_cov_0.854545_g80331_i0 | PRJNA1022392 | 81000 | 157 | 0.854545 | 1.34163565 | Stylommatophora | 6527 | Mollusca | Mollusca | 77 | 5.4e-15 | NR | CAG5120411.1 | 100452 | g80331 | i0 | 72.5 | 21.3248407643312 | 51 | 14 | 97.5 | 0 | 3 | 155 | 257 | 307 | CAG5120411.1 unnamed protein product, partial [Candidula unifasciata] | diamond | 3348 | 77 | 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);;