contig_metadata
8 rows where bioproject = "PRJNA1197996", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9251958 | 9251958 | PRJNA1197996_S_NODE_21288_length_261_cov_1.090426_g21234_i0 | PRJNA1197996 | 21288 | 261 | 1.090426 | 2.84601186 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|2707353551|ref|XM_064096426.1| | 7653 | g21234 | i0 | 100 | 0.111111111111111 | 29 | 0 | 11 | 0 | 21 | 49 | 7293 | 7265 | PREDICTED: Lytechinus pictus serine/threonine-protein kinase DCLK1-like (LOC129257791), mRNA | blastn | 29 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 16901089 | 16901089 | PRJNA1197996_S_NODE_18254_length_275_cov_2.420792_g18200_i0 | PRJNA1197996 | 18254 | 275 | 2.420792 | 6.657178 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 80.9 | 1.92e-15 | NR | XP_041459307.1 | 7654 | g18200 | i0 | 80.5 | 5.19272727272727 | 41 | 8 | 44.7 | 0 | 17 | 139 | 420 | 460 | XP_041459307.1 dipeptidyl peptidase 1-like isoform X1 [Lytechinus variegatus] | diamond | 1428 | 81.3 | 0.995079950799508 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 26882842 | 26882842 | PRJNA1197996_S_NODE_19901_length_267_cov_1.314433_g19847_i0 | PRJNA1197996 | 19901 | 267 | 1.314433 | 3.50953611 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 49.7 | 1.72e-4 | NR | KAJ8032961.1 | 206669 | g19847 | i0 | 50 | 0.471910112359551 | 42 | 21 | 47.2 | 0 | 8 | 133 | 388 | 429 | KAJ8032961.1 Peroxisomal biogenesis factor 3 [Holothuria leucospilota] | diamond | 126 | 49.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 27439365 | 27439365 | PRJNA1197996_S_NODE_19203_length_270_cov_2.487310_g19149_i0 | PRJNA1197996 | 19203 | 270 | 2.48731 | 6.715737 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 70.9 | 3.57e-13 | NR | XP_041460635.1 | 7654 | g19149 | i0 | 66 | 7.2 | 53 | 18 | 58.9 | 0 | 268 | 110 | 66 | 118 | XP_041460635.1 mitochondrial import inner membrane translocase subunit Tim16-like [Lytechinus variegatus] | diamond | 1944 | 71.6 | 0.990223463687151 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28828185 | 28828185 | PRJNA1197996_S_NODE_6288_length_386_cov_1.575080_g6234_i0 | PRJNA1197996 | 6288 | 386 | 1.57508 | 6.0798088 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 106 | 1.59e-25 | NR | XP_041469677.1 | 7654 | g6234 | i0 | 60.9 | 5.84455958549223 | 92 | 28 | 65.3 | 1 | 370 | 119 | 134 | 225 | XP_041469677.1 N-alpha-acetyltransferase 40-like [Lytechinus variegatus] | diamond | 2256 | 107 | 0.990654205607477 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 30628340 | 30628340 | PRJNA1197996_S_NODE_13213_length_306_cov_1.214592_g13159_i0 | PRJNA1197996 | 13213 | 306 | 1.214592 | 3.71665152 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 52.8 | 5.68e-6 | NR | XP_796206.2 | 7668 | g13159 | i0 | 45.6 | 3.97058823529412 | 68 | 35 | 66.7 | 1 | 5 | 208 | 79 | 144 | XP_796206.2 baculoviral IAP repeat-containing protein 5 [Strongylocentrotus purpuratus] | diamond | 1215 | 53.1 | 0.994350282485876 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Camarodonta | Strongylocentrotidae | Strongylocentrotus | Strongylocentrotus purpuratus | |
| 31450400 | 31450400 | PRJNA1197996_S_NODE_18056_length_276_cov_3.044335_g18002_i0 | PRJNA1197996 | 18056 | 276 | 3.044335 | 8.4023646 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 91.3 | 6.4400000000000006e-21 | NR | XP_071478621.1 | 105358 | g18002 | i0 | 56.5 | 5.47826086956522 | 85 | 37 | 92.4 | 0 | 272 | 18 | 49 | 133 | XP_071478621.1 mitochondrial import inner membrane translocase subunit Tim16-like [Diadema antillarum] | diamond | 1512 | 91.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 32317473 | 32317473 | PRJNA1197996_S_NODE_27739_length_243_cov_0.811765_g27685_i0 | PRJNA1197996 | 27739 | 243 | 0.811765 | 1.97258895 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 106 | 1.2e-24 | NR | XP_038046795.1 | 46514 | g27685 | i0 | 60.5 | 1.87654320987654 | 76 | 30 | 93.8 | 0 | 232 | 5 | 599 | 674 | XP_038046795.1 uncharacterized protein LOC119721003 [Patiria miniata] | diamond | 456 | 106 | 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);;