contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA781196" and tax_phylum = "Euglenozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 759138 | 759138 | PRJNA781196_P_NODE_29561_length_322_cov_1.253012_g29184_i0 | PRJNA781196 | 29561 | 322 | 1.253012 | 4.03469864 | Bodo saltans | 75058 | Euglenozoa | other_Eukaryota | 568 | 2.4299999999999993e-157 | NTclustered | gi|77994631|gb|DQ207569.1| | 75058 | g29184 | i0 | 98.447 | 100.217391304348 | 322 | 5 | 100 | 0 | 1 | 322 | 920 | 1241 | Bodo saltans strain HFCC12 18S ribosomal RNA gene, partial sequence | blastn | 32270 | 568 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Eubodonida | Bodonidae | Bodo | Bodo saltans | ||
| 8864266 | 8864266 | PRJNA781196_P_NODE_16827_length_405_cov_2.114458_g16450_i0 | PRJNA781196 | 16827 | 405 | 2.114458 | 8.5635549 | Leptomonas | 5683 | Euglenozoa | other_Eukaryota | 329 | 1.5999999999999996e-85 | NTclustered | gi|1002432462|ref|XM_015809846.1| | 157538 | g16450 | i0 | 82.278 | 102.264197530864 | 395 | 56 | 95 | 12 | 21 | 405 | 835 | 445 | Leptomonas pyrrhocoris elongation factor 1-alpha mRNA | blastn | 41417 | 329 | 1 | Eukaryota | Discoba | Euglenozoa | Kinetoplastea | Trypanosomatida | Trypanosomatidae | Leptomonas | Leptomonas pyrrhocoris | ||
| 10963780 | 10963780 | PRJNA781196_P_NODE_6049_length_631_cov_1.543011_g5680_i0 | PRJNA781196 | 6049 | 631 | 1.543011 | 9.73639941 | Euglena hiemalis | 392896 | Euglenozoa | other_Eukaryota | 569 | 1.3999999999999997e-157 | NTclustered | gi|1109178390|gb|KU375784.1| | 392896 | g5680 | i0 | 83.123 | 74.70206022187 | 634 | 97 | 99 | 10 | 1 | 629 | 754 | 1382 | Euglena hiemalis plastid glutamate 1-semialdehyde 2,1-aminotransferase mRNA, partial cds; nuclear gene for plastid product | blastn | 47137 | 569 | 1 | Eukaryota | Discoba | Euglenozoa | Euglenida | Euglenales | Euglenaceae | Euglena | Euglena hiemalis |
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);;