contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA911178" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 892293 | 892293 | PRJNA911178_P_NODE_225321_length_258_cov_1.654054_g222847_i0 | PRJNA911178 | 225321 | 258 | 1.654054 | 4.26745932 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 206 | 1.6999999999999998e-48 | NTclustered | gi|1697450084|ref|XM_029784716.1| | 2607531 | g222847 | i0 | 86.01 | 80.3992248062015 | 193 | 25 | 74 | 2 | 24 | 215 | 136 | 327 | PREDICTED: Octopus sinensis histone H3.3-like (LOC115215535), mRNA | blastn | 20743 | 206 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 2168276 | 2168276 | PRJNA911178_P_NODE_293142_length_241_cov_0.916667_g290668_i0 | PRJNA911178 | 293142 | 241 | 0.916667 | 2.20916747 | Haliotis cracherodii | 6455 | Mollusca | Mollusca | 67.6 | 7.75e-7 | NTclustered | gi|2911907731|ref|XM_071231615.1| | 6455 | g290668 | i0 | 88.889 | 0.224066390041494 | 54 | 6 | 22 | 0 | 186 | 239 | 3428 | 3375 | PREDICTED: Haliotis cracherodii BTB/POZ domain-containing protein 6-B-like (LOC139450004), mRNA | blastn | 54 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis cracherodii | |
| 3442733 | 3442733 | PRJNA911178_P_NODE_176743_length_285_cov_1.330189_g174270_i0 | PRJNA911178 | 176743 | 285 | 1.330189 | 3.79103865 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.026 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g174270 | i0 | 100 | 0.196491228070175 | 28 | 0 | 10 | 0 | 215 | 242 | 55977414 | 55977387 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4719798 | 4719798 | PRJNA911178_P_NODE_104584_length_354_cov_3.750890_g102112_i0 | PRJNA911178 | 104584 | 354 | 3.75089 | 13.2781506 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 5.56e-5 | NTclustered | gi|2912999222|dbj|AP039605.1| | 145626 | g102112 | i0 | 100 | 11.9491525423729 | 33 | 0 | 19 | 0 | 1 | 33 | 21032982 | 21033014 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 24, sequence | blastn | 4230 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4720012 | 4720012 | PRJNA911178_P_NODE_128404_length_325_cov_2.674603_g125932_i0 | PRJNA911178 | 128404 | 325 | 2.674603 | 8.69245975 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.031 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g125932 | i0 | 100 | 0.0861538461538462 | 28 | 0 | 9 | 0 | 103 | 130 | 18725030 | 18725057 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 7271008 | 7271008 | PRJNA911178_P_NODE_287126_length_242_cov_0.911243_g284652_i0 | PRJNA911178 | 287126 | 242 | 0.911243 | 2.20520806 | Doryteuthis pealeii | 1051067 | Mollusca | Mollusca | 126 | 1.2699999999999999e-24 | NTclustered | gi|1884643889|gb|MT648678.1| | 1051067 | g284652 | i0 | 82.119 | 1.24793388429752 | 151 | 24 | 61 | 2 | 77 | 224 | 97906 | 97756 | Doryteuthis pealeii tryptophan 2,3 dioxygenase (TDO) gene, complete cds | blastn | 302 | 126 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Myopsida | Loliginidae | Doryteuthis | Doryteuthis pealeii | |
| 8545738 | 8545738 | PRJNA911178_P_NODE_282467_length_243_cov_0.905882_g279993_i0 | PRJNA911178 | 282467 | 243 | 0.905882 | 2.20129326 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 58.4 | 4.71e-4 | NTclustered | gi|2912991694|dbj|AP039596.1| | 145626 | g279993 | i0 | 100 | 0.502057613168724 | 31 | 0 | 13 | 0 | 201 | 231 | 26365476 | 26365446 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 15, sequence | blastn | 122 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11095395 | 11095395 | PRJNA911178_P_NODE_169809_length_289_cov_1.365741_g167336_i0 | PRJNA911178 | 169809 | 289 | 1.365741 | 3.94699149 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 65.8 | 3.44e-6 | NTclustered | gi|2913001038|dbj|AP039608.1| | 145626 | g167336 | i0 | 97.368 | 17.4498269896194 | 38 | 1 | 13 | 0 | 9 | 46 | 47454482 | 47454445 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 27, sequence | blastn | 5043 | 65.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 13646141 | 13646141 | PRJNA911178_P_NODE_246611_length_250_cov_0.870056_g244137_i0 | PRJNA911178 | 246611 | 250 | 0.870056 | 2.17514 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.006 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g244137 | i0 | 100 | 0.116 | 29 | 0 | 12 | 0 | 212 | 240 | 1051698 | 1051670 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16552208 | 16552208 | PRJNA911178_P_NODE_157153_length_298_cov_15.880000_g154680_i0 | PRJNA911178 | 157153 | 298 | 15.88 | 47.3224 | Metazoa | 33208 | Mollusca | Mollusca | 551 | 2.239999999999999e-152 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g154680 | i0 | 100 | 54.0369127516779 | 298 | 0 | 100 | 0 | 1 | 298 | 1839 | 1542 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 16103 | 551 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 18743820 | 18743820 | PRJNA911178_P_NODE_218315_length_262_cov_1.222222_g215841_i0 | PRJNA911178 | 218315 | 262 | 1.222222 | 3.20222164 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 67.6 | 8.54e-7 | NTclustered | gi|2912985489|dbj|AP039590.1| | 145626 | g215841 | i0 | 93.333 | 3.07251908396947 | 45 | 3 | 17 | 0 | 161 | 205 | 79111079 | 79111123 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence | blastn | 805 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 22568376 | 22568376 | PRJNA911178_P_NODE_103118_length_356_cov_6.766784_g100647_i0 | PRJNA911178 | 103118 | 356 | 6.766784 | 24.08975104 | Physella acuta | 109671 | Mollusca | Mollusca | 577 | 4.4999999999999984e-160 | NTclustered | gi|2572452079|ref|XR_009385380.1| | 109671 | g100647 | i0 | 97.076 | 4.32022471910112 | 342 | 10 | 96 | 0 | 14 | 355 | 3384 | 3725 | PREDICTED: Physella acuta large subunit ribosomal RNA (LOC131933988), rRNA | blastn | 1538 | 577 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 22568726 | 22568726 | PRJNA911178_P_NODE_144158_length_310_cov_1.303797_g141685_i0 | PRJNA911178 | 144158 | 310 | 1.303797 | 4.0417707 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.029 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g141685 | i0 | 100 | 0.0903225806451613 | 28 | 0 | 9 | 0 | 67 | 94 | 35001662 | 35001689 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris |
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);;