RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA1249042 · 7 ✖

analysis 1

  • diamond · 7 ✖

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
26743136 26743136 PRJNA1249042_S_NODE_105361_length_157_cov_3.149123_g105147_i0 PRJNA1249042 105361 157 3.149123 4.94412311 Apicomplexa 5794 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.26e-18   NR XP_067803686.1 323732 g105147 i0 72.5 16.5668789808917 51 14 97.5 0 1 153 54 104 XP_067803686.1 bifunctional Ribosomal protein L31e domain superfamily/Ribosomal protein L31e [Babesia duncani] diamond 2601 82.4 1 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Babesiidae Babesia Babesia duncani
26947015 26947015 PRJNA1249042_S_NODE_60982_length_197_cov_1.720779_g60768_i0 PRJNA1249042 60982 197 1.720779 3.38993463 Plasmodium falciparum 5833 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.00639   NR AIZ73304.1 5833 g60768 i0 50 1.21827411167513 40 20 60.9 0 122 3 82 121 AIZ73304.1 erythrocyte membrane protein 1, partial [Plasmodium falciparum] diamond 240 43.1 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
28589706 28589706 PRJNA1249042_S_NODE_67007_length_190_cov_3.625850_g66793_i0 PRJNA1249042 67007 190 3.62585 6.889115 Phytophthora palmivora 4796 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0487   NR POM73082.1 4796 g66793 i0 69.6 0.363157894736842 23 7 36.3 0 101 169 404 426 POM73082.1 Pol protein [Phytophthora palmivora] diamond 69 41.6 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora palmivora
28765331 28765331 PRJNA1249042_S_NODE_117507_length_150_cov_1.345794_g117293_i0 PRJNA1249042 117507 150 1.345794 2.018691 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 70.9 1.28e-12   NR CAJ1965813.1 2856 g117293 i0 62 7.88 50 19 100 0 1 150 604 653 CAJ1965813.1 unnamed protein product [Cylindrotheca closterium] diamond 1182 70.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Cylindrotheca Cylindrotheca closterium
29031803 29031803 PRJNA1249042_S_NODE_67888_length_189_cov_3.863014_g67674_i0 PRJNA1249042 67888 189 3.863014 7.30109646 Durusdinium trenchii 1381693 SAR_Eukaryotes SAR_Eukaryotes 41.6 0.0475   NR CAK9058534.1 1381693 g67674 i0 55.6 0.428571428571429 27 12 42.9 0 12 92 2609 2635 CAK9058534.1 Calcium-dependent protein kinase 2 (PfCDPK2), partial [Durusdinium trenchii] diamond 81 41.6 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Durusdinium Durusdinium trenchii
31653704 31653704 PRJNA1249042_S_NODE_115297_length_151_cov_1.740741_g115083_i0 PRJNA1249042 115297 151 1.740741 2.62851891 Tribonema minus 303371 SAR_Eukaryotes SAR_Eukaryotes 48.9 6.85e-5   NR KAG5184932.1 303371 g115083 i0 48.9 0.933774834437086 47 23 91.4 1 143 6 3894 3940 KAG5184932.1 dynein heavy chain family dynein heavy chain [Tribonema minus] diamond 141 48.9 1 Eukaryota Sar     Xanthophyceae Tribonematales Tribonemataceae Tribonema Tribonema minus
31938454 31938454 PRJNA1249042_S_NODE_86137_length_172_cov_3.131783_g85923_i0 PRJNA1249042 86137 172 3.131783 5.38666676 Aureococcus anophagefferens 44056 SAR_Eukaryotes SAR_Eukaryotes 42 0.0279   NR KAH8054579.1 44056 g85923 i0 50 2.23255813953488 32 16 55.8 0 26 121 681 712 KAH8054579.1 hypothetical protein JL721_10463 [Aureococcus anophagefferens] diamond 384 42 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Aureococcus Aureococcus anophagefferens

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