contig_metadata
11 rows where analysis = "diamond", bioproject = "PRJNA664479" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26682017 | 26682017 | PRJNA664479_S_NODE_8241_length_200_cov_1.185430_g8165_i0 | PRJNA664479 | 8241 | 200 | 1.18543 | 2.37086 | Metazoa | 33208 | Mollusca | Mollusca | 43.9 | 0.00759 | NR | XP_046350582.1 | 6454 | g8165 | i0 | 48.8 | 1.845 | 41 | 21 | 61.5 | 0 | 64 | 186 | 89 | 129 | XP_046350582.1 40S ribosomal protein S6-like [Haliotis rufescens] | diamond | 369 | 44.3 | 0.99097065462754 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens | |
| 26828457 | 26828457 | PRJNA664479_S_NODE_4621_length_244_cov_7.912821_g4545_i0 | PRJNA664479 | 4621 | 244 | 7.912821 | 19.30728324 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.9 | 0.0143 | NR | XP_067657806.1 | 109174 | g4545 | i0 | 35.4 | 1.57377049180328 | 65 | 36 | 78.7 | 2 | 240 | 49 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 384 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 26872469 | 26872469 | PRJNA664479_S_NODE_1041_length_462_cov_12.343826_g965_i0 | PRJNA664479 | 1041 | 462 | 12.343826 | 57.02847612 | Metazoa | 33208 | Mollusca | Mollusca | 89 | 2.76e-17 | NR | XP_052274037.1 | 45954 | g965 | i0 | 45.7 | 47.1948051948052 | 129 | 70 | 83.8 | 0 | 1 | 387 | 406 | 534 | XP_052274037.1 actin-3-like [Dreissena polymorpha] | diamond | 21804 | 89 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 26966978 | 26966978 | PRJNA664479_S_NODE_3222_length_283_cov_0.803419_g3146_i0 | PRJNA664479 | 3222 | 283 | 0.803419 | 2.27367577 | Metazoa | 33208 | Mollusca | Mollusca | 86.3 | 5.9e-18 | NR | CAG2210013.1 | 6550 | g3146 | i0 | 63.9 | 600.137809187279 | 72 | 26 | 76.3 | 0 | 218 | 3 | 123 | 194 | CAG2210013.1 EGD2 [Mytilus edulis] | diamond | 169839 | 86.7 | 0.995386389850058 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 27271102 | 27271102 | PRJNA664479_S_NODE_3363_length_278_cov_1.157205_g3287_i0 | PRJNA664479 | 3363 | 278 | 1.157205 | 3.2170299 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 66.2 | 2.2e-10 | NR | XP_041378569.1 | 1735272 | g3287 | i0 | 51.5 | 2.84892086330935 | 66 | 32 | 71.2 | 0 | 3 | 200 | 241 | 306 | XP_041378569.1 mitochondrial 2-oxoglutarate/malate carrier protein-like [Gigantopelta aegis] | diamond | 792 | 66.6 | 0.993993993993994 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 27472861 | 27472861 | PRJNA664479_S_NODE_15883_length_165_cov_0.879310_g15807_i0 | PRJNA664479 | 15883 | 165 | 0.87931 | 1.4508615 | Metazoa | 33208 | Mollusca | Mollusca | 80.9 | 8.83e-17 | NR | CAI9738230.1 | 6645 | g15807 | i0 | 74.1 | 89.3454545454545 | 54 | 14 | 98.2 | 0 | 165 | 4 | 125 | 178 | CAI9738230.1 receptor for activated C kinase 1 [Octopus vulgaris] | diamond | 14742 | 81.6 | 0.991421568627451 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 28356775 | 28356775 | PRJNA664479_S_NODE_12686_length_173_cov_5.177419_g12610_i0 | PRJNA664479 | 12686 | 173 | 5.177419 | 8.95693487 | Unionidae | 47526 | Mollusca | Mollusca | 73.9 | 9.66e-15 | NR | KAL3877291.1 | 1069815 | g12610 | i0 | 63.2 | 1.97687861271676 | 57 | 21 | 98.8 | 0 | 1 | 171 | 33 | 89 | KAL3877291.1 hypothetical protein ACJMK2_035022 [Sinanodonta woodiana] | diamond | 342 | 73.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 28944951 | 28944951 | PRJNA664479_S_NODE_5368_length_231_cov_4.598901_g5292_i0 | PRJNA664479 | 5368 | 231 | 4.598901 | 10.62346131 | Mytilus edulis | 6550 | Mollusca | Mollusca | 49.3 | 1.47e-4 | NR | CAG2187267.1 | 6550 | g5292 | i0 | 45.3 | 2.03896103896104 | 53 | 28 | 67.5 | 1 | 168 | 13 | 192 | 244 | CAG2187267.1 unnamed protein product [Mytilus edulis] | diamond | 471 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 29556553 | 29556553 | PRJNA664479_S_NODE_17570_length_163_cov_0.877193_g17494_i0 | PRJNA664479 | 17570 | 163 | 0.877193 | 1.42982459 | Metazoa | 33208 | Mollusca | Mollusca | 41.6 | 0.032 | NR | XP_022304940.1 | 6565 | g17494 | i0 | 63.6 | 43.1226993865031 | 33 | 12 | 60.7 | 0 | 57 | 155 | 511 | 543 | XP_022304940.1 splicing factor 3B subunit 1-like isoform X1 [Crassostrea virginica] | diamond | 7029 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 30504408 | 30504408 | PRJNA664479_S_NODE_16453_length_164_cov_0.886957_g16377_i0 | PRJNA664479 | 16453 | 164 | 0.886957 | 1.45460948 | Metazoa | 33208 | Mollusca | Mollusca | 63.5 | 3.08e-10 | NR | XP_050395572.1 | 6465 | g16377 | i0 | 66.7 | 64.2073170731707 | 45 | 15 | 82.3 | 0 | 26 | 160 | 6 | 50 | XP_050395572.1 proteasome subunit alpha type-7 [Patella vulgata] | diamond | 10530 | 63.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 30618502 | 30618502 | PRJNA664479_S_NODE_2293_length_327_cov_0.841727_g2217_i0 | PRJNA664479 | 2293 | 327 | 0.841727 | 2.75244729 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 46.2 | 0.00469 | NR | CAE1276163.1 | 158019 | g2217 | i0 | 33.3 | 1.64220183486239 | 84 | 56 | 77.1 | 0 | 271 | 20 | 4 | 87 | CAE1276163.1 PSMA7 [Acanthosepion pharaonis] | diamond | 537 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis |
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);;