contig_metadata
21 rows where analysis = "blastn", bioproject = "PRJNA1249042" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 354466 | 354466 | PRJNA1249042_S_NODE_55141_length_204_cov_0.968944_g54927_i0 | PRJNA1249042 | 55141 | 204 | 0.968944 | 1.97664576 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g54927 | i0 | 100 | 0.563725490196078 | 30 | 0 | 15 | 0 | 175 | 204 | 58 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 115 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 354754 | 354754 | PRJNA1249042_S_NODE_92661_length_167_cov_1.516129_g92447_i0 | PRJNA1249042 | 92661 | 167 | 1.516129 | 2.53193543 | Ostrea edulis | 37623 | Mollusca | Mollusca | 52.8 | 0.014 | NTclustered | gi|2507331785|ref|XM_048880986.2| | 37623 | g92447 | i0 | 100 | 0.167664670658683 | 28 | 0 | 17 | 0 | 46 | 73 | 3296 | 3269 | PREDICTED: Ostrea edulis uncharacterized LOC125652059 (LOC125652059), transcript variant X2, mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 1052309 | 1052309 | PRJNA1249042_S_NODE_58001_length_200_cov_2.681529_g57787_i0 | PRJNA1249042 | 58001 | 200 | 2.681529 | 5.363058 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 56.5 | 0.001 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g57787 | i0 | 96.97 | 0.6 | 33 | 1 | 17 | 0 | 168 | 200 | 61 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 120 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 1629500 | 1629500 | PRJNA1249042_S_NODE_6942_length_341_cov_2.815436_g6728_i0 | PRJNA1249042 | 6942 | 341 | 2.815436 | 9.60063676 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912998575|dbj|AP039604.1| | 145626 | g6728 | i0 | 100 | 5.92961876832845 | 30 | 0 | 9 | 0 | 125 | 154 | 15331190 | 15331161 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 23, sequence | blastn | 2022 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 2905175 | 2905175 | PRJNA1249042_S_NODE_29863_length_242_cov_1.206030_g29649_i0 | PRJNA1249042 | 29863 | 242 | 1.20603 | 2.9185926 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 58.4 | 4.69e-4 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g29649 | i0 | 100 | 0.867768595041322 | 31 | 0 | 13 | 0 | 212 | 242 | 38 | 8 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 210 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 4181280 | 4181280 | PRJNA1249042_S_NODE_100384_length_161_cov_1.627119_g100170_i0 | PRJNA1249042 | 100384 | 161 | 1.627119 | 2.61966159 | Haliotis rubra | 36100 | Mollusca | Mollusca | 52.8 | 0.013 | NTclustered | gi|2194149202|ref|XM_046687205.1| | 36100 | g100170 | i0 | 100 | 0.869565217391304 | 28 | 0 | 17 | 0 | 132 | 159 | 8564 | 8537 | PREDICTED: Haliotis rubra GTPase-activating protein skywalker-like (LOC124253436), transcript variant X5, mRNA | blastn | 140 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rubra | |
| 5457616 | 5457616 | PRJNA1249042_S_NODE_117305_length_150_cov_1.757009_g117091_i0 | PRJNA1249042 | 117305 | 150 | 1.757009 | 2.6355135 | Choromytilus chorus | 223992 | Mollusca | Mollusca | 52.8 | 0.012 | NTclustered | gi|347823187|gb|JF301680.1| | 223992 | g117091 | i0 | 100 | 0.56 | 28 | 0 | 19 | 0 | 49 | 76 | 407 | 380 | Choromytilus chorus isolate 968 cytochrome oxidase subunit I (COI) gene, partial cds; mitochondrial | blastn | 84 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Choromytilus | Choromytilus chorus | |
| 5457821 | 5457821 | PRJNA1249042_S_NODE_33605_length_234_cov_4.099476_g33391_i0 | PRJNA1249042 | 33605 | 234 | 4.099476 | 9.59277384 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|2912992646|dbj|AP039597.1| | 145626 | g33391 | i0 | 100 | 0.239316239316239 | 28 | 0 | 12 | 0 | 19 | 46 | 17999795 | 17999822 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 16, sequence | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 6732558 | 6732558 | PRJNA1249042_S_NODE_8066_length_326_cov_4.706714_g7852_i0 | PRJNA1249042 | 8066 | 326 | 4.706714 | 15.34388764 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g7852 | i0 | 100 | 0.352760736196319 | 30 | 0 | 9 | 0 | 297 | 326 | 58 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 115 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 9283000 | 9283000 | PRJNA1249042_S_NODE_74728_length_183_cov_1.342857_g74514_i0 | PRJNA1249042 | 74728 | 183 | 1.342857 | 2.45742831 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g74514 | i0 | 100 | 0.628415300546448 | 30 | 0 | 16 | 0 | 1 | 30 | 29 | 58 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 115 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 9980356 | 9980356 | PRJNA1249042_S_NODE_64928_length_193_cov_1.253333_g64714_i0 | PRJNA1249042 | 64928 | 193 | 1.253333 | 2.41893269 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.005 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g64714 | i0 | 100 | 1.0259067357513 | 29 | 0 | 15 | 0 | 165 | 193 | 57 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 198 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 10558466 | 10558466 | PRJNA1249042_S_NODE_2589_length_579_cov_8.850746_g2400_i0 | PRJNA1249042 | 2589 | 579 | 8.850746 | 51.24581934 | Idiosepius paradoxus | 294707 | Mollusca | Mollusca | 60.2 | 3.42e-4 | NTclustered | gi|325504932|dbj|AB586703.1| | 294707 | g2400 | i0 | 90.909 | 0.264248704663212 | 44 | 4 | 8 | 0 | 1 | 44 | 8 | 51 | Idiosepius paradoxus cenG mRNA for centaurin gamma homolog, complete cds | blastn | 153 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Idiosepiidae | Idiosepius | Idiosepius paradoxus | ||
| 11833201 | 11833201 | PRJNA1249042_S_NODE_57590_length_201_cov_1.443038_g57376_i0 | PRJNA1249042 | 57590 | 201 | 1.443038 | 2.90050638 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 58.4 | 3.76e-4 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g57376 | i0 | 100 | 0.577114427860697 | 31 | 0 | 15 | 0 | 1 | 31 | 29 | 59 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 116 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 15657672 | 15657672 | PRJNA1249042_S_NODE_77813_length_180_cov_1.583942_g77599_i0 | PRJNA1249042 | 77813 | 180 | 1.583942 | 2.8510956 | Physella acuta | 109671 | Mollusca | Mollusca | 52.8 | 0.015 | NTclustered | gi|2572411827|ref|XM_059320587.1| | 109671 | g77599 | i0 | 96.774 | 0.172222222222222 | 31 | 1 | 17 | 0 | 13 | 43 | 2165 | 2135 | PREDICTED: Physella acuta uncharacterized LOC131956164 (LOC131956164), mRNA | blastn | 31 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Physidae | Physella | Physella acuta | ||
| 16354758 | 16354758 | PRJNA1249042_S_NODE_82413_length_176_cov_1.060150_g82199_i0 | PRJNA1249042 | 82413 | 176 | 1.06015 | 1.865864 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.004 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g82199 | i0 | 100 | 0.647727272727273 | 29 | 0 | 16 | 0 | 1 | 29 | 29 | 57 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 114 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 16931612 | 16931612 | PRJNA1249042_S_NODE_28894_length_243_cov_5.100000_g28680_i0 | PRJNA1249042 | 28894 | 243 | 5.1 | 12.393 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.022 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g28680 | i0 | 91.892 | 0.152263374485597 | 37 | 3 | 15 | 0 | 2 | 38 | 66503341 | 66503305 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 37 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16931661 | 16931661 | PRJNA1249042_S_NODE_34494_length_233_cov_2.000000_g34280_i0 | PRJNA1249042 | 34494 | 233 | 2 | 4.66 | Pomacea canaliculata | 400727 | Mollusca | Mollusca | 52.8 | 0.021 | NTclustered | gi|1397727518|ref|XM_025255035.1| | 400727 | g34280 | i0 | 100 | 0.120171673819742 | 28 | 0 | 12 | 0 | 176 | 203 | 4264 | 4291 | PREDICTED: Pomacea canaliculata muscle, skeletal receptor tyrosine protein kinase-like (LOC112574156), transcript variant X1, mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Architaenioglossa | Ampullariidae | Pomacea | Pomacea canaliculata | |
| 18206550 | 18206550 | PRJNA1249042_S_NODE_84475_length_174_cov_1.435115_g84261_i0 | PRJNA1249042 | 84475 | 174 | 1.435115 | 2.4971001 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 52.8 | 0.015 | NTclustered | gi|1914654248|ref|XM_036515446.1| | 2607531 | g84261 | i0 | 100 | 0.32183908045977 | 28 | 0 | 16 | 0 | 102 | 129 | 198 | 171 | PREDICTED: Octopus sinensis zinc finger protein 271-like (LOC115226438), transcript variant X1, mRNA | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 18206567 | 18206567 | PRJNA1249042_S_NODE_86095_length_172_cov_3.465116_g85881_i0 | PRJNA1249042 | 86095 | 172 | 3.465116 | 5.95999952 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 58.4 | 3.1e-4 | NTclustered | gi|2034282508|ref|XM_041515485.1| | 1735272 | g85881 | i0 | 97.059 | 0.36046511627907 | 34 | 1 | 20 | 0 | 44 | 77 | 2810 | 2777 | PREDICTED: Gigantopelta aegis A disintegrin and metalloproteinase with thrombospondin motifs 4-like (LOC121384976), mRNA | blastn | 62 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 19480886 | 19480886 | PRJNA1249042_S_NODE_81516_length_176_cov_3.902256_g81302_i0 | PRJNA1249042 | 81516 | 176 | 3.902256 | 6.86797056 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.001 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g81302 | i0 | 100 | 0.653409090909091 | 30 | 0 | 17 | 0 | 1 | 30 | 29 | 58 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 115 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 20178352 | 20178352 | PRJNA1249042_S_NODE_26456_length_248_cov_3.317073_g26242_i0 | PRJNA1249042 | 26456 | 248 | 3.317073 | 8.22634104 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.006 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g26242 | i0 | 100 | 0.459677419354839 | 29 | 0 | 12 | 0 | 220 | 248 | 57 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 114 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii |
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);;