contig_metadata
11 rows where bioproject = "PRJEB2925", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2575918 | 2575918 | PRJEB2925_P_NODE_12703_length_298_cov_1.866920_g11426_i0 | PRJEB2925 | 12703 | 298 | 1.86692 | 5.5634216 | Metazoa | 33208 | Mollusca | Mollusca | 134 | 1.53e-38 | NR | XP_021373399.1 | 6573 | g11426 | i0 | 74.1 | 11.0939597315436 | 85 | 22 | 85.6 | 0 | 255 | 1 | 1 | 85 | XP_021373399.1 probable 60S ribosomal protein L37-A [Mizuhopecten yessoensis] | diamond | 3306 | 135 | 0.992592592592593 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 6404291 | 6404291 | PRJEB2925_P_NODE_15326_length_257_cov_2.058559_g14048_i0 | PRJEB2925 | 15326 | 257 | 2.058559 | 5.29049663 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 99 | 2.96e-16 | NTclustered | gi|1207979940|ref|XM_021483812.1| | 6573 | g14048 | i0 | 81.897 | 0.45136186770428 | 116 | 21 | 45 | 0 | 50 | 165 | 34 | 149 | PREDICTED: Mizuhopecten yessoensis 40S ribosomal protein S24-like (LOC110440645), partial mRNA | blastn | 116 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 10228953 | 10228953 | PRJEB2925_P_NODE_8289_length_429_cov_1.791878_g7055_i0 | PRJEB2925 | 8289 | 429 | 1.791878 | 7.68715662 | Mya arenaria | 6604 | Mollusca | Mollusca | 58.4 | 8.89e-4 | NTclustered | gi|2427531503|ref|XM_052963179.1| | 6604 | g7055 | i0 | 100 | 0.275058275058275 | 31 | 0 | 7 | 0 | 296 | 326 | 1836 | 1806 | PREDICTED: Mya arenaria uncharacterized LOC128244994 (LOC128244994), partial mRNA | blastn | 118 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 16290798 | 16290798 | PRJEB2925_P_NODE_6453_length_512_cov_31.018868_g5322_i0 | PRJEB2925 | 6453 | 512 | 31.018868 | 158.81660416 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 75 | 1.07e-8 | NTclustered | gi|2693871861|ref|XR_010104559.1| | 6551 | g5322 | i0 | 100 | 9.236328125 | 40 | 0 | 8 | 0 | 473 | 512 | 3317 | 3278 | PREDICTED: Mytilus trossulus large subunit ribosomal RNA (LOC134702777), rRNA | blastn | 4729 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 22978162 | 22978162 | PRJEB2925_P_NODE_8759_length_410_cov_1.485333_g7503_i0 | PRJEB2925 | 8759 | 410 | 1.485333 | 6.0898653 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 66.6 | 9.58e-10 | NR | CAG5115437.1 | 100452 | g7503 | i0 | 77.8 | 2.51707317073171 | 36 | 8 | 26.3 | 0 | 327 | 220 | 367 | 402 | CAG5115437.1 unnamed protein product [Candidula unifasciata] | diamond | 1032 | 66.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 26646620 | 26646620 | PRJEB2925_P_NODE_13641_length_281_cov_1.585366_g12363_i0 | PRJEB2925 | 13641 | 281 | 1.585366 | 4.45487846 | Haliotis | 6452 | Mollusca | Mollusca | 90.9 | 2.54e-19 | NR | XP_048242137.1 | 6454 | g12363 | i0 | 46.2 | 4.9644128113879 | 93 | 50 | 99.3 | 0 | 1 | 279 | 43 | 135 | XP_048242137.1 procathepsin L-like [Haliotis rufescens] | diamond | 1395 | 91.7 | 0.991275899672846 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 27033196 | 27033196 | PRJEB2925_P_NODE_14782_length_264_cov_2.026201_g13504_i0 | PRJEB2925 | 14782 | 264 | 2.026201 | 5.34917064 | Patella caerulea | 87958 | Mollusca | Mollusca | 48.9 | 2.33e-4 | NR | KAK6171456.1 | 87958 | g13504 | i0 | 61.8 | 1.02272727272727 | 34 | 12 | 37.5 | 1 | 157 | 59 | 121 | 154 | KAK6171456.1 hypothetical protein SNE40_019642 [Patella caerulea] | diamond | 270 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 28517674 | 28517674 | PRJEB2925_P_NODE_12327_length_306_cov_1.335793_g11051_i0 | PRJEB2925 | 12327 | 306 | 1.335793 | 4.08752658 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 75.1 | 3.11e-14 | NR | XP_045193494.1 | 6596 | g11051 | i0 | 41 | 0.980392156862745 | 100 | 54 | 98 | 3 | 300 | 1 | 60 | 154 | XP_045193494.1 apolipoprotein D-like [Mercenaria mercenaria] | diamond | 300 | 75.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29048004 | 29048004 | PRJEB2925_P_NODE_9888_length_370_cov_2.134328_g8616_i0 | PRJEB2925 | 9888 | 370 | 2.134328 | 7.8970136 | Metazoa | 33208 | Mollusca | Mollusca | 85.9 | 4.52e-18 | NR | XP_011452281.3 | 29159 | g8616 | i0 | 52.5 | 2.43243243243243 | 101 | 28 | 65.7 | 2 | 4 | 246 | 86 | 186 | XP_011452281.3 translocon-associated protein subunit gamma [Magallana gigas] | diamond | 900 | 86.3 | 0.995365005793743 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 30785014 | 30785014 | PRJEB2925_P_NODE_13514_length_283_cov_2.169355_g12236_i0 | PRJEB2925 | 13514 | 283 | 2.169355 | 6.13927465 | Metazoa | 33208 | Mollusca | Mollusca | 65.1 | 1.67e-10 | NR | KAK3594341.1 | 2493646 | g12236 | i0 | 74.4 | 2.69257950530035 | 43 | 11 | 45.6 | 0 | 129 | 1 | 33 | 75 | KAK3594341.1 hypothetical protein CHS0354_026218 [Potamilus streckersoni] | diamond | 762 | 65.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 31986418 | 31986418 | PRJEB2925_P_NODE_16638_length_238_cov_2.054187_g15360_i0 | PRJEB2925 | 16638 | 238 | 2.054187 | 4.88896506 | Metazoa | 33208 | Mollusca | Mollusca | 62.4 | 3.57e-9 | NR | XP_060582686.1 | 129788 | g15360 | i0 | 37.4 | 9.30252100840336 | 91 | 29 | 79.4 | 1 | 193 | 5 | 6 | 96 | XP_060582686.1 procathepsin L-like [Ruditapes philippinarum] | diamond | 2214 | 62.8 | 0.993630573248408 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum |
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);;