contig_metadata
6 rows where bioproject = "PRJNA857857", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 8497649 | 8497649 | PRJNA857857_P_NODE_17367_length_377_cov_0.967105_g16920_i0 | PRJNA857857 | 17367 | 377 | 0.967105 | 3.64598585 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 195 | 5.78e-56 | NR | XP_006820993.1 | 10224 | g16920 | i0 | 75.4 | 10.8381962864721 | 122 | 30 | 97.1 | 0 | 4 | 369 | 307 | 428 | XP_006820993.1 PREDICTED: ubiquitin-like modifier-activating enzyme ATG7-like [Saccoglossus kowalevskii] | diamond | 4086 | 196 | 0.994897959183674 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 17422776 | 17422776 | PRJNA857857_P_NODE_1054_length_1339_cov_4.884676_g852_i0 | PRJNA857857 | 1054 | 1339 | 4.884676 | 65.40581164 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 558 | 2.76e-195 | NR | XP_070579664.1 | 63121 | g852 | i0 | 68.6 | 49.4451082897685 | 392 | 121 | 87.4 | 1 | 1269 | 100 | 38 | 429 | XP_070579664.1 LOW QUALITY PROTEIN: large ribosomal subunit protein uL3-like [Ptychodera flava] | diamond | 66207 | 560 | 0.996428571428571 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 26873717 | 26873717 | PRJNA857857_P_NODE_34281_length_261_cov_1.079787_g33832_i0 | PRJNA857857 | 34281 | 261 | 1.079787 | 2.81824407 | Hemichordata | 10219 | Hemichordata | other_Eukaryota | 64.7 | 8.57e-10 | NR | XP_070541008.1 | 63121 | g33832 | i0 | 42.9 | 5.49425287356322 | 70 | 37 | 77 | 2 | 55 | 255 | 373 | 442 | XP_070541008.1 alpha-1,6-mannosyl-glycoprotein 2-beta-N-acetylglucosaminyltransferase-like [Ptychodera flava] | diamond | 1434 | 64.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Ptychoderidae | Ptychodera | Ptychodera flava | ||
| 27497542 | 27497542 | PRJNA857857_P_NODE_14983_length_406_cov_1.849850_g14536_i0 | PRJNA857857 | 14983 | 406 | 1.84985 | 7.510391 | Saccoglossus kowalevskii | 10224 | Hemichordata | other_Eukaryota | 46.6 | 0.00211 | NR | XP_006821294.1 | 10224 | g14536 | i0 | 66.7 | 0.266009852216749 | 36 | 12 | 26.6 | 0 | 295 | 402 | 64 | 99 | XP_006821294.1 PREDICTED: 60S ribosomal protein L35-like [Saccoglossus kowalevskii] | diamond | 108 | 46.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 28863197 | 28863197 | PRJNA857857_P_NODE_3188_length_847_cov_4.797158_g2836_i0 | PRJNA857857 | 3188 | 847 | 4.797158 | 40.63192826 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 266 | 1.23e-85 | NR | XP_002735960.1 | 10224 | g2836 | i0 | 61.1 | 17.7839433293979 | 239 | 85 | 83.2 | 3 | 106 | 810 | 11 | 245 | XP_002735960.1 PREDICTED: 60S ribosomal protein L7-like [Saccoglossus kowalevskii] | diamond | 15063 | 267 | 0.99625468164794 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii | ||
| 30094698 | 30094698 | PRJNA857857_P_NODE_6012_length_634_cov_2.217469_g5594_i0 | PRJNA857857 | 6012 | 634 | 2.217469 | 14.05875346 | Metazoa | 33208 | Hemichordata | other_Eukaryota | 151 | 1.3e-42 | NR | XP_002738940.1 | 10224 | g5594 | i0 | 56.2 | 9.92744479495268 | 162 | 56 | 72.4 | 5 | 41 | 499 | 2 | 157 | XP_002738940.1 PREDICTED: 40S ribosomal protein S10-like [Saccoglossus kowalevskii] | diamond | 6294 | 151 | 1 | Eukaryota | Opisthokonta | Metazoa | Hemichordata | Enteropneusta | Harrimaniidae | Saccoglossus | Saccoglossus kowalevskii |
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);;