contig_metadata
12 rows where bioproject = "PRJNA1101946", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 211282 | 211282 | PRJNA1101946_S_NODE_4741_length_315_cov_2.883459_g4642_i0 | PRJNA1101946 | 4741 | 315 | 2.883459 | 9.08289585 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|2912981848|dbj|AP039587.1| | 145626 | g4642 | i0 | 96.97 | 0.104761904761905 | 33 | 0 | 10 | 1 | 242 | 273 | 24009057 | 24009089 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 6, sequence | blastn | 33 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 4038031 | 4038031 | PRJNA1101946_S_NODE_8464_length_263_cov_5.761682_g8365_i0 | PRJNA1101946 | 8464 | 263 | 5.761682 | 15.15322366 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.024 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g8365 | i0 | 100 | 0.106463878326996 | 28 | 0 | 11 | 0 | 202 | 229 | 53560199 | 53560172 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 11689969 | 11689969 | PRJNA1101946_S_NODE_27030_length_154_cov_4.161905_g26931_i0 | PRJNA1101946 | 27030 | 154 | 4.161905 | 6.4093337 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 60.2 | 7.55e-5 | NTclustered | gi|2912997258|dbj|AP039602.1| | 145626 | g26931 | i0 | 100 | 45.5454545454545 | 32 | 0 | 22 | 0 | 123 | 154 | 5941177 | 5941208 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 21, sequence | blastn | 7014 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 23972178 | 23972178 | PRJNA1101946_S_NODE_20919_length_176_cov_2.811024_g20820_i0 | PRJNA1101946 | 20919 | 176 | 2.811024 | 4.94740224 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.004 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g20820 | 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 | |
| 27130449 | 27130449 | PRJNA1101946_S_NODE_10002_length_247_cov_12.803030_g9903_i0 | PRJNA1101946 | 10002 | 247 | 12.80303 | 31.6234841 | Haliotis asinina | 109174 | Mollusca | Mollusca | 43.9 | 0.0148 | NR | XP_067657806.1 | 109174 | g9903 | i0 | 35.4 | 2.35627530364372 | 65 | 36 | 77.7 | 2 | 213 | 22 | 144 | 203 | XP_067657806.1 uncharacterized protein [Haliotis asinina] | diamond | 582 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 27510152 | 27510152 | PRJNA1101946_S_NODE_23103_length_167_cov_5.796610_g23004_i0 | PRJNA1101946 | 23103 | 167 | 5.79661 | 9.6803387 | Ylistrum balloti | 509963 | Mollusca | Mollusca | 88.6 | 6.33e-19 | NR | XP_060071943.1 | 509963 | g23004 | i0 | 80 | 2.96407185628743 | 55 | 11 | 98.8 | 0 | 1 | 165 | 93 | 147 | XP_060071943.1 uncharacterized protein LOC132551815 [Ylistrum balloti] | diamond | 495 | 88.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 27943486 | 27943486 | PRJNA1101946_S_NODE_27525_length_152_cov_22.844660_g27426_i0 | PRJNA1101946 | 27525 | 152 | 22.84466 | 34.7238832 | Metazoa | 33208 | Mollusca | Mollusca | 74.3 | 7.69e-14 | NR | XP_021339388.1 | 6573 | g27426 | i0 | 74 | 55.2631578947368 | 50 | 13 | 98.7 | 0 | 150 | 1 | 88 | 137 | XP_021339388.1 uncharacterized protein LOC110440572 [Mizuhopecten yessoensis] | diamond | 8400 | 74.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 28953990 | 28953990 | PRJNA1101946_S_NODE_26868_length_154_cov_49.857143_g26769_i0 | PRJNA1101946 | 26868 | 154 | 49.857143 | 76.78000022 | Bivalvia | 6544 | Mollusca | Mollusca | 66.2 | 5.52e-11 | NR | XP_060071943.1 | 509963 | g26769 | i0 | 68.6 | 55.6363636363636 | 51 | 16 | 99.4 | 0 | 1 | 153 | 93 | 143 | XP_060071943.1 uncharacterized protein LOC132551815 [Ylistrum balloti] | diamond | 8568 | 66.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 29309695 | 29309695 | PRJNA1101946_S_NODE_23729_length_165_cov_5.293103_g23630_i0 | PRJNA1101946 | 23729 | 165 | 5.293103 | 8.73361995 | Lymnaea stagnalis | 6523 | Mollusca | Mollusca | 41.6 | 0.0341 | NR | CAL1531800.1 | 6523 | g23630 | i0 | 82.4 | 0.309090909090909 | 17 | 3 | 30.9 | 0 | 106 | 156 | 78 | 94 | CAL1531800.1 unnamed protein product, partial [Lymnaea stagnalis] | diamond | 51 | 41.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 30312235 | 30312235 | PRJNA1101946_S_NODE_10512_length_242_cov_34.051813_g10413_i0 | PRJNA1101946 | 10512 | 242 | 34.051813 | 82.40538746 | Metazoa | 33208 | Mollusca | Mollusca | 93.6 | 5.07e-22 | NR | OWF37074.1 | 6573 | g10413 | i0 | 74.2 | 3.07438016528926 | 62 | 16 | 76.9 | 0 | 3 | 188 | 100 | 161 | OWF37074.1 Calmodulin [Mizuhopecten yessoensis] | diamond | 744 | 93.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Mizuhopecten | Mizuhopecten yessoensis | |
| 31101489 | 31101489 | PRJNA1101946_S_NODE_28095_length_150_cov_41.564356_g27996_i0 | PRJNA1101946 | 28095 | 150 | 41.564356 | 62.346534 | Bivalvia | 6544 | Mollusca | Mollusca | 67.8 | 1.5e-11 | NR | XP_060071943.1 | 509963 | g27996 | i0 | 72 | 55 | 50 | 14 | 100 | 0 | 1 | 150 | 93 | 142 | XP_060071943.1 uncharacterized protein LOC132551815 [Ylistrum balloti] | diamond | 8250 | 67.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti | |
| 32871630 | 32871630 | PRJNA1101946_S_NODE_14200_length_213_cov_24.268293_g14101_i0 | PRJNA1101946 | 14200 | 213 | 24.268293 | 51.69146409 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 70.1 | 5.24e-12 | NR | XP_060071943.1 | 509963 | g14101 | i0 | 79.5 | 1.23943661971831 | 44 | 9 | 62 | 0 | 3 | 134 | 93 | 136 | XP_060071943.1 uncharacterized protein LOC132551815 [Ylistrum balloti] | diamond | 264 | 70.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Ylistrum | Ylistrum balloti |
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);;