contig_metadata
4 rows where bioproject = "PRJNA861969" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4675077 | 4675077 | PRJNA861969_P_NODE_41124_length_241_cov_1.833333_g40893_i0 | PRJNA861969 | 41124 | 241 | 1.833333 | 4.41833253 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 137 | 5.82e-28 | NTclustered | gi|2427250420|ref|XR_008264569.1| | 37653 | g40893 | i0 | 90.476 | 0.435684647302905 | 105 | 8 | 44 | 1 | 135 | 239 | 477 | 375 | PREDICTED: Octopus bimaculoides uncharacterized LOC128248331 (LOC128248331), ncRNA | blastn | 105 | 137 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 11050287 | 11050287 | PRJNA861969_P_NODE_40489_length_242_cov_0.911243_g40258_i0 | PRJNA861969 | 40489 | 242 | 0.911243 | 2.20520806 | Octopus bimaculoides | 37653 | Mollusca | Mollusca | 180 | 9.58e-41 | NTclustered | gi|2427301565|ref|XM_052978171.1| | 37653 | g40258 | i0 | 87.578 | 73.5702479338843 | 161 | 13 | 64 | 2 | 1 | 154 | 3006 | 3166 | PREDICTED: Octopus bimaculoides gamma-aminobutyric acid receptor alpha-like (LOC106883576), transcript variant X1, mRNA | blastn | 17804 | 180 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus bimaculoides | |
| 17424395 | 17424395 | PRJNA861969_P_NODE_22694_length_286_cov_1.441315_g22463_i0 | PRJNA861969 | 22694 | 286 | 1.441315 | 4.1221609 | Octopus sinensis | 2607531 | Mollusca | Mollusca | 165 | 3.25e-36 | NTclustered | gi|1914620485|ref|XR_005001674.1| | 2607531 | g22463 | i0 | 85.987 | 6.49300699300699 | 157 | 18 | 55 | 4 | 61 | 216 | 12 | 165 | PREDICTED: Octopus sinensis uncharacterized LOC118765793 (LOC118765793), ncRNA | blastn | 1857 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Cephalopoda | Octopoda | Octopodidae | Octopus | Octopus sinensis | |
| 25072756 | 25072756 | PRJNA861969_P_NODE_460_length_2318_cov_33.125167_g376_i0 | PRJNA861969 | 460 | 2318 | 33.125167 | 767.84137106 | Metazoa | 33208 | Mollusca | Mollusca | 725 | 2.0599999999999996e-252 | NR | XP_013082114.1 | 6526 | g376 | i0 | 62.6 | 182.843399482312 | 594 | 204 | 74.7 | 2 | 20 | 1750 | 7 | 599 | XP_013082114.1 heat shock 70 kDa protein cognate 4 [Biomphalaria glabrata] | diamond | 423831 | 731 | 0.991792065663475 | Eukaryota | Opisthokonta | Metazoa | Mollusca | Gastropoda | Planorbidae | Biomphalaria | Biomphalaria glabrata |
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);;