contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1247234" 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 |
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);;