RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "diamond", bioproject = "PRJNA807685" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

tax_clade 1

bioproject 1

  • PRJNA807685 · 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
27496647 27496647 PRJNA807685_P_NODE_16003_length_372_cov_1.740299_g14933_i0 PRJNA807685 16003 372 1.740299 6.47391228 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 55.1 7.13e-6   NR RHX96691.1 112090 g14933 i0 50.9 2.56451612903226 53 25 41.9 1 372 217 158 210 RHX96691.1 hypothetical protein DYB25_011879 [Aphanomyces astaci] diamond 954 55.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
28073650 28073650 PRJNA807685_P_NODE_27705_length_247_cov_3.733333_g26632_i0 PRJNA807685 27705 247 3.733333 9.22133251 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 74.7 7.15e-14   NR GMF63217.1 1490495 g26632 i0 40.6 4.76113360323887 69 41 83.8 0 39 245 133 201 GMF63217.1 unnamed protein product, partial [Phytophthora fragariaefolia] diamond 1176 74.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora fragariaefolia
28547614 28547614 PRJNA807685_P_NODE_43587_length_185_cov_2.750000_g42514_i0 PRJNA807685 43587 185 2.75 5.0875 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 42 0.0327   NR OWZ06631.1 4795 g42514 i0 31.1 5.09189189189189 61 42 98.9 0 185 3 108 168 OWZ06631.1 LOW QUALITY PROTEIN: hypothetical protein PHMEG_00021088, partial [Phytophthora megakarya] diamond 942 42 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megakarya
30243896 30243896 PRJNA807685_P_NODE_53232_length_167_cov_1.938462_g52159_i0 PRJNA807685 53232 167 1.938462 3.23723154 Pelagomonas calceolata 35677 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0181   NR CAH0364162.1 35677 g52159 i0 43.8 2.58682634730539 48 25 82.6 1 140 3 242 289 CAH0364162.1 unnamed protein product [Pelagomonas calceolata] diamond 432 42.4 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Pelagomonas Pelagomonas calceolata
30685949 30685949 PRJNA807685_P_NODE_19613_length_318_cov_2.743772_g18541_i0 PRJNA807685 19613 318 2.743772 8.72519496 Ochromonadaceae sp. CCMP2298 483371 SAR_Eukaryotes SAR_Eukaryotes 159 1.2499999999999998e-47   NR KAJ1418183.1 483371 g18541 i0 77.6 0.924528301886792 98 22 92.5 0 2 295 68 165 KAJ1418183.1 ribosomal protein S17-domain-containing protein [Ochromonadaceae sp. CCMP2298] diamond 294 159 1 Eukaryota Sar     Synurophyceae Ochromonadales Ochromonadaceae   Ochromonadaceae sp. CCMP2298
32014031 32014031 PRJNA807685_P_NODE_38058_length_200_cov_1.631902_g36985_i0 PRJNA807685 38058 200 1.631902 3.263804 Aureococcus anophagefferens 44056 SAR_Eukaryotes SAR_Eukaryotes 42 0.0411   NR XP_009033386.1 44056 g36985 i0 50 2.7 36 17 54 1 43 150 1754 1788 XP_009033386.1 hypothetical protein AURANDRAFT_70704 [Aureococcus anophagefferens] diamond 540 42 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Aureococcus Aureococcus anophagefferens
32054472 32054472 PRJNA807685_P_NODE_45378_length_181_cov_2.402778_g44305_i0 PRJNA807685 45378 181 2.402778 4.34902818 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 70.9 1.87e-12   NR KAH9134313.1 100861 g44305 i0 50.8 7.8232044198895 59 29 97.8 0 2 178 258 316 KAH9134313.1 hypothetical protein AeRB84_019895 [Aphanomyces euteiches] diamond 1416 70.9 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches

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