RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA312899" 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

  • PRJNA312899 · 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
4892313 4892313 PRJNA312899_P_NODE_32144_length_323_cov_11.886861_g31702_i0 PRJNA312899 32144 323 11.886861 38.39456103 Hartmannellidae 5776 Tubulinea other_Eukaryota 592 1.4499999999999999e-164   NTclustered gi|11527309|gb|AF293902.1|AF293902 136464 g31702 i0 99.69 99.4365325077399 323 1 100 0 1 323 900 1222 Saccamoeba limax small subunit ribosomal RNA gene, complete sequence blastn 32118 597 0.991624790619765 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Hartmannellidae Saccamoeba Saccamoeba limax
11858399 11858399 PRJNA312899_P_NODE_53650_length_235_cov_3.290323_g53208_i0 PRJNA312899 53650 235 3.290323 7.73225905 Amoeba proteus 5775 Tubulinea other_Eukaryota 99 2.67e-16   NTclustered gi|173717|gb|M19222.1|AMPRRM 5775 g53208 i0 95.238 37.6212765957447 63 2 27 1 15 77 377 316 A.proteus 28S large subunit rRNA, 5' end blastn 8841 99 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Amoebidae Amoeba Amoeba proteus
21466025 21466025 PRJNA312899_P_NODE_10317_length_588_cov_64.215213_g9906_i0 PRJNA312899 10317 588 64.215213 377.58545244 Copromyxa 931553 Tubulinea other_Eukaryota 621 3.53e-173   NTclustered gi|313506263|gb|GU938869.1| 931554 g9906 i0 85.906 76.280612244898 596 68 100 13 1 588 544 1131 Copromyxa protea strain CF08-8-5 18S small subunit ribosomal RNA gene, partial sequence blastn 44853 621 1 Eukaryota Amoebozoa   Tubulinea Elardia Euamoebida Hartmannellidae Copromyxa Copromyxa protea
22056426 22056426 PRJNA312899_P_NODE_64198_length_207_cov_3.917722_g63756_i0 PRJNA312899 64198 207 3.917722 8.10968454 Cryptodifflugia operculata 1078836 Tubulinea other_Eukaryota 228 2.8e-55   NTclustered gi|2651357777|gb|PP174294.1| 1078836 g63756 i0 87.065 86.3526570048309 201 26 97 0 1 201 3586 3786 Cryptodifflugia operculata isolate 75 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 17875 228 1 Eukaryota Amoebozoa   Tubulinea Elardia Arcellinida Cryptodifflugiidae Cryptodifflugia Cryptodifflugia operculata

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