contig_metadata
7 rows where analysis = "diamond", bioproject = "PRJNA781453" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 26610187 | 26610187 | PRJNA781453_P_NODE_33241_length_250_cov_0.870056_g33126_i0 | PRJNA781453 | 33241 | 250 | 0.870056 | 2.17514 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 177 | 4.17e-52 | NR | PIK47469.1 | 307972 | g33126 | i0 | 100 | 0.984 | 82 | 0 | 98.4 | 0 | 248 | 3 | 38 | 119 | PIK47469.1 putative dipeptidyl peptidase 1 isoform X1 [Apostichopus japonicus] | diamond | 246 | 177 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 27527498 | 27527498 | PRJNA781453_P_NODE_39063_length_243_cov_0.905882_g38948_i0 | PRJNA781453 | 39063 | 243 | 0.905882 | 2.20129326 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 99 | 1.13e-23 | NR | PIK42515.1 | 307972 | g38948 | i0 | 100 | 1.23456790123457 | 50 | 0 | 61.7 | 0 | 152 | 3 | 1 | 50 | PIK42515.1 EF-hand domain family, member D2 [Apostichopus japonicus] | diamond | 300 | 99 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 29674259 | 29674259 | PRJNA781453_P_NODE_33790_length_249_cov_0.875000_g33675_i0 | PRJNA781453 | 33790 | 249 | 0.875 | 2.17875 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 167 | 8.569999999999999e-46 | NR | PIK62855.1 | 307972 | g33675 | i0 | 100 | 0.987951807228916 | 82 | 0 | 98.8 | 0 | 247 | 2 | 791 | 872 | PIK62855.1 putative twitchin [Apostichopus japonicus] | diamond | 246 | 167 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 31064906 | 31064906 | PRJNA781453_P_NODE_32415_length_251_cov_0.865169_g32300_i0 | PRJNA781453 | 32415 | 251 | 0.865169 | 2.17157419 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 165 | 1.61e-46 | NR | PIK40958.1 | 307972 | g32300 | i0 | 100 | 0.9800796812749 | 82 | 0 | 98 | 0 | 250 | 5 | 259 | 340 | PIK40958.1 putative steroid 17-alpha-hydroxylase/17,20 lyase [Apostichopus japonicus] | diamond | 246 | 165 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 31127460 | 31127460 | PRJNA781453_P_NODE_31815_length_251_cov_1.443820_g31700_i0 | PRJNA781453 | 31815 | 251 | 1.44382 | 3.6239882 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 87.8 | 1.57e-20 | NR | PIK50361.1 | 307972 | g31700 | i0 | 100 | 0.442231075697211 | 37 | 0 | 44.2 | 0 | 10 | 120 | 54 | 90 | PIK50361.1 hypothetical protein BSL78_12778 [Apostichopus japonicus] | diamond | 111 | 87.8 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 31190689 | 31190689 | PRJNA781453_P_NODE_40795_length_241_cov_0.916667_g40680_i0 | PRJNA781453 | 40795 | 241 | 0.916667 | 2.20916747 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 79.3 | 2.69e-15 | NR | PIK56157.1 | 307972 | g40680 | i0 | 96.9 | 0.398340248962656 | 32 | 1 | 39.8 | 0 | 241 | 146 | 307 | 338 | PIK56157.1 hypothetical protein BSL78_06943 [Apostichopus japonicus] | diamond | 96 | 79.3 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus | |
| 31507514 | 31507514 | PRJNA781453_P_NODE_33056_length_250_cov_0.870056_g32941_i0 | PRJNA781453 | 33056 | 250 | 0.870056 | 2.17514 | Apostichopus japonicus | 307972 | Echinodermata | other_Eukaryota | 178 | 7.79e-50 | NR | PIK44012.1 | 307972 | g32941 | i0 | 100 | 0.984 | 82 | 0 | 98.4 | 0 | 3 | 248 | 3365 | 3446 | PIK44012.1 hypothetical protein BSL78_19133 [Apostichopus japonicus] | diamond | 246 | 178 | 1 | Eukaryota | Opisthokonta | Metazoa | Echinodermata | Holothuroidea | Aspidochirotida | Stichopodidae | Apostichopus | Apostichopus japonicus |
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);;