contig_metadata
12 rows where bioproject = "PRJNA575566", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9488257 | 9488257 | PRJNA575566_P_NODE_11888_length_304_cov_1.580247_g11691_i0 | PRJNA575566 | 11888 | 304 | 1.580247 | 4.80395088 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2912999747|dbj|AP039606.1| | 145626 | g11691 | i0 | 100 | 0.5 | 30 | 0 | 10 | 0 | 169 | 198 | 31243483 | 31243454 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 25, sequence | blastn | 152 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 10764351 | 10764351 | PRJNA575566_P_NODE_24229_length_209_cov_0.864865_g24032_i0 | PRJNA575566 | 24229 | 209 | 0.864865 | 1.80756785 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 52.8 | 0.018 | NTclustered | gi|2912985489|dbj|AP039590.1| | 145626 | g24032 | i0 | 100 | 0.133971291866029 | 28 | 0 | 13 | 0 | 161 | 188 | 68813022 | 68812995 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 9, sequence | blastn | 28 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 12039076 | 12039076 | PRJNA575566_P_NODE_17370_length_253_cov_1.000000_g17173_i0 | PRJNA575566 | 17370 | 253 | 1 | 2.53 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 73.1 | 1.76e-8 | NTclustered | gi|2912996298|dbj|AP039601.1| | 145626 | g17173 | i0 | 90.741 | 6.01185770750988 | 54 | 5 | 21 | 0 | 1 | 54 | 21546789 | 21546736 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 20, sequence | blastn | 1521 | 73.1 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 14589007 | 14589007 | PRJNA575566_P_NODE_29272_length_202_cov_0.907801_g29075_i0 | PRJNA575566 | 29272 | 202 | 0.907801 | 1.83375802 | Ostrea edulis | 37623 | Mollusca | Mollusca | 58.4 | 3.78e-4 | NTclustered | gi|2507420029|ref|XM_048885337.2| | 37623 | g29075 | i0 | 94.595 | 1.87128712871287 | 37 | 2 | 18 | 0 | 160 | 196 | 278 | 242 | PREDICTED: Ostrea edulis diencephalon/mesencephalon homeobox protein 1-like (LOC125655165), mRNA | blastn | 378 | 58.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Ostrea | Ostrea edulis | |
| 19686379 | 19686379 | PRJNA575566_P_NODE_10576_length_321_cov_2.192308_g10379_i0 | PRJNA575566 | 10576 | 321 | 2.192308 | 7.03730868 | Mytilus californianus | 6549 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2334761577|ref|XM_052209329.1| | 6549 | g10379 | i0 | 100 | 3.65732087227414 | 30 | 0 | 9 | 0 | 230 | 259 | 980 | 1009 | PREDICTED: Mytilus californianus uncharacterized LOC127705057 (LOC127705057), transcript variant X3, mRNA | blastn | 1174 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus californianus | |
| 22236935 | 22236935 | PRJNA575566_P_NODE_11298_length_311_cov_3.084000_g11101_i0 | PRJNA575566 | 11298 | 311 | 3.084 | 9.59124 | Bradybaena similaris | 145626 | Mollusca | Mollusca | 54.7 | 0.008 | NTclustered | gi|2912989933|dbj|AP039594.1| | 145626 | g11101 | i0 | 100 | 0.0932475884244373 | 29 | 0 | 9 | 0 | 118 | 146 | 61918646 | 61918618 | Bradybaena similaris mixture of YIPCMo001421 and YIPCMo001540 DNA, chromosome 13, sequence | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Camaenidae | Bradybaena | Bradybaena similaris | |
| 28072168 | 28072168 | PRJNA575566_P_NODE_22785_length_217_cov_1.057692_g22588_i0 | PRJNA575566 | 22785 | 217 | 1.057692 | 2.29519164 | Opisthokonta | 33154 | Mollusca | Mollusca | 82 | 1.28e-16 | NR | XP_050405502.1 | 6465 | g22588 | i0 | 68.5 | 35.7096774193548 | 54 | 17 | 74.7 | 0 | 217 | 56 | 239 | 292 | XP_050405502.1 ATP-binding cassette sub-family C member 10 isoform X3 [Patella vulgata] | diamond | 7749 | 82.8 | 0.990338164251208 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Patellidae | Patella | Patella vulgata | ||
| 28482727 | 28482727 | PRJNA575566_P_NODE_17266_length_254_cov_0.917098_g17069_i0 | PRJNA575566 | 17266 | 254 | 0.917098 | 2.32942892 | root | 1 | Root_unresolved | Root_unresolved | 90.1 | 9.29e-19 | NR | XP_069108024.1 | 31199 | g17069 | i0 | 46.4 | 12.5433070866142 | 84 | 45 | 99.2 | 0 | 1 | 252 | 1137 | 1220 | XP_069108024.1 LOW QUALITY PROTEIN: xanthine dehydrogenase/oxidase-like [Argopecten irradians] | diamond | 3186 | 90.9 | 0.991199119911991 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Pectinida | Pectinidae | Argopecten | Argopecten irradians | |
| 29321548 | 29321548 | PRJNA575566_P_NODE_29769_length_201_cov_0.914286_g29572_i0 | PRJNA575566 | 29769 | 201 | 0.914286 | 1.83771486 | Elysia chlorotica | 188477 | Mollusca | Mollusca | 46.2 | 0.00128 | NR | RUS75705.1 | 188477 | g29572 | i0 | 43.9 | 2.76119402985075 | 57 | 26 | 76.1 | 2 | 160 | 8 | 376 | 432 | RUS75705.1 hypothetical protein EGW08_016520 [Elysia chlorotica] | diamond | 555 | 46.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Plakobranchidae | Elysia | Elysia chlorotica | ||
| 29700122 | 29700122 | PRJNA575566_P_NODE_24950_length_208_cov_0.870748_g24753_i0 | PRJNA575566 | 24950 | 208 | 0.870748 | 1.81115584 | Gigantopelta aegis | 1735272 | Mollusca | Mollusca | 76.3 | 3.53e-14 | NR | XP_041350101.1 | 1735272 | g24753 | i0 | 57.4 | 1.96153846153846 | 68 | 27 | 98.1 | 1 | 206 | 3 | 462 | 527 | XP_041350101.1 endoplasmin-like [Gigantopelta aegis] | diamond | 408 | 76.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Neomphalida | Peltospiridae | Gigantopelta | Gigantopelta aegis | |
| 30219463 | 30219463 | PRJNA575566_P_NODE_28912_length_202_cov_0.907801_g28715_i0 | PRJNA575566 | 28912 | 202 | 0.907801 | 1.83375802 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 98.6 | 4.61e-22 | NR | KAH9496274.1 | 55810 | g28715 | i0 | 70.8 | 2.91089108910891 | 65 | 18 | 96.5 | 1 | 6 | 200 | 507 | 570 | KAH9496274.1 hypothetical protein Btru_017966 [Bulinus truncatus] | diamond | 588 | 99.4 | 0.991951710261569 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Bulinus | Bulinus truncatus | ||
| 32685088 | 32685088 | PRJNA575566_P_NODE_22300_length_220_cov_1.207547_g22103_i0 | PRJNA575566 | 22300 | 220 | 1.207547 | 2.6566034 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 44.3 | 0.00811 | NR | XP_022324270.1 | 6565 | g22103 | i0 | 42.9 | 2.60454545454545 | 49 | 22 | 58.6 | 1 | 26 | 154 | 384 | 432 | XP_022324270.1 von Willebrand factor D and EGF domain-containing protein-like isoform X4 [Crassostrea virginica] | diamond | 573 | 44.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Ostreida | Ostreidae | Crassostrea | Crassostrea virginica |
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);;