contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA340009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6770254 | 6770254 | PRJNA340009_P_NODE_906_length_968_cov_2.215452_g681_i0 | PRJNA340009 | 906 | 968 | 2.215452 | 21.44557536 | root | 1 | Root_unresolved | Root_unresolved | 390 | 1.4699999999999995e-129 | NR | XP_005099373.3 | 6500 | g681 | i0 | 70.9 | 45.551652892562 | 265 | 77 | 82.1 | 0 | 174 | 968 | 35 | 299 | XP_005099373.3 propionyl-CoA carboxylase beta chain, mitochondrial [Aplysia californica] | diamond | 44094 | 392 | 0.994897959183674 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 26870794 | 26870794 | PRJNA340009_P_NODE_12121_length_335_cov_1.006993_g11814_i0 | PRJNA340009 | 12121 | 335 | 1.006993 | 3.37342655 | Opisthokonta | 33154 | Mollusca | Mollusca | 67.8 | 1.81e-10 | NR | CAL1535444.1 | 6523 | g11814 | i0 | 42.5 | 3.65373134328358 | 80 | 39 | 71.6 | 1 | 328 | 89 | 730 | 802 | CAL1535444.1 unnamed protein product, partial [Lymnaea stagnalis] | diamond | 1224 | 68.2 | 0.994134897360704 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 29316801 | 29316801 | PRJNA340009_P_NODE_63389_length_166_cov_4.324786_g63082_i0 | PRJNA340009 | 63389 | 166 | 4.324786 | 7.17914476 | Pecten maximus | 6579 | Mollusca | Mollusca | 49.3 | 3.87e-5 | NR | XP_033725222.1 | 6579 | g63082 | i0 | 53.2 | 0.849397590361446 | 47 | 21 | 84.9 | 1 | 158 | 18 | 115 | 160 | XP_033725222.1 uncharacterized protein LOC117315187 [Pecten maximus] | diamond | 141 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 29916899 | 29916899 | PRJNA340009_P_NODE_25611_length_243_cov_2.417526_g25304_i0 | PRJNA340009 | 25611 | 243 | 2.417526 | 5.87458818 | Mya arenaria | 6604 | Mollusca | Mollusca | 73.2 | 4.38e-13 | NR | XP_052776588.1 | 6604 | g25304 | i0 | 62.3 | 1.30864197530864 | 53 | 20 | 65.4 | 0 | 169 | 11 | 213 | 265 | XP_052776588.1 UDP-sugar transporter sqv-7-like [Mya arenaria] | diamond | 318 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 30359545 | 30359545 | PRJNA340009_P_NODE_33352_length_217_cov_2.428571_g33045_i0 | PRJNA340009 | 33352 | 217 | 2.428571 | 5.26999907 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 44.7 | 0.00583 | NR | XP_048248442.1 | 6454 | g33045 | i0 | 41.5 | 0.732718894009217 | 53 | 31 | 73.3 | 0 | 58 | 216 | 386 | 438 | XP_048248442.1 WD repeat and FYVE domain-containing protein 3-like isoform X1 [Haliotis rufescens] | diamond | 159 | 44.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 30502719 | 30502719 | PRJNA340009_P_NODE_7853_length_398_cov_50.378223_g7546_i0 | PRJNA340009 | 7853 | 398 | 50.378223 | 200.50532754 | root | 1 | Root_unresolved | Root_unresolved | 173 | 1.69e-52 | NR | XP_033735668.1 | 6579 | g7546 | i0 | 85.7 | 14.035175879397 | 98 | 14 | 73.9 | 0 | 397 | 104 | 67 | 164 | XP_033735668.1 peptidyl-prolyl cis-trans isomerase-like [Pecten maximus] | diamond | 5586 | 173 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 30611691 | 30611691 | PRJNA340009_P_NODE_55193_length_175_cov_8.626984_g54886_i0 | PRJNA340009 | 55193 | 175 | 8.626984 | 15.097222 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 57.8 | 1.91e-8 | NR | KAL4235966.1 | 2302425 | g54886 | i0 | 55.1 | 1.68 | 49 | 22 | 84 | 0 | 175 | 29 | 70 | 118 | KAL4235966.1 Transmembrane protein 18 [Mactra antiquata] | diamond | 294 | 57.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata | |
| 31054444 | 31054444 | PRJNA340009_P_NODE_23435_length_252_cov_2.261084_g23128_i0 | PRJNA340009 | 23435 | 252 | 2.261084 | 5.69793168 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 47.4 | 8.74e-4 | NR | CAG5133355.1 | 100452 | g23128 | i0 | 86.4 | 0.261904761904762 | 22 | 3 | 26.2 | 0 | 86 | 151 | 130 | 151 | CAG5133355.1 unnamed protein product [Candidula unifasciata] | diamond | 66 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 31514325 | 31514325 | PRJNA340009_P_NODE_42756_length_195_cov_8.397260_g42449_i0 | PRJNA340009 | 42756 | 195 | 8.39726 | 16.374657 | Opisthokonta | 33154 | Mollusca | Mollusca | 46.2 | 0.00124 | NR | CAG2224203.1 | 6550 | g42449 | i0 | 48.4 | 8.07692307692308 | 31 | 16 | 47.7 | 0 | 13 | 105 | 706 | 736 | CAG2224203.1 G-protein coupled receptor GRL101 [Mytilus edulis] | diamond | 1575 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 31545847 | 31545847 | PRJNA340009_P_NODE_22536_length_256_cov_7.154589_g22229_i0 | PRJNA340009 | 22536 | 256 | 7.154589 | 18.31574784 | Mytilus | 6548 | Mollusca | Mollusca | 74.7 | 2.45e-13 | NR | XP_052061000.1 | 6549 | g22229 | i0 | 66 | 6.4453125 | 50 | 17 | 58.6 | 0 | 50 | 199 | 2 | 51 | XP_052061000.1 uncharacterized protein LOC127701221 isoform X7 [Mytilus californianus] | diamond | 1650 | 75.1 | 0.994673768308922 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 31591878 | 31591878 | PRJNA340009_P_NODE_23816_length_250_cov_6.149254_g23509_i0 | PRJNA340009 | 23816 | 250 | 6.149254 | 15.373135 | Magallana angulata | 2784310 | Mollusca | Mollusca | 72.4 | 1.31e-12 | NR | XP_052692741.1 | 2784310 | g23509 | i0 | 50.7 | 0.876 | 73 | 29 | 79.2 | 1 | 221 | 24 | 177 | 249 | XP_052692741.1 uncharacterized protein LOC128171017 [Magallana angulata] | diamond | 219 | 72.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana angulata |
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);;