contig_metadata
11 rows where bioproject = "PRJNA554794", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 520893 | 520893 | PRJNA554794_P_NODE_21201_length_183_cov_1.679104_g17272_i0 | PRJNA554794 | 21201 | 183 | 1.679104 | 3.07276032 | Opisthokonta | 33154 | Mollusca | Mollusca | 80.9 | 2.54e-17 | NR | CAE1313518.1 | 158019 | g17272 | i0 | 66.7 | 6.60655737704918 | 60 | 20 | 98.4 | 0 | 2 | 181 | 16 | 75 | CAE1313518.1 ndk [Acanthosepion pharaonis] | diamond | 1209 | 80.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Sepiida | Sepiidae | Acanthosepion | Acanthosepion pharaonis | |
| 27092789 | 27092789 | PRJNA554794_P_NODE_21062_length_185_cov_1.183824_g17133_i0 | PRJNA554794 | 21062 | 185 | 1.183824 | 2.1900744 | Metazoa | 33208 | Mollusca | Mollusca | 70.5 | 2.58e-12 | NR | CAL1542583.1 | 6523 | g17133 | i0 | 55.7 | 2.98378378378378 | 61 | 26 | 97.3 | 1 | 180 | 1 | 221 | 281 | CAL1542583.1 unnamed protein product [Lymnaea stagnalis] | diamond | 552 | 70.9 | 0.994358251057828 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lymnaeidae | Lymnaea | Lymnaea stagnalis | ||
| 27724999 | 27724999 | PRJNA554794_P_NODE_22664_length_167_cov_0.864407_g18735_i0 | PRJNA554794 | 22664 | 167 | 0.864407 | 1.44355969 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 58.2 | 4.75e-8 | NR | CAI9721698.1 | 6645 | g18735 | i0 | 56.6 | 7.76047904191617 | 53 | 23 | 95.2 | 0 | 159 | 1 | 335 | 387 | CAI9721698.1 non-specific lipid-transfer protein [Octopus vulgaris] | diamond | 1296 | 58.5 | 0.994871794871795 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus vulgaris | |
| 28135188 | 28135188 | PRJNA554794_P_NODE_25305_length_152_cov_2.631068_g21376_i0 | PRJNA554794 | 25305 | 152 | 2.631068 | 3.99922336 | Opisthokonta | 33154 | Mollusca | Mollusca | 48.1 | 1.33e-4 | NR | KAL5018872.1 | 13268 | g21376 | i0 | 59.5 | 1.5 | 37 | 15 | 73 | 0 | 151 | 41 | 366 | 402 | KAL5018872.1 hypothetical protein ScPMuIL_004594 [Solemya velum] | diamond | 228 | 48.5 | 0.991752577319588 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 28404686 | 28404686 | PRJNA554794_P_NODE_24666_length_161_cov_0.910714_g20737_i0 | PRJNA554794 | 24666 | 161 | 0.910714 | 1.46624954 | Mercenaria mercenaria | 6596 | Mollusca | Mollusca | 76.3 | 5.65e-15 | NR | XP_045164937.2 | 6596 | g20737 | i0 | 67.9 | 3.95031055900621 | 53 | 16 | 98.8 | 1 | 3 | 161 | 120 | 171 | XP_045164937.2 countin-1-like [Mercenaria mercenaria] | diamond | 636 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Venerida | Veneridae | Mercenaria | Mercenaria mercenaria | |
| 29429383 | 29429383 | PRJNA554794_P_NODE_22949_length_166_cov_0.863248_g19020_i0 | PRJNA554794 | 22949 | 166 | 0.863248 | 1.43299168 | Metazoa | 33208 | Mollusca | Mollusca | 83.2 | 7.27e-17 | NR | XP_067667448.1 | 109174 | g19020 | i0 | 72.2 | 45.5963855421687 | 54 | 15 | 97.6 | 0 | 165 | 4 | 212 | 265 | XP_067667448.1 uncharacterized protein [Haliotis asinina] | diamond | 7569 | 83.6 | 0.995215311004785 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Lepetellida | Haliotidae | Haliotis | Haliotis asinina | |
| 30346087 | 30346087 | PRJNA554794_P_NODE_20492_length_193_cov_1.763889_g16563_i0 | PRJNA554794 | 20492 | 193 | 1.763889 | 3.40430577 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 100 | 6.56e-25 | NR | XP_052270710.1 | 45954 | g16563 | i0 | 66.7 | 4.89637305699482 | 63 | 21 | 97.9 | 0 | 1 | 189 | 58 | 120 | XP_052270710.1 eukaryotic translation initiation factor 5A-1-like isoform X2 [Dreissena polymorpha] | diamond | 945 | 101 | 0.99009900990099 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 30724685 | 30724685 | PRJNA554794_P_NODE_21434_length_180_cov_1.091603_g17505_i0 | PRJNA554794 | 21434 | 180 | 1.091603 | 1.9648854 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 80.1 | 4.36e-16 | NR | KAL5008602.1 | 13268 | g17505 | i0 | 62.5 | 1.93333333333333 | 56 | 21 | 93.3 | 0 | 13 | 180 | 92 | 147 | KAL5008602.1 hypothetical protein ScPMuIL_014183 [Solemya velum] | diamond | 348 | 80.5 | 0.995031055900621 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Solemyida | Solemyidae | Solemya | Solemya velum | |
| 31120540 | 31120540 | PRJNA554794_P_NODE_22795_length_166_cov_1.188034_g18866_i0 | PRJNA554794 | 22795 | 166 | 1.188034 | 1.97213644 | Mytilus coruscus | 42192 | Mollusca | Mollusca | 67 | 2.96e-11 | NR | CAC5423815.1 | 42192 | g18866 | i0 | 63 | 0.975903614457831 | 54 | 20 | 97.6 | 0 | 162 | 1 | 195 | 248 | CAC5423815.1 RP-S12e [Mytilus coruscus] | diamond | 162 | 67 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus coruscus | |
| 31848204 | 31848204 | PRJNA554794_P_NODE_19917_length_203_cov_0.902597_g15988_i0 | PRJNA554794 | 19917 | 203 | 0.902597 | 1.83227191 | Liolophura japonica | 13599 | Mollusca | Mollusca | 84.7 | 3.56e-17 | NR | XP_064612079.1 | 13599 | g15988 | i0 | 59.7 | 3.14778325123153 | 72 | 24 | 99 | 2 | 201 | 1 | 414 | 485 | XP_064612079.1 major vault protein-like [Liolophura japonica] | diamond | 639 | 84.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Polyplacophora | Chitonida | Chitonidae | Liolophura | Liolophura japonica | |
| 32354784 | 32354784 | PRJNA554794_P_NODE_8019_length_568_cov_1.242775_g4406_i0 | PRJNA554794 | 8019 | 568 | 1.242775 | 7.058962 | Mya arenaria | 6604 | Mollusca | Mollusca | 47.4 | 0.0158 | NR | XP_052759840.1 | 6604 | g4406 | i0 | 30 | 0.792253521126761 | 150 | 73 | 75 | 8 | 511 | 86 | 54 | 179 | XP_052759840.1 integumentary mucin C.1-like [Mya arenaria] | diamond | 450 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Myidae | Mya | Mya arenaria |
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);;