RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA682078" and tax_phylum = "Heterolobosea"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Heterolobosea · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA682078 · 4 ✖

analysis 1

  • diamond · 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
4485904 4485904 PRJNA682078_P_NODE_116184_length_330_cov_1.159533_g114407_i0 PRJNA682078 116184 330 1.159533 3.8264589 Acrasis kona 1008807 Heterolobosea other_Eukaryota 163 9.839999999999999e-48   NR KAL0483758.1 1008807 g114407 i0 77.3 1 110 25 100 0 330 1 112 221 KAL0483758.1 ribosomal protein L7 [Acrasis kona] diamond 330 163 1 Eukaryota Discoba   Heterolobosea     Acrasidae Acrasis Acrasis kona
27144896 27144896 PRJNA682078_P_NODE_288462_length_241_cov_0.916667_g286685_i0 PRJNA682078 288462 241 0.916667 2.20916747 Acrasis kona 1008807 Heterolobosea other_Eukaryota 143 8e-40   NR KAL0483913.1 1008807 g286685 i0 83.8 0.995850622406639 80 13 99.6 0 240 1 82 161 KAL0483913.1 ribosomal protein P0 [Acrasis kona] diamond 240 143 1 Eukaryota Discoba   Heterolobosea     Acrasidae Acrasis Acrasis kona
28850313 28850313 PRJNA682078_P_NODE_135408_length_309_cov_0.834746_g133631_i0 PRJNA682078 135408 309 0.834746 2.57936514 Acrasis kona 1008807 Heterolobosea other_Eukaryota 129 2.1399999999999998e-32   NR KAL0484804.1 1008807 g133631 i0 58.4 0.980582524271845 101 42 98.1 0 4 306 438 538 KAL0484804.1 ctnA [Acrasis kona] diamond 303 129 1 Eukaryota Discoba   Heterolobosea     Acrasidae Acrasis Acrasis kona
30915396 30915396 PRJNA682078_P_NODE_270494_length_244_cov_0.900585_g268717_i0 PRJNA682078 270494 244 0.900585 2.1974274 Eukaryota 2759 unresolved_Eukaryota other_Eukaryota 74.3 2.56e-13   NR KAL0484001.1 1008807 g268717 i0 61.2 5.10245901639344 49 19 60.2 0 242 96 384 432 KAL0484001.1 ift46 [Acrasis kona] diamond 1245 74.3 1 Eukaryota Discoba   Heterolobosea     Acrasidae Acrasis Acrasis kona

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