contig_metadata
4 rows where bioproject = "PRJNA562549", tax_kingdom = "Metazoa" and tax_phylum = "Hemichordata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 545767 | 545767 | PRJNA562549_P_NODE_34641_length_205_cov_1.763889_g34408_i0 | PRJNA562549 | 34641 | 205 | 1.763889 | 3.61597245 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 75 | 3.82e-9 | NTclustered | gi|585689230|ref|XM_006820765.1| | 10224 | g34408 | i0 | 88.525 | 0.84390243902439 | 61 | 7 | 30 | 0 | 77 | 137 | 1902 | 1842 | PREDICTED: Saccoglossus kowalevskii isoleucine--tRNA ligase, cytoplasmic-like (LOC100369426), partial mRNA | blastn | 173 | 75 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 26952451 | 26952451 | PRJNA562549_P_NODE_36242_length_202_cov_1.773050_g36009_i0 | PRJNA562549 | 36242 | 202 | 1.77305 | 3.581561 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 94.7 | 1.08e-20 | NR | XP_002736376.1 | 10224 | g36009 | i0 | 62.1 | 1.9752475247524801 | 66 | 25 | 98 | 0 | 199 | 2 | 510 | 575 | XP_002736376.1 PREDICTED: E3 ubiquitin-protein ligase MIB2-like, partial [Saccoglossus kowalevskii] | diamond | 399 | 94.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 27124298 | 27124298 | PRJNA562549_P_NODE_25362_length_233_cov_1.511628_g25129_i0 | PRJNA562549 | 25362 | 233 | 1.511628 | 3.52209324 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 98.2 | 1.18e-22 | NR | XP_070531626.1 | 63121 | g25129 | i0 | 59.7 | 3.9656652360515 | 77 | 27 | 99.1 | 1 | 231 | 1 | 152 | 224 | XP_070531626.1 large ribosomal subunit protein uL18-like [Ptychodera flava] | diamond | 924 | 99 | 0.991919191919192 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 32134061 | 32134061 | PRJNA562549_P_NODE_23198_length_243_cov_1.456044_g22965_i0 | PRJNA562549 | 23198 | 243 | 1.456044 | 3.53818692 | Ptychodera flava | 63121 | Hemichordata | other_Eukaryota | 87.4 | 5.24e-20 | NR | XP_070578892.1 | 63121 | g22965 | i0 | 57.7 | 0.876543209876543 | 71 | 30 | 87.7 | 0 | 242 | 30 | 12 | 82 | XP_070578892.1 uncharacterized protein [Ptychodera flava] | diamond | 213 | 87.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava |
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);;