contig_metadata
13 rows where bioproject = "PRJNA1111146", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2766651 | 2766651 | PRJNA1111146_P_NODE_228863_length_200_cov_2.292517_g227725_i0 | PRJNA1111146 | 228863 | 200 | 2.292517 | 4.585034 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.017 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g227725 | i0 | 100 | 0.14 | 28 | 0 | 14 | 0 | 26 | 53 | 8756233 | 8756206 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 5319240 | 5319240 | PRJNA1111146_P_NODE_31145_length_326_cov_1.271062_g30008_i0 | PRJNA1111146 | 31145 | 326 | 1.271062 | 4.14366212 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 1.42e-5 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g30008 | i0 | 97.297 | 0.966257668711656 | 37 | 1 | 11 | 0 | 191 | 227 | 35675533 | 35675497 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 315 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7869559 | 7869559 | PRJNA1111146_P_NODE_406307_length_179_cov_0.888889_g405169_i0 | PRJNA1111146 | 406307 | 179 | 0.888889 | 1.59111131 | Macoma balthica | 1903275 | Mollusca | Mollusca | 220 | 3.93e-53 | NTclustered | gi|743435123|gb|KM373205.1| | 1903275 | g405169 | i0 | 100 | 31.536312849162 | 119 | 0 | 66 | 0 | 1 | 119 | 2008 | 2126 | Macoma balthica isolate F17 mitochondrion, partial genome | blastn | 5645 | 220 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Cardiida | Tellinidae | Macoma | Macoma balthica | |
| 10419416 | 10419416 | PRJNA1111146_P_NODE_215029_length_203_cov_1.520000_g213891_i0 | PRJNA1111146 | 215029 | 203 | 1.52 | 3.0856 | Mytilus trossulus | 6551 | Mollusca | Mollusca | 187 | 4.65e-43 | NTclustered | gi|2694110933|ref|XM_063589529.1| | 6551 | g213891 | i0 | 98.131 | 80.5665024630542 | 107 | 2 | 99 | 0 | 1 | 107 | 818 | 924 | PREDICTED: Mytilus trossulus uncharacterized LOC134725586 (LOC134725586), mRNA | blastn | 16355 | 187 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 24442690 | 24442690 | PRJNA1111146_P_NODE_389120_length_180_cov_0.889764_g387982_i0 | PRJNA1111146 | 389120 | 180 | 0.889764 | 1.6015752 | Littorina saxatilis | 31220 | Mollusca | Mollusca | 254 | 3.9e-63 | NTclustered | gi|2868636229|ref|XM_070320787.1| | 31220 | g387982 | i0 | 99.286 | 116.422222222222 | 140 | 1 | 78 | 0 | 1 | 140 | 4987 | 5126 | PREDICTED: Littorina saxatilis uncharacterized protein (LOC138949062), mRNA | blastn | 20956 | 254 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 27952273 | 27952273 | PRJNA1111146_P_NODE_425265_length_177_cov_1.838710_g424127_i0 | PRJNA1111146 | 425265 | 177 | 1.83871 | 3.2545167 | Tegillarca granosa | 220873 | Mollusca | Mollusca | 42.7 | 0.0153 | NR | KAJ8315036.1 | 220873 | g424127 | i0 | 39.2 | 6.38983050847458 | 51 | 31 | 86.4 | 0 | 155 | 3 | 198 | 248 | KAJ8315036.1 hypothetical protein KUTeg_007186 [Tegillarca granosa] | diamond | 1131 | 43.1 | 0.990719257540603 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Tegillarca | Tegillarca granosa | |
| 28195903 | 28195903 | PRJNA1111146_P_NODE_420586_length_178_cov_0.904000_g419448_i0 | PRJNA1111146 | 420586 | 178 | 0.904 | 1.60912 | Metazoa | 33208 | Mollusca | Mollusca | 45.8 | 0.00129 | NR | XP_052786368.1 | 6604 | g419448 | i0 | 34.7 | 5.96629213483146 | 49 | 32 | 82.6 | 0 | 153 | 7 | 251 | 299 | XP_052786368.1 mitochondrial Rho GTPase 1-like isoform X2 [Mya arenaria] | diamond | 1062 | 45.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 28804483 | 28804483 | PRJNA1111146_P_NODE_352348_length_182_cov_0.883721_g351210_i0 | PRJNA1111146 | 352348 | 182 | 0.883721 | 1.60837222 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 65.9 | 9.47e-12 | NR | RUS77281.1 | 188477 | g351210 | i0 | 83.9 | 1.53296703296703 | 31 | 5 | 51.1 | 0 | 180 | 88 | 97 | 127 | RUS77281.1 hypothetical protein EGW08_014945, partial [Elysia chlorotica] | diamond | 279 | 65.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 31742827 | 31742827 | PRJNA1111146_P_NODE_375217_length_181_cov_0.867188_g374079_i0 | PRJNA1111146 | 375217 | 181 | 0.867188 | 1.56961028 | Mytilus edulis | 6550 | Mollusca | Mollusca | 47.4 | 3.59e-4 | NR | CAG2214739.1 | 6550 | g374079 | i0 | 76.9 | 0.994475138121547 | 26 | 6 | 43.1 | 0 | 156 | 79 | 224 | 249 | CAG2214739.1 unnamed protein product [Mytilus edulis] | diamond | 180 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 31987119 | 31987119 | PRJNA1111146_P_NODE_226298_length_201_cov_1.472973_g225160_i0 | PRJNA1111146 | 226298 | 201 | 1.472973 | 2.96067573 | Stylommatophora | 6527 | Mollusca | Mollusca | 59.3 | 2.84e-8 | NR | BFZ09631.1 | 145626 | g225160 | i0 | 56.4 | 5.64179104477612 | 55 | 24 | 82.1 | 0 | 197 | 33 | 237 | 291 | BFZ09631.1 hypothetical protein BsWGS_12670 [Bradybaena similaris] | diamond | 1134 | 59.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 32090974 | 32090974 | PRJNA1111146_P_NODE_220478_length_202_cov_1.516779_g219340_i0 | PRJNA1111146 | 220478 | 202 | 1.516779 | 3.06389358 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 60.5 | 8.86e-9 | NR | CAC5395605.1 | 42192 | g219340 | i0 | 66.7 | 1.76732673267327 | 45 | 13 | 66.8 | 1 | 191 | 57 | 60 | 102 | CAC5395605.1 unnamed protein product [Mytilus coruscus] | diamond | 357 | 60.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 32122797 | 32122797 | PRJNA1111146_P_NODE_90878_length_249_cov_1.071429_g89740_i0 | PRJNA1111146 | 90878 | 249 | 1.071429 | 2.66785821 | Acanthosepion pharaonis | 158019 | Mollusca | Mollusca | 42.4 | 0.0372 | NR | CAE1316284.1 | 158019 | g89740 | i0 | 60.5 | 0.518072289156627 | 43 | 12 | 49.4 | 2 | 110 | 232 | 114 | 153 | CAE1316284.1 unnamed protein product [Acanthosepion pharaonis] | diamond | 129 | 42.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 32525492 | 32525492 | PRJNA1111146_P_NODE_314079_length_185_cov_0.863636_g312941_i0 | PRJNA1111146 | 314079 | 185 | 0.863636 | 1.5977266 | Metazoa | 33208 | Mollusca | Mollusca | 43.1 | 0.0128 | NR | XP_059177648.1 | 109671 | g312941 | i0 | 41.5 | 2.96756756756757 | 53 | 31 | 85.9 | 0 | 7 | 165 | 166 | 218 | XP_059177648.1 uncharacterized protein K02A2.6-like [Physella acuta] | diamond | 549 | 43.5 | 0.990804597701149 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta |
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);;