RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

11 rows where analysis = "diamond", bioproject = "PRJNA414225" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

  • Sar · 11 ✖

bioproject 1

  • PRJNA414225 · 11 ✖

analysis 1

  • diamond · 11 ✖

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
20820639 20820639 PRJNA414225_P_NODE_47637_length_167_cov_1.288136_g47550_i0 PRJNA414225 47637 167 1.288136 2.15118712 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 87 6.66e-20   NR GLE04291.1 114742 g47550 i0 85.1 5.91017964071856 47 7 84.4 0 26 166 74 120 GLE04291.1 hypothetical protein PINS_up013206 [Pythium insidiosum] diamond 987 87 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
26743635 26743635 PRJNA414225_P_NODE_29581_length_179_cov_1.569231_g29494_i0 PRJNA414225 29581 179 1.569231 2.80892349 Symbiodinium 2949 SAR_Eukaryotes SAR_Eukaryotes 60.8 4.42e-9   NR OLP71824.1 2951 g29494 i0 53.8 1.74301675977654 52 24 87.2 0 156 1 149 200 OLP71824.1 hypothetical protein AK812_SmicGene48397, partial [Symbiodinium microadriaticum] diamond 312 61.2 0.993464052287582 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
27440136 27440136 PRJNA414225_P_NODE_84163_length_162_cov_1.318584_g84076_i0 PRJNA414225 84163 162 1.318584 2.13610608 root 1 Root_unresolved Root_unresolved 48.9 2.18e-5   NR XP_664835.1 353151 g84076 i0 66 1.74074074074074 47 16 87 0 20 160 72 118 XP_664835.1 LacOPZ-alpha peptide from pUC9 [Cryptosporidium hominis TU502] diamond 282 48.9 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium hominis
28875598 28875598 PRJNA414225_P_NODE_10688_length_208_cov_0.955975_g10601_i0 PRJNA414225 10688 208 0.955975 1.988428 Amoebophrya sp. A25 1410381 SAR_Eukaryotes SAR_Eukaryotes 42 0.0441   NR CAD7952950.1 1410381 g10601 i0 37.3 0.966346153846154 67 36 88 1 183 1 27 93 CAD7952950.1 unnamed protein product, partial [Amoebophrya sp. A25] diamond 201 42 1 Eukaryota Sar     Dinophyceae Syndiniales Amoebophryaceae Amoebophrya Amoebophrya sp. A25
29664599 29664599 PRJNA414225_P_NODE_26530_length_182_cov_1.406015_g26443_i0 PRJNA414225 26530 182 1.406015 2.5589473 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 51.2 5.93e-6   NR CAE8648738.1 89957 g26443 i0 55.3 0.626373626373626 38 17 62.6 0 177 64 117 154 CAE8648738.1 unnamed protein product [Polarella glacialis] diamond 114 51.2 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
29917743 29917743 PRJNA414225_P_NODE_64951_length_165_cov_0.879310_g64864_i0 PRJNA414225 64951 165 0.87931 1.4508615 Symbiodinium sp. CCMP2456 1519616 SAR_Eukaryotes SAR_Eukaryotes 72.8 3.21e-13   NR CAE7249972.1 1519616 g64864 i0 61.5 1.89090909090909 52 20 94.5 0 2 157 222 273 CAE7249972.1 UBA2 [Symbiodinium sp. CCMP2456] diamond 312 72.8 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium sp. CCMP2456
29997586 29997586 PRJNA414225_P_NODE_63211_length_165_cov_0.879310_g63124_i0 PRJNA414225 63211 165 0.87931 1.4508615 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 47.8 2.26e-4   NR KAH8045122.1 44056 g63124 i0 47.1 2.50909090909091 51 27 92.7 0 4 156 122 172 KAH8045122.1 hypothetical protein JL721_12706 [Aureococcus anophagefferens] diamond 414 47.8 1 Eukaryota Sar     Pelagophyceae Pelagomonadales Pelagomonadaceae Aureococcus Aureococcus anophagefferens
30345492 30345492 PRJNA414225_P_NODE_91292_length_152_cov_2.980583_g91205_i0 PRJNA414225 91292 152 2.980583 4.53048616 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 49.7 3.79e-5   NR CDW74529.1 5949 g91205 i0 51 4.95394736842105 51 22 98.7 2 1 150 362 410 CDW74529.1 atp-dependent rna helicase [Stylonychia lemnae] diamond 753 50.1 0.992015968063872 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30770824 30770824 PRJNA414225_P_NODE_60754_length_166_cov_0.871795_g60667_i0 PRJNA414225 60754 166 0.871795 1.4471797 Nothophytophthora sp. Chile5 2483409 SAR_Eukaryotes SAR_Eukaryotes 50.4 2.53e-5   NR RLN38275.1 2483409 g60667 i0 54.5 5.06024096385542 55 19 99.4 1 1 165 695 743 RLN38275.1 hypothetical protein BBJ28_00016914, partial [Nothophytophthora sp. Chile5] diamond 840 50.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Nothophytophthora Nothophytophthora sp. Chile5
31166145 31166145 PRJNA414225_P_NODE_80935_length_163_cov_0.894737_g80848_i0 PRJNA414225 80935 163 0.894737 1.45842131 Monodopsidaceae 425072 SAR_Eukaryotes SAR_Eukaryotes 58.5 3.37e-8   NR EWM28400.1 72520 g80848 i0 59.1 3.60736196319018 44 18 81 0 163 32 63 106 EWM28400.1 putative inositol polyphosphate-5-phosphatase inp51p [Nannochloropsis gaditana] diamond 588 58.5 1 Eukaryota Sar     Eustigmatophyceae Eustigmatales Monodopsidaceae Nannochloropsis Nannochloropsis gaditana
32083688 32083688 PRJNA414225_P_NODE_46658_length_167_cov_1.728814_g46571_i0 PRJNA414225 46658 167 1.728814 2.88711938 Ectocarpus 2879 SAR_Eukaryotes SAR_Eukaryotes 85.9 1.21e-18   NR CBJ29312.1 2880 g46571 i0 85.1 1.77844311377246 47 7 84.4 0 165 25 156 202 CBJ29312.1 mitochondrial carrier family [Ectocarpus siliculosus] diamond 297 85.9 1 Eukaryota Sar     Phaeophyceae Ectocarpales Ectocarpaceae Ectocarpus Ectocarpus siliculosus

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