RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA453567" and tax_phylum = "Evosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Evosea · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA453567 · 4 ✖

analysis 1

  • blastn · 4 ✖

tax_kingdom 0

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
5545649 5545649 PRJNA453567_P_NODE_8905_length_321_cov_2.028169_g8668_i0 PRJNA453567 8905 321 2.028169 6.51042249 Acytostelium subglobosum 361139 Evosea other_Eukaryota 63.9 1.39e-5   NTclustered gi|831768278|ref|XM_012896900.1| 1410327 g8668 i0 97.297 5.26168224299065 37 1 12 0 73 109 243 279 Acytostelium subglobosum LB1 hypothetical protein partial mRNA blastn 1689 63.9 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Acytosteliales Acytosteliaceae Acytostelium Acytostelium subglobosum
6819573 6819573 PRJNA453567_P_NODE_32726_length_153_cov_1.663793_g32489_i0 PRJNA453567 32726 153 1.663793 2.54560329 Heterostelium album 2086695 Evosea other_Eukaryota 178 1.98e-40   NTclustered gi|1160553732|ref|XM_020572691.1| 670386 g32489 i0 88.966 96.2091503267974 145 14 94 2 6 149 715 858 Polysphondylium pallidum PN500 elongation factor 1 alpha (efaAI), partial mRNA blastn 14720 178 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Acytosteliales Acytosteliaceae Heterostelium Heterostelium album
13195547 13195547 PRJNA453567_P_NODE_9011_length_319_cov_1.624113_g8774_i0 PRJNA453567 9011 319 1.624113 5.18092047 Dictyostelium discoideum 44689 Evosea other_Eukaryota 412 1.1899999999999997e-110   NTclustered gi|66821270|ref|XM_639040.1| 352472 g8774 i0 89.969 96.9717868338558 319 32 100 0 1 319 115 433 Dictyostelium discoideum AX4 hypothetical protein (act14) mRNA, complete cds blastn 30934 412 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Dictyosteliales Dictyosteliaceae Dictyostelium Dictyostelium discoideum
18293401 18293401 PRJNA453567_P_NODE_13775_length_246_cov_1.861244_g13538_i0 PRJNA453567 13775 246 1.861244 4.57866024 Acytostelium subglobosum 361139 Evosea other_Eukaryota 95.3 3.64e-15   NTclustered gi|831761070|ref|XM_012894692.1| 1410327 g13538 i0 87.654 3.71951219512195 81 10 33 0 16 96 399 319 Acytostelium subglobosum LB1 hypothetical protein partial mRNA blastn 915 95.3 1 Eukaryota Amoebozoa   Evosea Eumycetozoa Acytosteliales Acytosteliaceae Acytostelium Acytostelium subglobosum

Advanced export

JSON shape: default, array, newline-delimited

CSV options: 

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);;