contig_metadata
11 rows where bioproject = "PRJNA900028", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4702869 | 4702869 | PRJNA900028_P_NODE_106764_length_172_cov_2.219512_g106015_i0 | PRJNA900028 | 106764 | 172 | 2.219512 | 3.81756064 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 154 | 3.84e-33 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g106015 | i0 | 91.15 | 3.42441860465116 | 113 | 10 | 72 | 0 | 39 | 151 | 30936814 | 30936926 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 589 | 154 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 16547084 | 16547084 | PRJNA900028_P_NODE_106813_length_172_cov_2.073171_g106064_i0 | PRJNA900028 | 106813 | 172 | 2.073171 | 3.56585412 | Metazoa | 33208 | Mollusca | Mollusca | 58.4 | 3.1e-4 | NTclustered | gi|2793349872|ref|XR_010955290.1| | 109174 | g106064 | i0 | 100 | 14.156976744186 | 31 | 0 | 18 | 0 | 142 | 172 | 2386 | 2416 | PREDICTED: Haliotis asinina large subunit ribosomal RNA (LOC137270364), rRNA | blastn | 2435 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 17822397 | 17822397 | PRJNA900028_P_NODE_16054_length_292_cov_3.106996_g15305_i0 | PRJNA900028 | 16054 | 292 | 3.106996 | 9.07242832 | Metazoa | 33208 | Mollusca | Mollusca | 60.2 | 1.62e-4 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g15305 | i0 | 88.235 | 0.541095890410959 | 51 | 5 | 17 | 1 | 1 | 50 | 15919840 | 15919890 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 158 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 18726246 | 18726246 | PRJNA900028_P_NODE_155255_length_164_cov_0.886957_g154506_i0 | PRJNA900028 | 155255 | 164 | 0.886957 | 1.45460948 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 62.1 | 2.27e-5 | NTclustered | gi|2912994531|dbj|AP039599.1| | 145626 | g154506 | i0 | 91.304 | 1.95731707317073 | 46 | 2 | 28 | 1 | 119 | 164 | 46230200 | 46230243 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 18, sequence | blastn | 321 | 62.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 20002268 | 20002268 | PRJNA900028_P_NODE_50356_length_207_cov_1.670886_g49607_i0 | PRJNA900028 | 50356 | 207 | 1.670886 | 3.45873402 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 93.5 | 1.07e-14 | NTclustered | gi|2912986657|dbj|AP039591.1| | 145626 | g49607 | i0 | 82.569 | 3.70048309178744 | 109 | 15 | 73 | 4 | 48 | 152 | 28896024 | 28895916 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 10, sequence | blastn | 766 | 93.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 25471972 | 25471972 | PRJNA900028_P_NODE_38100_length_224_cov_1.097143_g37351_i0 | PRJNA900028 | 38100 | 224 | 1.097143 | 2.45760032 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 398 | 2.2199999999999997e-106 | NTclustered | gi|2076472537|gb|MZ710040.1| | 6465 | g37351 | i0 | 98.667 | 57.4464285714286 | 225 | 1 | 99 | 1 | 2 | 224 | 1219 | 995 | Patella vulgata voucher LKW089 small subunit ribosomal RNA gene, partial sequence | blastn | 12868 | 398 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 26936791 | 26936791 | PRJNA900028_P_NODE_92502_length_179_cov_1.569231_g91753_i0 | PRJNA900028 | 92502 | 179 | 1.569231 | 2.80892349 | Metazoa | 33208 | Mollusca | Mollusca | 112 | 6.3200000000000006e-27 | NR | KAK7094181.1 | 31220 | g91753 | i0 | 88.1 | 41.5139664804469 | 59 | 7 | 98.9 | 0 | 2 | 178 | 570 | 628 | KAK7094181.1 hypothetical protein V1264_007837 [Littorina saxatilis] | diamond | 7431 | 112 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Littorinidae | Littorina | Littorina saxatilis | |
| 28003570 | 28003570 | PRJNA900028_P_NODE_186285_length_162_cov_0.884956_g185536_i0 | PRJNA900028 | 186285 | 162 | 0.884956 | 1.43362872 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 50.1 | 6.1e-6 | NR | KAH3829362.1 | 45954 | g185536 | i0 | 51.2 | 0.759259259259259 | 41 | 20 | 75.9 | 0 | 9 | 131 | 29 | 69 | KAH3829362.1 hypothetical protein DPMN_131358 [Dreissena polymorpha] | diamond | 123 | 50.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 28823982 | 28823982 | PRJNA900028_P_NODE_141868_length_165_cov_1.318966_g141119_i0 | PRJNA900028 | 141868 | 165 | 1.318966 | 2.1762939 | Mya arenaria | 6604 | Mollusca | Mollusca | 41.2 | 0.0454 | NR | XP_052816150.1 | 6604 | g141119 | i0 | 40.7 | 1.07272727272727 | 59 | 30 | 98.2 | 1 | 164 | 3 | 407 | 465 | XP_052816150.1 uncharacterized protein LOC128242833 isoform X1 [Mya arenaria] | diamond | 177 | 41.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria | |
| 29045401 | 29045401 | PRJNA900028_P_NODE_101588_length_175_cov_1.285714_g100839_i0 | PRJNA900028 | 101588 | 175 | 1.285714 | 2.2499995 | Magallana gigas | 29159 | Mollusca | Mollusca | 82 | 2.15e-16 | NR | XP_065940897.1 | 29159 | g100839 | i0 | 67.3 | 0.891428571428571 | 52 | 17 | 89.1 | 0 | 156 | 1 | 803 | 854 | XP_065940897.1 retrovirus-related Pol polyprotein from transposon 412 [Magallana gigas] | diamond | 156 | 82 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Magallana | Magallana gigas | |
| 29045409 | 29045409 | PRJNA900028_P_NODE_129088_length_166_cov_1.743590_g128339_i0 | PRJNA900028 | 129088 | 166 | 1.74359 | 2.8943594 | Haliotis rufescens | 6454 | Mollusca | Mollusca | 53.1 | 2.77e-6 | NR | XP_048251812.1 | 6454 | g128339 | i0 | 45.1 | 3.77710843373494 | 51 | 24 | 92.2 | 1 | 157 | 5 | 202 | 248 | XP_048251812.1 uncharacterized protein LOC125379948 [Haliotis rufescens] | diamond | 627 | 53.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis rufescens |
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);;