RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

5 rows where analysis = "diamond", bioproject = "PRJNA797655" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA797655 · 5 ✖

analysis 1

  • diamond · 5 ✖

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
27243516 27243516 PRJNA797655_S_NODE_104163_length_242_cov_1.788945_g103558_i0 PRJNA797655 104163 242 1.788945 4.3292469 Plasmodium ovale wallikeri 864142 SAR_Eukaryotes SAR_Eukaryotes 45.1 0.00541   NR SBT55413.1 864142 g103558 i0 54.2 0.59504132231405 48 22 59.5 0 2 145 324 371 SBT55413.1 PIR Superfamily Protein [Plasmodium ovale wallikeri] diamond 144 45.1 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium ovale
30022461 30022461 PRJNA797655_S_NODE_142931_length_211_cov_1.142857_g142326_i0 PRJNA797655 142931 211 1.142857 2.41142827 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0338   NR CAB9509238.1 568900 g142326 i0 35.4 0.682464454976303 48 31 68.2 0 43 186 50 97 CAB9509238.1 Coronin-1B [Seminavis robusta] diamond 144 42.4 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
30559199 30559199 PRJNA797655_S_NODE_169573_length_194_cov_2.125828_g168968_i0 PRJNA797655 169573 194 2.125828 4.12410632 Effrenium voratum 2562239 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0105   NR CAJ1345874.1 2562239 g168968 i0 44.4 0.695876288659794 45 25 69.6 0 2 136 106 150 CAJ1345874.1 unnamed protein product [Effrenium voratum] diamond 135 43.5 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Effrenium Effrenium voratum
30622475 30622475 PRJNA797655_S_NODE_186893_length_185_cov_1.683099_g186288_i0 PRJNA797655 186893 185 1.683099 3.11373315 Nothophytophthora sp. Chile5 2483409 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00452   NR RLN88570.1 2483409 g186288 i0 37.5 1.55675675675676 48 30 77.8 0 157 14 80 127 RLN88570.1 hypothetical protein BBJ28_00001185 [Nothophytophthora sp. Chile5] diamond 288 44.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Nothophytophthora Nothophytophthora sp. Chile5
32402647 32402647 PRJNA797655_S_NODE_169739_length_194_cov_1.907285_g169134_i0 PRJNA797655 169739 194 1.907285 3.7001329 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 53.1 3.91e-6   NR KAG2781974.1 29920 g169134 i0 71.8 9.04639175257732 39 11 60.3 0 193 77 286 324 KAG2781974.1 hypothetical protein Pcac1_g8322 [Phytophthora cactorum] diamond 1755 53.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cactorum

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