RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA533114" and tax_phylum = "Tubulinea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Tubulinea · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA533114 · 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
504908 504908 PRJNA533114_P_NODE_25381_length_451_cov_2.441799_g25131_i0 PRJNA533114 25381 451 2.441799 11.01251349 Copromyxa protea 931554 Tubulinea other_Eukaryota 507 7.76e-139   NTclustered gi|508737347|dbj|AB766053.1| 931554 g25131 i0 88.056 21.5410199556541 427 51 95 0 1 427 427 1 Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 blastn 9715 507 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Hartmannellidae Copromyxa Copromyxa protea
5609264 5609264 PRJNA533114_P_NODE_7445_length_816_cov_3.896366_g7247_i0 PRJNA533114 7445 816 3.896366 31.79434656 Amoeba proteus 5775 Tubulinea other_Eukaryota 826 0   NTclustered gi|844573744|gb|KP411223.1| 5775 g7247 i0 85.272 0.990196078431373 808 112 98 4 11 813 14 819 Amoeba proteus Tom40 mRNA, complete cds blastn 808 826 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Amoebidae Amoeba Amoeba proteus
6883233 6883233 PRJNA533114_P_NODE_83806_length_265_cov_1.630208_g83554_i0 PRJNA533114 83806 265 1.630208 4.3200512 Copromyxa protea 931554 Tubulinea other_Eukaryota 191 4.92e-44   NTclustered gi|508737347|dbj|AB766053.1| 931554 g83554 i0 80 1 265 47 99 5 4 265 648 387 Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 blastn 265 191 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Hartmannellidae Copromyxa Copromyxa protea
13258754 13258754 PRJNA533114_P_NODE_33471_length_397_cov_1.154321_g33219_i0 PRJNA533114 33471 397 1.154321 4.58265437 Copromyxa protea 931554 Tubulinea other_Eukaryota 394 5.48e-105   NTclustered gi|508737347|dbj|AB766053.1| 931554 g33219 i0 87.246 0.869017632241814 345 44 87 0 1 345 1045 1389 Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 blastn 345 394 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Hartmannellidae Copromyxa Copromyxa protea

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