contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA638138" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1885725 | 1885725 | PRJNA638138_P_NODE_6542_length_389_cov_4.310127_g6327_i0 | PRJNA638138 | 6542 | 389 | 4.310127 | 16.76639403 | Mytilus edulis | 6550 | Mollusca | Mollusca | 222 | 2.68e-53 | NTclustered | gi|2912330725|ref|XM_071278780.1| | 6550 | g6327 | i0 | 81.887 | 13.6298200514139 | 265 | 46 | 68 | 2 | 5 | 268 | 879 | 616 | PREDICTED: Mytilus edulis soma ferritin-like (LOC139491251), mRNA | blastn | 5302 | 222 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 4437209 | 4437209 | PRJNA638138_P_NODE_33584_length_242_cov_0.911243_g33369_i0 | PRJNA638138 | 33584 | 242 | 0.911243 | 2.20520806 | Atrina pectinata | 49198 | Mollusca | Mollusca | 442 | 1.1099999999999995e-119 | NTclustered | gi|2337352613|gb|ON193523.1| | 49198 | g33369 | i0 | 99.587 | 2 | 242 | 1 | 100 | 0 | 1 | 242 | 7297 | 7056 | Atrina pectinata mitochondrion, complete genome | blastn | 484 | 442 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pinnidae | Atrina | Atrina pectinata | |
| 8262535 | 8262535 | PRJNA638138_P_NODE_17147_length_265_cov_1.604167_g16932_i0 | PRJNA638138 | 17147 | 265 | 1.604167 | 4.25104255 | Lottia gigantea | 225164 | Mollusca | Mollusca | 132 | 3.02e-26 | NTclustered | gi|676469251|ref|XM_009060224.1| | 225164 | g16932 | i0 | 83.571 | 3.86037735849057 | 140 | 23 | 53 | 0 | 125 | 264 | 317 | 178 | Lottia gigantea hypothetical protein mRNA | blastn | 1023 | 132 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 14638272 | 14638272 | PRJNA638138_P_NODE_22552_length_249_cov_0.875000_g22337_i0 | PRJNA638138 | 22552 | 249 | 0.875 | 2.17875 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 292 | 1.2199999999999999e-74 | NTclustered | gi|2628410228|ref|XM_061316054.1| | 191078 | g22337 | i0 | 88.75 | 48.3734939759036 | 240 | 25 | 96 | 2 | 5 | 243 | 966 | 728 | PREDICTED: Saccostrea echinata tropomyosin (LOC133181565), transcript variant X1, mRNA | blastn | 12045 | 292 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata | |
| 14638364 | 14638364 | PRJNA638138_P_NODE_31212_length_244_cov_0.900585_g30997_i0 | PRJNA638138 | 31212 | 244 | 0.900585 | 2.1974274 | Atrina pectinata | 49198 | Mollusca | Mollusca | 440 | 4.019999999999999e-119 | NTclustered | gi|435856621|ref|NC_020028.1| | 49198 | g30997 | i0 | 99.18 | 2 | 244 | 2 | 100 | 0 | 1 | 244 | 15416 | 15173 | Atrina pectinata mitochondrion, complete genome | blastn | 488 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pinnidae | Atrina | Atrina pectinata | |
| 18461390 | 18461390 | PRJNA638138_P_NODE_17715_length_261_cov_1.515957_g17500_i0 | PRJNA638138 | 17715 | 261 | 1.515957 | 3.95664777 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 187 | 6.2499999999999984e-43 | NTclustered | gi|1242739027|ref|XM_022468134.1| | 6565 | g17500 | i0 | 81.498 | 17.3984674329502 | 227 | 42 | 87 | 0 | 33 | 259 | 322 | 96 | PREDICTED: Crassostrea virginica 60S ribosomal protein L19-like (LOC111124874), mRNA | blastn | 4541 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 19006693 | 19006693 | PRJNA638138_P_NODE_12815_length_301_cov_1.346491_g12600_i0 | PRJNA638138 | 12815 | 301 | 1.346491 | 4.05293791 | Metazoa | 33208 | Mollusca | Mollusca | 514 | 2.97e-141 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g12600 | i0 | 99.644 | 93.3554817275748 | 281 | 1 | 93 | 0 | 1 | 281 | 214 | 494 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 28100 | 514 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 22286604 | 22286604 | PRJNA638138_P_NODE_35898_length_241_cov_0.916667_g35683_i0 | PRJNA638138 | 35898 | 241 | 0.916667 | 2.20916747 | Atrina pectinata | 49198 | Mollusca | Mollusca | 440 | 3.959999999999999e-119 | NTclustered | gi|2337352613|gb|ON193523.1| | 49198 | g35683 | i0 | 100 | 1.97510373443983 | 238 | 0 | 99 | 0 | 4 | 241 | 2336 | 2099 | Atrina pectinata mitochondrion, complete genome | blastn | 476 | 440 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pinnidae | Atrina | Atrina pectinata | |
| 22286631 | 22286631 | PRJNA638138_P_NODE_5758_length_412_cov_1.303835_g5543_i0 | PRJNA638138 | 5758 | 412 | 1.303835 | 5.3718002 | Pinctada imbricata | 66713 | Mollusca | Mollusca | 359 | 2.08e-94 | NTclustered | gi|321375245|gb|HQ629952.1| | 66713 | g5543 | i0 | 82.555 | 6.16747572815534 | 407 | 71 | 99 | 0 | 6 | 412 | 562 | 156 | Pinctada martensi activated C kinase 1 receptor (RACK1) mRNA, complete cds | blastn | 2541 | 359 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pterioida | Pteriidae | Pinctada | Pinctada imbricata | |
| 23561859 | 23561859 | PRJNA638138_P_NODE_11199_length_318_cov_0.853061_g10984_i0 | PRJNA638138 | 11199 | 318 | 0.853061 | 2.71273398 | Ruditapes philippinarum | 129788 | Mollusca | Mollusca | 267 | 9.78e-67 | NTclustered | gi|2616655350|ref|XM_060745695.1| | 129788 | g10984 | i0 | 81.962 | 26.5786163522013 | 316 | 56 | 99 | 1 | 3 | 318 | 552 | 238 | PREDICTED: Ruditapes philippinarum ubiquitin-ribosomal protein eS31 fusion protein (LOC132754941), transcript variant X2, mRNA | blastn | 8452 | 267 | 1 | 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);;