contig_metadata
6 rows where bioproject = "PRJNA864829", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 19088383 | 19088383 | PRJNA864829_S_NODE_3315_length_305_cov_7.515625_g3229_i0 | PRJNA864829 | 3315 | 305 | 7.515625 | 22.92265625 | Gastropoda | 6448 | Mollusca | Mollusca | 115 | 3.58e-21 | NTclustered | gi|340763917|gb|JF509736.1| | 176853 | g3229 | i0 | 82.09 | 19.2360655737705 | 134 | 24 | 44 | 0 | 8 | 141 | 2478 | 2345 | Crepidula fornicata voucher AToL000306 28S ribosomal RNA gene, partial sequence | blastn | 5867 | 115 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Littorinimorpha | Calyptraeidae | Crepidula | Crepidula fornicata | |
| 21249453 | 21249453 | PRJNA864829_S_NODE_5777_length_250_cov_1.890547_g5691_i0 | PRJNA864829 | 5777 | 250 | 1.890547 | 4.7263675 | Anadara broughtonii | 148819 | Mollusca | Mollusca | 56.5 | 0.002 | NTclustered | gi|2170965484|dbj|LC593126.1| | 148819 | g5691 | i0 | 100 | 0.5 | 30 | 0 | 12 | 0 | 221 | 250 | 58 | 29 | Anadara broughtonii GnRH mRNA for gonadotropin releasing hormone, complete cds | blastn | 125 | 56.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Arcoida | Arcidae | Anadara | Anadara broughtonii | |
| 27055224 | 27055224 | PRJNA864829_S_NODE_2962_length_318_cov_2.368030_g2876_i0 | PRJNA864829 | 2962 | 318 | 2.36803 | 7.5303354 | Dreissena polymorpha | 45954 | Mollusca | Mollusca | 63.2 | 5.49e-9 | NR | KAH3860929.1 | 45954 | g2876 | i0 | 51.7 | 0.566037735849057 | 60 | 26 | 53.8 | 1 | 27 | 197 | 275 | 334 | KAH3860929.1 hypothetical protein DPMN_023853 [Dreissena polymorpha] | diamond | 180 | 63.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Myida | Dreissenidae | Dreissena | Dreissena polymorpha | |
| 27149515 | 27149515 | PRJNA864829_S_NODE_7882_length_220_cov_1.883041_g7796_i0 | PRJNA864829 | 7882 | 220 | 1.883041 | 4.1426902 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 50.4 | 3.97e-5 | NR | XP_029635009.1 | 2607531 | g7796 | i0 | 50 | 4.95 | 50 | 25 | 68.2 | 0 | 5 | 154 | 74 | 123 | XP_029635009.1 zinc finger BED domain-containing protein 5-like [Octopus sinensis] | diamond | 1089 | 50.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 30528974 | 30528974 | PRJNA864829_S_NODE_3333_length_305_cov_1.664062_g3247_i0 | PRJNA864829 | 3333 | 305 | 1.664062 | 5.0753891 | Candidula unifasciata | 100452 | Mollusca | Mollusca | 61.2 | 5.9e-9 | NR | CAG5129982.1 | 100452 | g3247 | i0 | 51.7 | 2.28196721311475 | 58 | 28 | 57 | 0 | 304 | 131 | 125 | 182 | CAG5129982.1 unnamed protein product [Candidula unifasciata] | diamond | 696 | 61.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Stylommatophora | Geomitridae | Candidula | Candidula unifasciata | |
| 31034902 | 31034902 | PRJNA864829_S_NODE_9715_length_201_cov_5.427632_g9629_i0 | PRJNA864829 | 9715 | 201 | 5.427632 | 10.90954032 | Mytilus edulis | 6550 | Mollusca | Mollusca | 43.9 | 0.00797 | NR | CAG2187267.1 | 6550 | g9629 | i0 | 47.7 | 1.40298507462687 | 44 | 22 | 64.2 | 1 | 66 | 194 | 192 | 235 | CAG2187267.1 unnamed protein product [Mytilus edulis] | diamond | 282 | 43.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Bivalvia | Mytilida | Mytilidae | Mytilus | Mytilus edulis |
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);;