contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA909412" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 890698 | 890698 | PRJNA909412_P_NODE_8301_length_184_cov_4.420690_g8160_i0 | PRJNA909412 | 8301 | 184 | 4.42069 | 8.1340696 | Lottia gigantea | 225164 | Mollusca | Mollusca | 52.8 | 0.016 | NTclustered | gi|676459712|ref|XM_009057142.1| | 225164 | g8160 | i0 | 100 | 0.152173913043478 | 28 | 0 | 15 | 0 | 110 | 137 | 1442 | 1469 | Lottia gigantea hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 4719240 | 4719240 | PRJNA909412_P_NODE_7104_length_198_cov_2.088050_g6963_i0 | PRJNA909412 | 7104 | 198 | 2.08805 | 4.134339 | Mya arenaria | 6604 | Mollusca | Mollusca | 73.1 | 1.32e-8 | NTclustered | gi|2427374800|ref|XM_052912934.1| | 6604 | g6963 | i0 | 80.198 | 0.51010101010101 | 101 | 16 | 50 | 3 | 100 | 198 | 1229 | 1131 | PREDICTED: Mya arenaria 26S proteasome regulatory subunit 10B (LOC128209087), mRNA | blastn | 101 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 11094313 | 11094313 | PRJNA909412_P_NODE_8989_length_178_cov_2.388489_g8848_i0 | PRJNA909412 | 8989 | 178 | 2.388489 | 4.25151042 | Aplysia californica | 6500 | Mollusca | Mollusca | 52.8 | 0.015 | NTclustered | gi|1897911960|ref|XR_004858657.1| | 6500 | g8848 | i0 | 96.875 | 0.179775280898876 | 32 | 0 | 18 | 1 | 16 | 47 | 139 | 169 | PREDICTED: Aplysia californica uncharacterized LOC118477858 (LOC118477858), ncRNA | blastn | 32 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Aplysiida | Aplysiidae | Aplysia | Aplysia californica | |
| 16193480 | 16193480 | PRJNA909412_P_NODE_3313_length_289_cov_1.584000_g3172_i0 | PRJNA909412 | 3313 | 289 | 1.584 | 4.57776 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 52.8 | 0.027 | NTclustered | gi|2364551139|ref|XM_052377903.1| | 45954 | g3172 | i0 | 100 | 0.0968858131487889 | 28 | 0 | 10 | 0 | 203 | 230 | 6312 | 6339 | PREDICTED: Dreissena polymorpha alpha-protein kinase vwkA-like (LOC127846549), mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 18742221 | 18742221 | PRJNA909412_P_NODE_3095_length_299_cov_15.069231_g2955_i0 | PRJNA909412 | 3095 | 299 | 15.069231 | 45.05700069 | Ctena cf. galapagana NHMUK 20210086 | 2892552 | Mollusca | Mollusca | 134 | 9.65e-27 | NTclustered | gi|2129023951|gb|OL361786.1| | 2892552 | g2955 | i0 | 90.909 | 7.54849498327759 | 99 | 9 | 33 | 0 | 196 | 294 | 4050 | 4148 | Ctena cf. galapagana NHMUK 20210086 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 2257 | 134 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Lucinida | Lucinidae | Ctena | Ctena cf. galapagana NHMUK 20210086 | |
| 20017280 | 20017280 | PRJNA909412_P_NODE_6636_length_204_cov_1.878788_g6495_i0 | PRJNA909412 | 6636 | 204 | 1.878788 | 3.83272752 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 54.7 | 0.005 | NTclustered | gi|2427293685|ref|XM_014932038.2| | 37653 | g6495 | i0 | 96.97 | 2.65686274509804 | 33 | 0 | 16 | 1 | 7 | 39 | 1776 | 1807 | PREDICTED: Octopus bimaculoides probable serine/threonine-protein kinase DDB_G0267686 (LOC106881582), transcript variant X2, mRNA | blastn | 542 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 20375499 | 20375499 | PRJNA909412_P_NODE_10976_length_172_cov_2.421053_g10835_i0 | PRJNA909412 | 10976 | 172 | 2.421053 | 4.16421116 | Magallana | 147004 | Mollusca | Mollusca | 60.2 | 8.62e-5 | NTclustered | gi|2751282572|ref|XM_066086753.1| | 29159 | g10835 | i0 | 80.769 | 0.906976744186046 | 78 | 13 | 45 | 2 | 4 | 80 | 545 | 469 | PREDICTED: Magallana gigas ras-related protein Rab-13 (LOC105324949), mRNA | blastn | 156 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 21651406 | 21651406 | PRJNA909412_P_NODE_3877_length_267_cov_2.166667_g3736_i0 | PRJNA909412 | 3877 | 267 | 2.166667 | 5.78500089 | Metazoa | 33208 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2694097628|ref|XM_063586004.1| | 6551 | g3736 | i0 | 100 | 1.43071161048689 | 30 | 0 | 11 | 0 | 24 | 53 | 483 | 512 | PREDICTED: Mytilus trossulus uncharacterized LOC134722385 (LOC134722385), mRNA | blastn | 382 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus |
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);;