contig_metadata
18 rows where bioproject = "PRJNA1247234", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1051790 | 1051790 | PRJNA1247234_P_NODE_8661_length_362_cov_1.629758_g8505_i0 | PRJNA1247234 | 8661 | 362 | 1.629758 | 5.89972396 | Mytilus | 6548 | Mollusca | Mollusca | 669 | 0 | NTclustered | gi|363710224|gb|HM180711.1| | 29158 | g8505 | i0 | 100 | 100 | 362 | 0 | 100 | 0 | 1 | 362 | 509 | 148 | Mytilus galloprovincialis voucher NSMK:MS-000656 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 36200 | 669 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus galloprovincialis | |
| 2902482 | 2902482 | PRJNA1247234_P_NODE_643_length_1075_cov_4.208583_g564_i0 | PRJNA1247234 | 643 | 1075 | 4.208583 | 45.24226725 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 1975 | 0 | NTclustered | gi|2633555496|gb|OR453540.1| | 42192 | g564 | i0 | 99.814 | 79.446511627907 | 1075 | 2 | 100 | 0 | 1 | 1075 | 16484 | 15410 | Mytilus coruscus isolate Kart1 mitochondrion, complete genome | blastn | 85405 | 1975 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 5454912 | 5454912 | PRJNA1247234_P_NODE_23625_length_248_cov_0.891429_g23469_i0 | PRJNA1247234 | 23625 | 248 | 0.891429 | 2.21074392 | Mytilus californianus | 6549 | Mollusca | Mollusca | 436 | 5.3e-118 | NTclustered | gi|2334653642|ref|XM_052230953.1| | 6549 | g23469 | i0 | 98.387 | 4.85483870967742 | 248 | 4 | 100 | 0 | 1 | 248 | 454 | 207 | PREDICTED: Mytilus californianus 60S ribosomal protein L24-like (LOC127724092), mRNA | blastn | 1204 | 436 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 5454991 | 5454991 | PRJNA1247234_P_NODE_27465_length_242_cov_1.349112_g27309_i0 | PRJNA1247234 | 27465 | 242 | 1.349112 | 3.26485104 | Mytilus californianus | 6549 | Mollusca | Mollusca | 422 | 1.44e-113 | NTclustered | gi|2334647355|ref|XM_052229385.1| | 6549 | g27309 | i0 | 98.333 | 11.0413223140496 | 240 | 4 | 99 | 0 | 3 | 242 | 57 | 296 | PREDICTED: Mytilus californianus 60S ribosomal protein L30-like (LOC127722983), mRNA | blastn | 2672 | 422 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 10555548 | 10555548 | PRJNA1247234_P_NODE_22629_length_249_cov_2.659091_g22473_i0 | PRJNA1247234 | 22629 | 249 | 2.659091 | 6.62113659 | Mytilus californianus | 6549 | Mollusca | Mollusca | 381 | 2.5299999999999995e-101 | NTclustered | gi|2334660749|ref|XM_052232704.1| | 6549 | g22473 | i0 | 96.137 | 7.55823293172691 | 233 | 9 | 94 | 0 | 1 | 233 | 377 | 145 | PREDICTED: Mytilus californianus soma ferritin-like (LOC127725615), mRNA | blastn | 1882 | 381 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 10555621 | 10555621 | PRJNA1247234_P_NODE_26449_length_244_cov_0.912281_g26293_i0 | PRJNA1247234 | 26449 | 244 | 0.912281 | 2.22596564 | Argopecten irradians | 31199 | Mollusca | Mollusca | 446 | 8.639999999999999e-121 | NTclustered | gi|2835337178|ref|XM_069282367.1| | 31199 | g26293 | i0 | 99.59 | 7.04508196721311 | 244 | 1 | 100 | 0 | 1 | 244 | 350 | 107 | PREDICTED: Argopecten irradians small ribosomal subunit protein eS6-like (LOC138333785), mRNA | blastn | 1719 | 446 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 14380610 | 14380610 | PRJNA1247234_P_NODE_22992_length_249_cov_0.886364_g22836_i0 | PRJNA1247234 | 22992 | 249 | 0.886364 | 2.20704636 | Mytilus californianus | 6549 | Mollusca | Mollusca | 385 | 1.96e-102 | NTclustered | gi|2334778183|ref|XM_052213183.1| | 6549 | g22836 | i0 | 97.345 | 0.907630522088353 | 226 | 6 | 91 | 0 | 24 | 249 | 565 | 340 | PREDICTED: Mytilus californianus zinc finger protein 235-like (LOC127708330), mRNA | blastn | 226 | 385 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 15654545 | 15654545 | PRJNA1247234_P_NODE_26513_length_244_cov_0.912281_g26357_i0 | PRJNA1247234 | 26513 | 244 | 0.912281 | 2.22596564 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 440 | 4.019999999999999e-119 | NTclustered | gi|2633555496|gb|OR453540.1| | 42192 | g26357 | i0 | 99.18 | 64.4344262295082 | 244 | 2 | 100 | 0 | 1 | 244 | 13960 | 14203 | Mytilus coruscus isolate Kart1 mitochondrion, complete genome | blastn | 15722 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 23303782 | 23303782 | PRJNA1247234_P_NODE_20499_length_253_cov_0.866667_g20343_i0 | PRJNA1247234 | 20499 | 253 | 0.866667 | 2.19266751 | Mytilus californianus | 6549 | Mollusca | Mollusca | 446 | 9.01e-121 | NTclustered | gi|2334664699|ref|XM_052233622.1| | 6549 | g20343 | i0 | 98.419 | 4.11857707509881 | 253 | 4 | 100 | 0 | 1 | 253 | 1223 | 971 | PREDICTED: Mytilus californianus sequestosome-1-like (LOC127726304), mRNA | blastn | 1042 | 446 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 27122978 | 27122978 | PRJNA1247234_P_NODE_25562_length_245_cov_0.906977_g25406_i0 | PRJNA1247234 | 25562 | 245 | 0.906977 | 2.22209365 | Metazoa | 33208 | Mollusca | Mollusca | 90.9 | 4.4e-19 | NR | XP_005107775.1 | 6500 | g25406 | i0 | 100 | 159.183673469388 | 40 | 0 | 49 | 0 | 3 | 122 | 473 | 512 | XP_005107775.1 membrane-bound transcription factor site-1 protease [Aplysia californica] | diamond | 39000 | 90.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 27786808 | 27786808 | PRJNA1247234_P_NODE_21984_length_250_cov_1.762712_g21828_i0 | PRJNA1247234 | 21984 | 250 | 1.762712 | 4.40678 | Metazoa | 33208 | Mollusca | Mollusca | 94 | 3.73e-20 | NR | XP_060606781.1 | 129788 | g21828 | i0 | 51.2 | 8.748 | 84 | 39 | 98.4 | 1 | 3 | 248 | 267 | 350 | XP_060606781.1 uncharacterized protein LOC132759074 [Ruditapes philippinarum] | diamond | 2187 | 94.7 | 0.992608236536431 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Ruditapes | Ruditapes philippinarum | |
| 28526512 | 28526512 | PRJNA1247234_P_NODE_14267_length_296_cov_1.399103_g14111_i0 | PRJNA1247234 | 14267 | 296 | 1.399103 | 4.14134488 | Sinanodonta woodiana | 1069815 | Mollusca | Mollusca | 51.2 | 7.02e-5 | NR | KAL3891136.1 | 1069815 | g14111 | i0 | 61.3 | 1.86486486486486 | 31 | 12 | 31.4 | 0 | 295 | 203 | 6 | 36 | KAL3891136.1 hypothetical protein ACJMK2_003399 [Sinanodonta woodiana] | diamond | 552 | 51.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Unionida | Unionidae | Sinanodonta | Sinanodonta woodiana | |
| 29144641 | 29144641 | PRJNA1247234_P_NODE_25929_length_245_cov_0.906977_g25773_i0 | PRJNA1247234 | 25929 | 245 | 0.906977 | 2.22209365 | Opisthokonta | 33154 | Mollusca | Mollusca | 107 | 2.29e-26 | NR | XP_052089784.1 | 6549 | g25773 | i0 | 73.8 | 10.3469387755102 | 65 | 17 | 79.6 | 0 | 245 | 51 | 114 | 178 | XP_052089784.1 diphthine methyl ester synthase-like [Mytilus californianus] | diamond | 2535 | 108 | 0.990740740740741 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 29680738 | 29680738 | PRJNA1247234_P_NODE_7430_length_384_cov_3.508039_g7274_i0 | PRJNA1247234 | 7430 | 384 | 3.508039 | 13.47086976 | Metazoa | 33208 | Mollusca | Mollusca | 84.3 | 2.94e-17 | NR | XP_052231030.1 | 45954 | g7274 | i0 | 38.9 | 7.9453125 | 126 | 74 | 98.4 | 2 | 383 | 6 | 33 | 155 | XP_052231030.1 probable glutathione S-transferase 7 [Dreissena polymorpha] | diamond | 3051 | 84.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 29915791 | 29915791 | PRJNA1247234_P_NODE_5131_length_448_cov_1.114667_g4977_i0 | PRJNA1247234 | 5131 | 448 | 1.114667 | 4.99370816 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 105 | 3.11e-23 | NR | XP_061176776.1 | 191078 | g4977 | i0 | 55.2 | 2.16294642857143 | 105 | 46 | 70.3 | 1 | 1 | 315 | 312 | 415 | XP_061176776.1 circularly permutated Ras protein 1-like [Saccostrea echinata] | diamond | 969 | 105 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 31084673 | 31084673 | PRJNA1247234_P_NODE_21995_length_250_cov_1.762712_g21839_i0 | PRJNA1247234 | 21995 | 250 | 1.762712 | 4.40678 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 50.4 | 1.75e-5 | NR | KAH3897447.1 | 45954 | g21839 | i0 | 66.7 | 3.072 | 30 | 10 | 36 | 0 | 250 | 161 | 1 | 30 | KAH3897447.1 hypothetical protein DPMN_021635 [Dreissena polymorpha] | diamond | 768 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 31514048 | 31514048 | PRJNA1247234_P_NODE_20596_length_253_cov_0.866667_g20440_i0 | PRJNA1247234 | 20596 | 253 | 0.866667 | 2.19266751 | Metazoa | 33208 | Mollusca | Mollusca | 52 | 2.15e-5 | NR | XP_052765316.1 | 6604 | g20440 | i0 | 65.5 | 19.5652173913043 | 29 | 10 | 34.4 | 0 | 3 | 89 | 326 | 354 | XP_052765316.1 zinc finger protein 768-like isoform X39 [Mya arenaria] | diamond | 4950 | 52.4 | 0.99236641221374 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 32760240 | 32760240 | PRJNA1247234_P_NODE_8640_length_363_cov_1.044828_g8484_i0 | PRJNA1247234 | 8640 | 363 | 1.044828 | 3.79272564 | Mactra antiquata | 2302425 | Mollusca | Mollusca | 73.2 | 1.47e-13 | NR | KAL4222489.1 | 2302425 | g8484 | i0 | 34 | 1.70247933884298 | 100 | 65 | 82.6 | 1 | 54 | 353 | 15 | 113 | KAL4222489.1 Phosphatidylglycerol/phosphatidylinositol transfer protein [Mactra antiquata] | diamond | 618 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Mactridae | Mactra | Mactra antiquata |
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);;