contig_metadata
5 rows where bioproject = "PRJNA576995", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6938888 | 6938888 | PRJNA576995_P_NODE_31986_length_267_cov_1.891753_g31394_i0 | PRJNA576995 | 31986 | 267 | 1.891753 | 5.05098051 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 139 | 1.7e-37 | NR | XP_038045153.1 | 46514 | g31394 | i0 | 73.3 | 24.3820224719101 | 86 | 23 | 96.6 | 0 | 8 | 265 | 188 | 273 | XP_038045153.1 guanine nucleotide-binding protein alpha-2 subunit-like [Patiria miniata] | diamond | 6510 | 139 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 7514810 | 7514810 | PRJNA576995_P_NODE_33466_length_258_cov_1.567568_g32874_i0 | PRJNA576995 | 33466 | 258 | 1.567568 | 4.04432544 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 108 | 1.77e-25 | NR | XP_033634036.1 | 7604 | g32874 | i0 | 57.6 | 4.91860465116279 | 85 | 36 | 98.8 | 0 | 2 | 256 | 354 | 438 | XP_033634036.1 protein disulfide-isomerase A3-like [Asterias rubens] | diamond | 1269 | 109 | 0.990825688073395 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Forcipulatida | Asteriidae | Asterias | Asterias rubens | |
| 27155979 | 27155979 | PRJNA576995_P_NODE_39822_length_245_cov_1.343023_g39230_i0 | PRJNA576995 | 39822 | 245 | 1.343023 | 3.29040635 | Metazoa | 33208 | Echinodermata | other_Eukaryota | 69.7 | 1.78e-12 | NR | XP_038068194.1 | 46514 | g39230 | i0 | 55.9 | 2.21632653061224 | 59 | 26 | 72.2 | 0 | 239 | 63 | 1 | 59 | XP_038068194.1 myophilin-like [Patiria miniata] | diamond | 543 | 70.1 | 0.994293865905849 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Asteroidea | Valvatida | Asterinidae | Patiria | Patiria miniata | |
| 28406087 | 28406087 | PRJNA576995_P_NODE_41806_length_243_cov_0.905882_g41214_i0 | PRJNA576995 | 41806 | 243 | 0.905882 | 2.20129326 | Holothuria leucospilota | 206669 | Echinodermata | other_Eukaryota | 47.4 | 8.42e-4 | NR | KAJ8033009.1 | 206669 | g41214 | i0 | 75 | 3.37037037037037 | 24 | 6 | 29.6 | 0 | 76 | 5 | 323 | 346 | KAJ8033009.1 Ornithine decarboxylase [Holothuria leucospilota] | diamond | 819 | 47.4 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Holothuriidae | Holothuria | Holothuria leucospilota | |
| 30269429 | 30269429 | PRJNA576995_P_NODE_42572_length_242_cov_0.911243_g41980_i0 | PRJNA576995 | 42572 | 242 | 0.911243 | 2.20520806 | Acanthaster planci | 133434 | Echinodermata | other_Eukaryota | 67.4 | 7.77e-11 | NR | XP_022100379.1 | 133434 | g41980 | i0 | 44 | 1.8595041322314 | 75 | 42 | 93 | 0 | 241 | 17 | 2042 | 2116 | XP_022100379.1 uncharacterized protein LOC110984469 isoform X1 [Acanthaster planci] | diamond | 450 | 67.4 | 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);;