contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA270367" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4197108 | 4197108 | PRJNA270367_P_NODE_25184_length_229_cov_0.861111_g24979_i0 | PRJNA270367 | 25184 | 229 | 0.861111 | 1.97194419 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 62.1 | 3.39e-5 | NTclustered | gi|1397673889|ref|XM_025232809.1| | 400727 | g24979 | i0 | 97.222 | 5.24890829694323 | 36 | 1 | 16 | 0 | 1 | 36 | 2225 | 2260 | PREDICTED: Pomacea canaliculata atrial natriuretic peptide receptor 1-like (LOC112560759), transcript variant X2, mRNA | blastn | 1202 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 4197137 | 4197137 | PRJNA270367_P_NODE_28244_length_212_cov_1.404908_g28039_i0 | PRJNA270367 | 28244 | 212 | 1.404908 | 2.97840496 | Pecten maximus | 6579 | Mollusca | Mollusca | 148 | 2.3099999999999997e-31 | NTclustered | gi|1835480281|ref|XM_033903157.1| | 6579 | g28039 | i0 | 80 | 37.2028301886792 | 205 | 37 | 96 | 4 | 1 | 203 | 907 | 1109 | PREDICTED: Pecten maximus V-type proton ATPase catalytic subunit A (LOC117341302), mRNA | blastn | 7887 | 148 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Pecten | Pecten maximus | |
| 5473329 | 5473329 | PRJNA270367_P_NODE_21985_length_252_cov_0.852217_g21780_i0 | PRJNA270367 | 21985 | 252 | 0.852217 | 2.14758684 | Lottia gigantea | 225164 | Mollusca | Mollusca | 200 | 7.709999999999998e-47 | NTclustered | gi|676477751|ref|XM_009062958.1| | 225164 | g21780 | i0 | 86.096 | 14.8412698412698 | 187 | 24 | 74 | 2 | 1 | 186 | 238 | 423 | Lottia gigantea hypothetical protein mRNA | blastn | 3740 | 200 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lottiidae | Lottia | Lottia gigantea | ||
| 5473521 | 5473521 | PRJNA270367_P_NODE_42285_length_166_cov_1.324786_g42080_i0 | PRJNA270367 | 42285 | 166 | 1.324786 | 2.19914476 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|1207969387|ref|XM_021519688.1| | 6573 | g42080 | i0 | 100 | 1.51807228915663 | 28 | 0 | 17 | 0 | 57 | 84 | 9742 | 9769 | PREDICTED: Mizuhopecten yessoensis uncharacterized LOC110464458 (LOC110464458), transcript variant X10, mRNA | blastn | 252 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 6161305 | 6161305 | PRJNA270367_P_NODE_7985_length_476_cov_8.824356_g7787_i0 | PRJNA270367 | 7985 | 476 | 8.824356 | 42.00393456 | Bivalvia | 6544 | Mollusca | Mollusca | 204 | 1.21e-47 | NTclustered | gi|2912427384|ref|XM_071264467.1| | 6550 | g7787 | i0 | 87.861 | 45.1323529411765 | 173 | 21 | 36 | 0 | 282 | 454 | 245 | 73 | PREDICTED: Mytilus edulis large ribosomal subunit protein uL15-like (LOC139481281), mRNA | blastn | 21483 | 204 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 7436297 | 7436297 | PRJNA270367_P_NODE_46506_length_162_cov_0.920354_g46301_i0 | PRJNA270367 | 46506 | 162 | 0.920354 | 1.49097348 | Metazoa | 33208 | Mollusca | Mollusca | 300 | 4.36e-77 | NTclustered | gi|1928112764|gb|MT947788.1| | 6523 | g46301 | i0 | 100 | 99.9506172839506 | 162 | 0 | 100 | 0 | 1 | 162 | 1348 | 1187 | Lymnaea stagnalis isolate Lsta_434075 hypothetical protein mRNA, complete cds | blastn | 16192 | 300 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 8023305 | 8023305 | PRJNA270367_P_NODE_18087_length_290_cov_1.232365_g17882_i0 | PRJNA270367 | 18087 | 290 | 1.232365 | 3.5738585 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.007 | NTclustered | gi|2913001816|dbj|AP039609.1| | 145626 | g17882 | i0 | 100 | 0.1 | 29 | 0 | 10 | 0 | 78 | 106 | 16642120 | 16642092 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 28, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10574167 | 10574167 | PRJNA270367_P_NODE_43109_length_165_cov_1.577586_g42904_i0 | PRJNA270367 | 43109 | 165 | 1.577586 | 2.6030169 | Physella acuta | 109671 | Mollusca | Mollusca | 63.9 | 6.37e-6 | NTclustered | gi|2572308059|ref|XM_059294646.1| | 109671 | g42904 | i0 | 86.207 | 0.703030303030303 | 58 | 8 | 35 | 0 | 14 | 71 | 521 | 578 | PREDICTED: Physella acuta cysteine and glycine-rich protein 2-like (LOC131937333), transcript variant X2, mRNA | blastn | 116 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 13811081 | 13811081 | PRJNA270367_P_NODE_16371_length_310_cov_3.459770_g16166_i0 | PRJNA270367 | 16371 | 310 | 3.45977 | 10.725287 | Metazoa | 33208 | Mollusca | Mollusca | 60.2 | 1.73e-4 | NTclustered | gi|2693939483|ref|XM_063557813.1| | 6551 | g16166 | i0 | 92.683 | 9.79032258064516 | 41 | 3 | 13 | 0 | 154 | 194 | 873 | 913 | PREDICTED: Mytilus trossulus zinc finger protein 330 homolog (LOC134696162), mRNA | blastn | 3035 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus trossulus | |
| 16947627 | 16947627 | PRJNA270367_P_NODE_8314_length_465_cov_7.805288_g8115_i0 | PRJNA270367 | 8314 | 465 | 7.805288 | 36.2945892 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 202 | 4.239999999999999e-47 | NTclustered | gi|2442017659|ref|XM_053527748.1| | 6596 | g8115 | i0 | 83.962 | 32.5720430107527 | 212 | 32 | 45 | 2 | 17 | 227 | 70 | 280 | PREDICTED: Mercenaria mercenaria 60S ribosomal protein L27a-like (LOC128549953), mRNA | blastn | 15146 | 202 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 20771492 | 20771492 | PRJNA270367_P_NODE_26557_length_221_cov_1.122093_g26352_i0 | PRJNA270367 | 26557 | 221 | 1.122093 | 2.47982553 | Mizuhopecten yessoensis | 6573 | Mollusca | Mollusca | 135 | 1.89e-27 | NTclustered | gi|1207954086|ref|XM_021511478.1| | 6573 | g26352 | i0 | 83.673 | 16.0361990950226 | 147 | 20 | 66 | 4 | 50 | 194 | 2153 | 2297 | PREDICTED: Mizuhopecten yessoensis sodium/potassium-transporting ATPase subunit alpha-like (LOC110459295), mRNA | blastn | 3544 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 22046615 | 22046615 | PRJNA270367_P_NODE_35258_length_183_cov_1.164179_g35053_i0 | PRJNA270367 | 35258 | 183 | 1.164179 | 2.13044757 | Saccostrea echinata | 191078 | Mollusca | Mollusca | 69.4 | 1.55e-7 | NTclustered | gi|2628564479|ref|XM_061340044.1| | 191078 | g35053 | i0 | 97.5 | 0.218579234972678 | 40 | 1 | 22 | 0 | 133 | 172 | 2682 | 2643 | PREDICTED: Saccostrea echinata receptor-type tyrosine-protein phosphatase epsilon-like (LOC133204319), mRNA | blastn | 40 | 69.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Saccostrea | Saccostrea echinata |
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);;