contig_metadata
5 rows where bioproject = "PRJNA788929", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2489728 | 2489728 | PRJNA788929_P_NODE_32142_length_276_cov_24.330049_g31481_i0 | PRJNA788929 | 32142 | 276 | 24.330049 | 67.15093524 | Ophiuroidea | 7618 | Echinodermata | other_Eukaryota | 163 | 1.12e-35 | NTclustered | gi|84043343|gb|DQ297120.1| | 331101 | g31481 | i0 | 92.308 | 13.3333333333333 | 117 | 6 | 42 | 2 | 152 | 266 | 710 | 825 | Schizostella bifurcata 28S ribosomal RNA gene, partial sequence | blastn | 3680 | 163 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Ophiuroidea | Euryalida | Gorgonocephalidae | Schizostella | Schizostella bifurcata | |
| 12249224 | 12249224 | PRJNA788929_P_NODE_6270_length_769_cov_19.580460_g5654_i0 | PRJNA788929 | 6270 | 769 | 19.58046 | 150.5737374 | Diadema antillarum | 105358 | Echinodermata | other_Eukaryota | 60.2 | 4.61e-4 | NTclustered | gi|2919559042|ref|XM_071624162.1| | 105358 | g5654 | i0 | 94.872 | 0.35630689206762 | 39 | 0 | 5 | 2 | 369 | 406 | 4026 | 4063 | PREDICTED: Diadema antillarum uncharacterized protein (LOC139712323), partial mRNA | blastn | 274 | 60.2 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Diadematoida | Diadematidae | Diadema | Diadema antillarum | |
| 22446763 | 22446763 | PRJNA788929_P_NODE_37138_length_253_cov_15.177778_g36477_i0 | PRJNA788929 | 37138 | 253 | 15.177778 | 38.39977834 | Patiria miniata | 46514 | Echinodermata | other_Eukaryota | 52.8 | 0.023 | NTclustered | gi|1944904924|ref|XM_038209276.1| | 46514 | g36477 | i0 | 100 | 0.66403162055336 | 28 | 0 | 11 | 0 | 67 | 94 | 708 | 681 | PREDICTED: Patiria miniata fibropellin-1-like (LOC119735541), mRNA | blastn | 168 | 52.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28538265 | 28538265 | PRJNA788929_P_NODE_26227_length_311_cov_22.109244_g25566_i0 | PRJNA788929 | 26227 | 311 | 22.109244 | 68.75974884 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 55.5 | 2.85e-6 | NR | PIK56362.1 | 307972 | g25566 | i0 | 37.7 | 1.0225080385852101 | 106 | 41 | 81 | 4 | 8 | 259 | 725 | 827 | PIK56362.1 putative lysosomal alpha-mannosidase [Apostichopus japonicus] | diamond | 318 | 55.5 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 30243402 | 30243402 | PRJNA788929_P_NODE_3992_length_1027_cov_53.821803_g3514_i0 | PRJNA788929 | 3992 | 1027 | 53.821803 | 552.74991681 | Lytechinus variegatus | 7654 | Echinodermata | other_Eukaryota | 48.9 | 0.0259 | NR | XP_041473556.1 | 7654 | g3514 | i0 | 29.7 | 0.911392405063291 | 111 | 74 | 32.4 | 3 | 824 | 492 | 159 | 265 | XP_041473556.1 centrosomal protein 43-like isoform X1 [Lytechinus variegatus] | diamond | 936 | 48.9 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Echinoidea | Temnopleuroida | Toxopneustidae | Lytechinus | Lytechinus variegatus |
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);;