contig_metadata
20 rows where analysis = "diamond", bioproject = "PRJNA781453" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6316241 | 6316241 | PRJNA781453_P_NODE_33845_length_249_cov_0.875000_g33730_i0 | PRJNA781453 | 33845 | 249 | 0.875 | 2.17875 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 72.8 | 9.97e-13 | NR | CAC5367434.1 | 42192 | g33730 | i0 | 59.4 | 6.16867469879518 | 64 | 26 | 77.1 | 0 | 28 | 219 | 94 | 157 | CAC5367434.1 LATS1_2 [Mytilus coruscus] | diamond | 1536 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 26673404 | 26673404 | PRJNA781453_P_NODE_38681_length_243_cov_0.905882_g38566_i0 | PRJNA781453 | 38681 | 243 | 0.905882 | 2.20129326 | Argopecten irradians | 31199 | Mollusca | Mollusca | 123 | 1.9499999999999999e-31 | NR | XP_069136762.1 | 31199 | g38566 | i0 | 82.5 | 6.90123456790123 | 80 | 10 | 98.8 | 2 | 3 | 242 | 257 | 332 | XP_069136762.1 uncharacterized protein [Argopecten irradians] | diamond | 1677 | 123 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 26736654 | 26736654 | PRJNA781453_P_NODE_22481_length_308_cov_1.034043_g22366_i0 | PRJNA781453 | 22481 | 308 | 1.034043 | 3.18485244 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 118 | 5.76e-31 | NR | XP_060077662.1 | 509963 | g22366 | i0 | 75.3 | 0.788961038961039 | 81 | 18 | 76.9 | 1 | 307 | 71 | 111 | 191 | XP_060077662.1 uncharacterized protein LOC132557182 [Ylistrum balloti] | diamond | 243 | 118 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 27031231 | 27031231 | PRJNA781453_P_NODE_37362_length_245_cov_0.895349_g37247_i0 | PRJNA781453 | 37362 | 245 | 0.895349 | 2.19360505 | Pectinidae | 6566 | Mollusca | Mollusca | 60.8 | 1.46e-8 | NR | XP_021359385.1 | 6573 | g37247 | i0 | 81.3 | 0.783673469387755 | 32 | 6 | 39.2 | 0 | 245 | 150 | 241 | 272 | XP_021359385.1 uncharacterized protein LOC110454281 [Mizuhopecten yessoensis] | diamond | 192 | 60.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 27157376 | 27157376 | PRJNA781453_P_NODE_37962_length_244_cov_0.900585_g37847_i0 | PRJNA781453 | 37962 | 244 | 0.900585 | 2.1974274 | Pectinidae | 6566 | Mollusca | Mollusca | 47.4 | 9.09e-4 | NR | XP_033747101.1 | 6579 | g37847 | i0 | 38.6 | 2.04098360655738 | 83 | 41 | 89.8 | 3 | 237 | 19 | 816 | 898 | XP_033747101.1 uncharacterized protein LOC117332324 [Pecten maximus] | diamond | 498 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 27252487 | 27252487 | PRJNA781453_P_NODE_34903_length_248_cov_0.880000_g34788_i0 | PRJNA781453 | 34903 | 248 | 0.88 | 2.1824 | Pectinidae | 6566 | Mollusca | Mollusca | 69.7 | 1.23e-11 | NR | XP_021358614.1 | 6573 | g34788 | i0 | 100 | 0.774193548387097 | 32 | 0 | 38.7 | 0 | 247 | 152 | 443 | 474 | XP_021358614.1 delta and Notch-like epidermal growth factor-related receptor [Mizuhopecten yessoensis] | diamond | 192 | 69.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 27527499 | 27527499 | PRJNA781453_P_NODE_4503_length_704_cov_2.087163_g4400_i0 | PRJNA781453 | 4503 | 704 | 2.087163 | 14.69362752 | Elysia marginata | 1093978 | Mollusca | Mollusca | 192 | 2.2e-52 | NR | GFS26848.1 | 1093978 | g4400 | i0 | 47.2 | 1.79403409090909 | 212 | 109 | 89.1 | 2 | 681 | 55 | 490 | 701 | GFS26848.1 hypothetical protein ElyMa_007067800 [Elysia marginata] | diamond | 1263 | 192 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia marginata | ||
| 27811921 | 27811921 | PRJNA781453_P_NODE_36824_length_246_cov_0.872832_g36709_i0 | PRJNA781453 | 36824 | 246 | 0.872832 | 2.14716672 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 68.6 | 6.07e-12 | NR | CAC5402417.1 | 42192 | g36709 | i0 | 67.4 | 0.560975609756098 | 46 | 15 | 56.1 | 0 | 203 | 66 | 64 | 109 | CAC5402417.1 unnamed protein product [Mytilus coruscus] | diamond | 138 | 68.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 28673594 | 28673594 | PRJNA781453_P_NODE_1127_length_1255_cov_3.161591_g1079_i0 | PRJNA781453 | 1127 | 1255 | 3.161591 | 39.67796705 | Metazoa | 33208 | Mollusca | Mollusca | 230 | 7.43e-63 | NR | CAG2196940.1 | 6550 | g1079 | i0 | 47.3 | 10.9721115537849 | 239 | 126 | 57.1 | 0 | 45 | 761 | 397 | 635 | CAG2196940.1 unnamed protein product [Mytilus edulis] | diamond | 13770 | 232 | 0.991379310344828 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 29011879 | 29011879 | PRJNA781453_P_NODE_37268_length_245_cov_0.895349_g37153_i0 | PRJNA781453 | 37268 | 245 | 0.895349 | 2.19360505 | Argopecten irradians | 31199 | Mollusca | Mollusca | 50.8 | 5.19e-5 | NR | XP_069128910.1 | 31199 | g37153 | i0 | 50 | 0.587755102040816 | 48 | 23 | 58.8 | 1 | 242 | 99 | 193 | 239 | XP_069128910.1 secretory phospholipase A2 receptor-like [Argopecten irradians] | diamond | 144 | 50.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 29453227 | 29453227 | PRJNA781453_P_NODE_39110_length_243_cov_0.905882_g38995_i0 | PRJNA781453 | 39110 | 243 | 0.905882 | 2.20129326 | Magallana gigas | 29159 | Mollusca | Mollusca | 57.4 | 2.45e-7 | NR | XP_065927709.1 | 29159 | g38995 | i0 | 58.5 | 0.506172839506173 | 41 | 17 | 50.6 | 0 | 78 | 200 | 290 | 330 | XP_065927709.1 uncharacterized protein [Magallana gigas] | diamond | 123 | 57.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 29588853 | 29588853 | PRJNA781453_P_NODE_32530_length_251_cov_0.865169_g32415_i0 | PRJNA781453 | 32530 | 251 | 0.865169 | 2.17157419 | Pectinidae | 6566 | Mollusca | Mollusca | 90.5 | 6.4e-19 | NR | XP_021354091.1 | 6573 | g32415 | i0 | 79.3 | 7.02788844621514 | 58 | 12 | 69.3 | 0 | 56 | 229 | 198 | 255 | XP_021354091.1 uncharacterized protein LOC110450736 [Mizuhopecten yessoensis] | diamond | 1764 | 90.9 | 0.995599559955996 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 29810071 | 29810071 | PRJNA781453_P_NODE_39311_length_243_cov_0.876471_g39196_i0 | PRJNA781453 | 39311 | 243 | 0.876471 | 2.12982453 | Bivalvia | 6544 | Mollusca | Mollusca | 72.8 | 9.67e-13 | NR | CAG2187579.1 | 6550 | g39196 | i0 | 62.2 | 1.38271604938272 | 45 | 17 | 55.6 | 0 | 90 | 224 | 100 | 144 | CAG2187579.1 DDC [Mytilus edulis] | diamond | 336 | 72.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 29832443 | 29832443 | PRJNA781453_P_NODE_40151_length_242_cov_0.863905_g40036_i0 | PRJNA781453 | 40151 | 242 | 0.863905 | 2.0906501 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 124 | 3.8999999999999997e-31 | NR | OWF40643.1 | 6573 | g40036 | i0 | 74.7 | 0.979338842975207 | 79 | 20 | 97.9 | 0 | 6 | 242 | 315 | 393 | OWF40643.1 ribosomal protein S6 kinase alpha-1 [Mizuhopecten yessoensis] | diamond | 237 | 124 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 30053445 | 30053445 | PRJNA781453_P_NODE_28591_length_269_cov_1.566327_g28476_i0 | PRJNA781453 | 28591 | 269 | 1.566327 | 4.21341963 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 61.6 | 1.86e-9 | NR | CAC5406882.1 | 42192 | g28476 | i0 | 44.9 | 0.992565055762082 | 89 | 40 | 99.3 | 2 | 267 | 1 | 43 | 122 | CAC5406882.1 unnamed protein product [Mytilus coruscus] | diamond | 267 | 61.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 30189248 | 30189248 | PRJNA781453_P_NODE_34092_length_249_cov_0.875000_g33977_i0 | PRJNA781453 | 34092 | 249 | 0.875 | 2.17875 | Littorinimorpha | 216294 | Mollusca | Mollusca | 49.3 | 1.88e-4 | NR | KAK7093763.1 | 31220 | g33977 | i0 | 43.7 | 19.7831325301205 | 71 | 35 | 85.5 | 3 | 215 | 3 | 222 | 287 | KAK7093763.1 hypothetical protein V1264_007457 [Littorina saxatilis] | diamond | 4926 | 49.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 31791771 | 31791771 | PRJNA781453_P_NODE_36817_length_246_cov_0.878613_g36702_i0 | PRJNA781453 | 36817 | 246 | 0.878613 | 2.16138798 | Mytilus californianus | 6549 | Mollusca | Mollusca | 99.8 | 3.47e-22 | NR | XP_052071786.1 | 6549 | g36702 | i0 | 73.2 | 0.682926829268293 | 56 | 15 | 68.3 | 0 | 244 | 77 | 3078 | 3133 | XP_052071786.1 uncharacterized protein LOC127710082 [Mytilus californianus] | diamond | 168 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 32276140 | 32276140 | PRJNA781453_P_NODE_34978_length_248_cov_0.880000_g34863_i0 | PRJNA781453 | 34978 | 248 | 0.88 | 2.1824 | Mytilus | 6548 | Mollusca | Mollusca | 143 | 1.4399999999999998e-37 | NR | CAG2255494.1 | 6550 | g34863 | i0 | 92.8 | 2.00806451612903 | 83 | 5 | 99.2 | 1 | 248 | 3 | 419 | 501 | CAG2255494.1 unnamed protein product [Mytilus edulis] | diamond | 498 | 143 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 32686494 | 32686494 | PRJNA781453_P_NODE_30680_length_258_cov_1.140541_g30565_i0 | PRJNA781453 | 30680 | 258 | 1.140541 | 2.94259578 | root | 1 | Root_unresolved | Root_unresolved | 100 | 9.84e-23 | NR | KAK3600388.1 | 2493646 | g30565 | i0 | 53.8 | 1.74418604651163 | 78 | 36 | 90.7 | 0 | 258 | 25 | 238 | 315 | KAK3600388.1 hypothetical protein CHS0354_016004 [Potamilus streckersoni] | diamond | 450 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Potamilus | Potamilus streckersoni | |
| 32771696 | 32771696 | PRJNA781453_P_NODE_34140_length_249_cov_0.875000_g34025_i0 | PRJNA781453 | 34140 | 249 | 0.875 | 2.17875 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 74.3 | 7.92e-15 | NR | OWF47905.1 | 6573 | g34025 | i0 | 48.3 | 1.4578313253012 | 58 | 30 | 69.9 | 0 | 5 | 178 | 55 | 112 | OWF47905.1 deoxyribonuclease TATDN2 [Mizuhopecten yessoensis] | diamond | 363 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis |
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);;