contig_metadata
6 rows where bioproject = "PRJNA897077", tax_clade = "Opisthokonta" and tax_phylum = "Echinodermata"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9801553 | 9801553 | PRJNA897077_P_NODE_3748_length_499_cov_2.596244_g3621_i0 | PRJNA897077 | 3748 | 499 | 2.596244 | 12.95525756 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 52.8 | 0.049 | NTclustered | gi|2707414840|ref|XM_064099171.1| | 7653 | g3621 | i0 | 100 | 0.336673346693387 | 28 | 0 | 6 | 0 | 119 | 146 | 1458 | 1485 | PREDICTED: Lytechinus pictus uncharacterized LOC129261136 (LOC129261136), transcript variant X2, mRNA | blastn | 168 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 26802460 | 26802460 | PRJNA897077_P_NODE_2641_length_590_cov_1.626692_g2514_i0 | PRJNA897077 | 2641 | 590 | 1.626692 | 9.5974828 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 160 | 2.38e-43 | NR | XP_022100478.1 | 133434 | g2514 | i0 | 53.1 | 2.90847457627119 | 143 | 66 | 72.7 | 1 | 431 | 3 | 126 | 267 | XP_022100478.1 alpha-1,3-mannosyl-glycoprotein 2-beta-N-acetylglucosaminyltransferase-like isoform X2 [Acanthaster planci] | diamond | 1716 | 160 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci | |
| 27845250 | 27845250 | PRJNA897077_P_NODE_13624_length_269_cov_1.591837_g13497_i0 | PRJNA897077 | 13624 | 269 | 1.591837 | 4.28204153 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 99.8 | 2.0600000000000001e-22 | NR | PIK35373.1 | 307972 | g13497 | i0 | 50 | 2.94423791821561 | 88 | 44 | 98.1 | 0 | 268 | 5 | 196 | 283 | PIK35373.1 putative histone acetyltransferase type B catalytic subunit [Apostichopus japonicus] | diamond | 792 | 99.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 28792476 | 28792476 | PRJNA897077_P_NODE_7787_length_350_cov_2.072202_g7660_i0 | PRJNA897077 | 7787 | 350 | 2.072202 | 7.252707 | Strongylocentrotus purpuratus | 7668 | Echinodermata | other_Eukaryota | 79.7 | 1.46e-14 | NR | XP_030848232.1 | 7668 | g7660 | i0 | 37.1 | 1.98857142857143 | 116 | 62 | 93.4 | 4 | 17 | 343 | 201 | 312 | XP_030848232.1 neurogenic locus Notch protein-like isoform X2 [Strongylocentrotus purpuratus] | diamond | 696 | 79.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 30624283 | 30624283 | PRJNA897077_P_NODE_8033_length_345_cov_1.279412_g7906_i0 | PRJNA897077 | 8033 | 345 | 1.279412 | 4.4139714 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 49.7 | 4.67e-4 | NR | XP_071505199.1 | 105358 | g7906 | i0 | 45.2 | 0.365217391304348 | 42 | 23 | 36.5 | 0 | 338 | 213 | 5789 | 5830 | XP_071505199.1 uncharacterized protein [Diadema antillarum] | diamond | 126 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32781426 | 32781426 | PRJNA897077_P_NODE_5280_length_424_cov_1.330484_g5153_i0 | PRJNA897077 | 5280 | 424 | 1.330484 | 5.64125216 | Valvatida | 41166 | Echinodermata | other_Eukaryota | 135 | 1.44e-33 | NR | XP_038055940.1 | 46514 | g5153 | i0 | 48.9 | 7.18867924528302 | 141 | 71 | 99.1 | 1 | 424 | 5 | 218 | 358 | XP_038055940.1 clustered mitochondria protein homolog [Patiria miniata] | diamond | 3048 | 135 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata |
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);;