contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA738523" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1995553 | 1995553 | PRJNA738523_P_NODE_11522_length_249_cov_1.539773_g11451_i0 | PRJNA738523 | 11522 | 249 | 1.539773 | 3.83403477 | Crassostrea virginica | 6565 | Mollusca | Mollusca | 139 | 1.68e-28 | NTclustered | gi|1242750027|ref|XM_022458054.1| | 6565 | g11451 | i0 | 79.412 | 3.68273092369478 | 204 | 36 | 81 | 6 | 29 | 229 | 456 | 656 | PREDICTED: Crassostrea virginica 40S ribosomal protein SA-like (LOC111118540), mRNA | blastn | 917 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica | |
| 3270867 | 3270867 | PRJNA738523_P_NODE_16103_length_241_cov_0.916667_g16032_i0 | PRJNA738523 | 16103 | 241 | 0.916667 | 2.20916747 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 1.3e-4 | NTclustered | gi|2912990805|dbj|AP039595.1| | 145626 | g16032 | i0 | 92.683 | 3.82157676348548 | 41 | 3 | 17 | 0 | 131 | 171 | 17184111 | 17184071 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 14, sequence | blastn | 921 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4548078 | 4548078 | PRJNA738523_P_NODE_8224_length_272_cov_1.180905_g8153_i0 | PRJNA738523 | 8224 | 272 | 1.180905 | 3.2120616 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 110 | 1.46e-19 | NTclustered | gi|1914655814|ref|XR_004998761.1| | 2607531 | g8153 | i0 | 92.208 | 30.3823529411765 | 77 | 6 | 28 | 0 | 196 | 272 | 2243 | 2319 | PREDICTED: Octopus sinensis uncharacterized LOC118763007 (LOC118763007), ncRNA | blastn | 8264 | 110 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 8372875 | 8372875 | PRJNA738523_P_NODE_8947_length_265_cov_1.338542_g8876_i0 | PRJNA738523 | 8947 | 265 | 1.338542 | 3.5471363 | Pecten maximus | 6579 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|1835506367|ref|XM_033900255.1| | 6579 | g8876 | i0 | 94.118 | 0.128301886792453 | 34 | 2 | 13 | 0 | 194 | 227 | 613 | 580 | PREDICTED: Pecten maximus uncharacterized LOC117338891 (LOC117338891), mRNA | blastn | 34 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 14748437 | 14748437 | PRJNA738523_P_NODE_11312_length_250_cov_0.870056_g11241_i0 | PRJNA738523 | 11312 | 250 | 0.870056 | 2.17514 | Patella caerulea | 87958 | Mollusca | Mollusca | 191 | 4.6e-44 | NTclustered | gi|669205831|gb|KF494231.1| | 87958 | g11241 | i0 | 80.894 | 92.84 | 246 | 43 | 98 | 4 | 7 | 250 | 397 | 154 | Patella caerulea beta-actin mRNA, partial cds | blastn | 23210 | 191 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella caerulea | ||
| 19846533 | 19846533 | PRJNA738523_P_NODE_6016_length_297_cov_1.031250_g5945_i0 | PRJNA738523 | 6016 | 297 | 1.03125 | 3.0628125 | Mytilus californianus | 6549 | Mollusca | Mollusca | 100 | 9.71e-17 | NTclustered | gi|2334779967|ref|XM_052213681.1| | 6549 | g5945 | i0 | 73.946 | 0.878787878787879 | 261 | 62 | 87 | 4 | 14 | 271 | 2948 | 3205 | PREDICTED: Mytilus californianus myosin heavy chain, striated muscle-like (LOC127708640), mRNA | blastn | 261 | 100 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 22396993 | 22396993 | PRJNA738523_P_NODE_2258_length_432_cov_1.696379_g2187_i0 | PRJNA738523 | 2258 | 432 | 1.696379 | 7.32835728 | Haliotis asinina | 109174 | Mollusca | Mollusca | 209 | 2.34e-49 | NTclustered | gi|2793421121|ref|XM_067823659.1| | 109174 | g2187 | i0 | 80.515 | 8.08101851851852 | 272 | 53 | 63 | 0 | 40 | 311 | 61 | 332 | PREDICTED: Haliotis asinina histone H2A-like (LOC137292118), mRNA | blastn | 3491 | 209 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 23672595 | 23672595 | PRJNA738523_P_NODE_7519_length_279_cov_1.121359_g7448_i0 | PRJNA738523 | 7519 | 279 | 1.121359 | 3.12859161 | Mytilus californianus | 6549 | Mollusca | Mollusca | 209 | 1.44e-49 | NTclustered | gi|2334736617|ref|XM_052202326.1| | 6549 | g7448 | i0 | 80.216 | 13.921146953405 | 278 | 55 | 99 | 0 | 1 | 278 | 573 | 296 | PREDICTED: Mytilus californianus ras-related protein Rab-1A (LOC127698700), transcript variant X1, mRNA | blastn | 3884 | 209 | 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);;