contig_metadata
6 rows where bioproject = "PRJNA951810", tax_kingdom = "Metazoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2210714 | 2210714 | PRJNA951810_P_NODE_105422_length_289_cov_9.731481_g105078_i0 | PRJNA951810 | 105422 | 289 | 9.731481 | 28.12398009 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 67.6 | 9.55e-7 | NTclustered | gi|1944934410|ref|XM_038222831.1| | 46514 | g105078 | i0 | 97.436 | 2.30103806228374 | 39 | 1 | 13 | 0 | 12 | 50 | 691 | 729 | PREDICTED: Patiria miniata serine-aspartate repeat-containing protein F-like (LOC119746059), transcript variant X2, mRNA | blastn | 665 | 67.6 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 14964236 | 14964236 | PRJNA951810_P_NODE_16452_length_481_cov_6.107843_g16119_i0 | PRJNA951810 | 16452 | 481 | 6.107843 | 29.37872483 | Lytechinus pictus | 7653 | Echinodermata | other_Eukaryota | 54.7 | 0.013 | NTclustered | gi|2707400646|ref|XM_064113069.1| | 7653 | g16119 | i0 | 100 | 0.361746361746362 | 29 | 0 | 6 | 0 | 383 | 411 | 6246 | 6274 | PREDICTED: Lytechinus pictus zinc finger MIZ domain-containing protein 1-like (LOC129281907), transcript variant X3, mRNA | blastn | 174 | 54.7 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus pictus | |
| 21338007 | 21338007 | PRJNA951810_P_NODE_135577_length_269_cov_2.443878_g135232_i0 | PRJNA951810 | 135577 | 269 | 2.443878 | 6.57403182 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 120 | 4.11e-30 | NR | XP_041474081.1 | 7654 | g135232 | i0 | 77.3 | 2.94423791821561 | 66 | 15 | 73.6 | 0 | 268 | 71 | 19 | 84 | XP_041474081.1 ethanolamine-phosphate cytidylyltransferase-like isoform X1 [Lytechinus variegatus] | diamond | 792 | 120 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28320498 | 28320498 | PRJNA951810_P_NODE_129766_length_273_cov_3.690000_g129421_i0 | PRJNA951810 | 129766 | 273 | 3.69 | 10.0737 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 54.3 | 4.72e-6 | NR | XP_041478245.1 | 7654 | g129421 | i0 | 33.7 | 2.74725274725275 | 83 | 49 | 89 | 3 | 249 | 7 | 27 | 105 | XP_041478245.1 mediator of RNA polymerase II transcription subunit 16-like [Lytechinus variegatus] | diamond | 750 | 54.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus | |
| 28668004 | 28668004 | PRJNA951810_P_NODE_127127_length_275_cov_2.925743_g126782_i0 | PRJNA951810 | 127127 | 275 | 2.925743 | 8.04579325 | Anneissia japonica | 1529436 | Echinodermata | other_Eukaryota | 73.2 | 1.04e-12 | NR | XP_033116011.1 | 1529436 | g126782 | i0 | 38.5 | 0.992727272727273 | 91 | 23 | 99.3 | 1 | 3 | 275 | 237 | 294 | XP_033116011.1 aromatic-L-amino-acid decarboxylase-like [Anneissia japonica] | diamond | 273 | 73.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Crinoidea | Comatulida | Comatulidae | Anneissia | Anneissia japonica | |
| 28952225 | 28952225 | PRJNA951810_P_NODE_103468_length_291_cov_2.408257_g103124_i0 | PRJNA951810 | 103468 | 291 | 2.408257 | 7.00802787 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 109 | 2.65e-25 | NR | XP_022092320.1 | 133434 | g103124 | i0 | 53.6 | 3.97938144329897 | 97 | 42 | 99 | 2 | 290 | 3 | 1058 | 1152 | XP_022092320.1 regulatory-associated protein of mTOR-like isoform X4 [Acanthaster planci] | diamond | 1158 | 109 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Acanthasteridae | Acanthaster | Acanthaster planci |
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);;