RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA758087 · 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
10937535 10937535 PRJNA758087_P_NODE_29649_length_417_cov_2.133721_g28329_i0 PRJNA758087 29649 417 2.133721 8.89761657 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 129 1.28e-32   NR CAD8050985.1 5886 g28329 i0 53.4 1.82014388489209 133 52 89.2 5 386 15 1 132 CAD8050985.1 unnamed protein product [Paramecium primaurelia] diamond 759 129 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
27189039 27189039 PRJNA758087_P_NODE_20082_length_613_cov_2.988889_g18779_i0 PRJNA758087 20082 613 2.988889 18.32188957 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 49.3 0.00117   NR KAG2779018.1 29920 g18779 i0 52.1 0.807504078303426 48 13 18.6 2 478 591 101 148 KAG2779018.1 hypothetical protein PC112_g24999 [Phytophthora cactorum] diamond 495 49.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum
27621785 27621785 PRJNA758087_P_NODE_10664_length_977_cov_6.725664_g9576_i0 PRJNA758087 10664 977 6.725664 65.70973728 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 128 3.859999999999999e-31   NR XP_012656464.1 312017 g9576 i0 30.9 0.844421699078813 275 179 83.5 6 916 101 1 267 XP_012656464.1 golgi-to-ER traffic-like protein, putative [Tetrahymena thermophila SB210] diamond 825 128 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29673654 29673654 PRJNA758087_P_NODE_21590_length_575_cov_11.563745_g20276_i0 PRJNA758087 21590 575 11.563745 66.49153375 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 80.5 3.08e-14   NR XP_004039736.1 5932 g20276 i0 29.9 1.22086956521739 117 82 61 0 490 140 4 120 XP_004039736.1 hypothetical protein IMG5_011820 [Ichthyophthirius multifiliis] diamond 702 80.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis

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