contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA981359" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7339540 | 7339540 | PRJNA981359_S_NODE_1306_length_732_cov_5.420334_g1226_i0 | PRJNA981359 | 1306 | 732 | 5.420334 | 39.67684488 | Mytilus edulis | 6550 | Mollusca | Mollusca | 56.5 | 0.006 | NTclustered | gi|2912391243|ref|XM_071308217.1| | 6550 | g1226 | i0 | 94.444 | 0.0491803278688525 | 36 | 2 | 5 | 0 | 223 | 258 | 1051 | 1086 | PREDICTED: Mytilus edulis globin-3-like (LOC139517297), mRNA | blastn | 36 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis | |
| 14990516 | 14990516 | PRJNA981359_S_NODE_42992_length_295_cov_4.432432_g42892_i0 | PRJNA981359 | 42992 | 295 | 4.432432 | 13.0756744 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.027 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g42892 | i0 | 100 | 0.0949152542372881 | 28 | 0 | 9 | 0 | 31 | 58 | 17967306 | 17967279 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16573362 | 16573362 | PRJNA981359_S_NODE_34333_length_316_cov_1.888889_g34233_i0 | PRJNA981359 | 34333 | 316 | 1.888889 | 5.96888924 | Mytilus | 6548 | Mollusca | Mollusca | 52.8 | 0.03 | NTclustered | gi|2334762153|ref|XM_052209431.1| | 6549 | g34233 | i0 | 100 | 0.265822784810127 | 28 | 0 | 9 | 0 | 5 | 32 | 7060 | 7087 | PREDICTED: Mytilus californianus polyhomeotic-proximal chromatin protein-like (LOC127705179), mRNA | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 17540904 | 17540904 | PRJNA981359_S_NODE_57154_length_266_cov_2.829016_g57054_i0 | PRJNA981359 | 57154 | 266 | 2.829016 | 7.52518256 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 63.9 | 1.12e-5 | NTclustered | gi|2912988862|dbj|AP039593.1| | 145626 | g57054 | i0 | 87.719 | 0.214285714285714 | 57 | 4 | 21 | 2 | 208 | 264 | 38483135 | 38483082 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 12, sequence | blastn | 57 | 63.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20088407 | 20088407 | PRJNA981359_S_NODE_19276_length_363_cov_3.275862_g19176_i0 | PRJNA981359 | 19276 | 363 | 3.275862 | 11.89137906 | Biomphalaria glabrata | 6526 | Mollusca | Mollusca | 52.8 | 0.034 | NTclustered | gi|2502198937|ref|XR_008779771.1| | 6526 | g19176 | i0 | 96.774 | 0.170798898071625 | 31 | 1 | 9 | 0 | 302 | 332 | 17436 | 17406 | PREDICTED: Biomphalaria glabrata protein eyes shut homolog (LOC106071565), transcript variant X2, misc_RNA | blastn | 62 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata | ||
| 20089039 | 20089039 | PRJNA981359_S_NODE_40336_length_301_cov_5.412281_g40236_i0 | PRJNA981359 | 40336 | 301 | 5.412281 | 16.29096581 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 67.6 | 1e-6 | NTclustered | gi|2912983111|dbj|AP039588.1| | 145626 | g40236 | i0 | 91.667 | 0.388704318936877 | 48 | 4 | 16 | 0 | 18 | 65 | 6130598 | 6130645 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 7, sequence | blastn | 117 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23914330 | 23914330 | PRJNA981359_S_NODE_13279_length_394_cov_2.809969_g13179_i0 | PRJNA981359 | 13279 | 394 | 2.809969 | 11.07127786 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.01 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g13179 | i0 | 100 | 0.0736040609137056 | 29 | 0 | 7 | 0 | 94 | 122 | 25852255 | 25852283 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23914998 | 23914998 | PRJNA981359_S_NODE_34739_length_315_cov_1.814050_g34639_i0 | PRJNA981359 | 34739 | 315 | 1.81405 | 5.7142575 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.029 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g34639 | i0 | 100 | 0.0888888888888889 | 28 | 0 | 9 | 0 | 145 | 172 | 24537500 | 24537527 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23915903 | 23915903 | PRJNA981359_S_NODE_67259_length_249_cov_2.585227_g67159_i0 | PRJNA981359 | 67259 | 249 | 2.585227 | 6.43721523 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|1914624235|ref|XR_004997935.1| | 2607531 | g67159 | i0 | 96.97 | 0.244979919678715 | 33 | 0 | 13 | 1 | 169 | 200 | 379 | 347 | PREDICTED: Octopus sinensis uncharacterized LOC118762160 (LOC118762160), ncRNA | blastn | 61 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 25189417 | 25189417 | PRJNA981359_S_NODE_6540_length_465_cov_1.977041_g6441_i0 | PRJNA981359 | 6540 | 465 | 1.977041 | 9.19324065 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 52.8 | 0.045 | NTclustered | gi|1914663783|ref|XM_029783294.2| | 2607531 | g6441 | i0 | 96.774 | 0.333333333333333 | 31 | 1 | 7 | 0 | 214 | 244 | 5338 | 5368 | PREDICTED: Octopus sinensis phosphatidylinositol 3,4,5-trisphosphate 3-phosphatase TPTE2-like (LOC115214194), transcript variant X3, mRNA | blastn | 155 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis |
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);;