RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA904835" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA904835 · 3 ✖

analysis 1

  • blastn · 3 ✖

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
14910595 14910595 PRJNA904835_P_NODE_23272_length_415_cov_0.801170_g23017_i0 PRJNA904835 23272 415 0.80117 3.3248555 Isotricha intestinalis 47897 SAR_Eukaryotes SAR_Eukaryotes 455 2.6000000000000003e-123   NTclustered gi|92790153|emb|AJ965262.1| 47897 g23017 i0 86.779 198.265060240964 416 46 99 9 5 414 538 126 Isotricha intestinalis partial mRNA for Polyubiqutin 2 (polyubiqutin 2 gene) blastn 82280 455 1 Eukaryota Sar   Ciliophora Litostomatea Vestibuliferida Isotrichidae Isotricha Isotricha intestinalis
19098972 19098972 PRJNA904835_P_NODE_52755_length_249_cov_0.875000_g52499_i0 PRJNA904835 52755 249 0.875 2.17875 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 58.4 4.84e-4   NTclustered gi|1843574570|ref|XM_034567210.1| 5823 g52499 i0 100 0.598393574297189 31 0 12 0 142 172 1787 1757 Plasmodium berghei ANKA zinc finger protein, putative (PBANKA_1357300), partial mRNA blastn 149 58.4 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium berghei
25109069 25109069 PRJNA904835_P_NODE_34940_length_327_cov_1.515748_g34684_i0 PRJNA904835 34940 327 1.515748 4.95649596 Oxytricha trifallax 1172189 SAR_Eukaryotes SAR_Eukaryotes 52.8 0.031   NTclustered gi|612176406|gb|KJ573500.1| 1172189 g34684 i0 100 0.0856269113149847 28 0 9 0 230 257 775 802 Oxytricha trifallax strain JRB310 TEBPalpha gene, complete sequence; micronuclear blastn 28 52.8 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Oxytricha Oxytricha trifallax

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