RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA608660 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
27712356 27712356 PRJNA608660_P_NODE_23124_length_285_cov_2.644068_g22768_i0 PRJNA608660 23124 285 2.644068 7.5355938 Symbiodinium natans 878477 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0249   NR CAE7423836.1 878477 g22768 i0 41 1.23157894736842 39 23 41.1 0 84 200 1870 1908 CAE7423836.1 unnamed protein product [Symbiodinium natans] diamond 351 43.9 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium natans
28027748 28027748 PRJNA608660_P_NODE_37025_length_200_cov_1.476821_g36669_i0 PRJNA608660 37025 200 1.476821 2.953642 Eimeria acervulina 5801 SAR_Eukaryotes SAR_Eukaryotes 42 0.0408   NR XP_013253311.1 5801 g36669 i0 38.3 0.705 47 29 70.5 0 56 196 366 412 XP_013253311.1 hypothetical protein, conserved [Eimeria acervulina] diamond 141 42 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Eimeriidae Eimeria Eimeria acervulina
28501365 28501365 PRJNA608660_P_NODE_49327_length_163_cov_0.912281_g48970_i0 PRJNA608660 49327 163 0.912281 1.48701803 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 48.1 1.59e-4   NR GAX27481.1 1519565 g48970 i0 55.3 1.39877300613497 38 17 69.9 0 126 13 95 132 GAX27481.1 hypothetical protein FisN_23Hu053 [Fistulifera solaris] diamond 228 48.1 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
31028147 31028147 PRJNA608660_P_NODE_13055_length_409_cov_2.427778_g12706_i0 PRJNA608660 13055 409 2.427778 9.92961202 Achlya hypogyna 1202772 SAR_Eukaryotes SAR_Eukaryotes 48.9 0.00154   NR OQR85564.1 1202772 g12706 i0 34.4 0.469437652811736 64 41 46.9 1 351 160 374 436 OQR85564.1 transmembrane protein [Achlya hypogyna] diamond 192 48.9 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya hypogyna
32766670 32766670 PRJNA608660_P_NODE_34400_length_212_cov_1.496933_g34044_i0 PRJNA608660 34400 212 1.496933 3.17349796 Tetraparma gracilis 2962635 SAR_Eukaryotes SAR_Eukaryotes 48.9 1.55e-4   NR GMI50407.1 2962635 g34044 i0 60 0.962264150943396 35 14 49.5 0 33 137 265 299 GMI50407.1 hypothetical protein TeGR_g12811 [Tetraparma gracilis] diamond 204 48.9 1 Eukaryota Sar     Bolidophyceae Parmales Triparmaceae Tetraparma Tetraparma gracilis
32842724 32842724 PRJNA608660_P_NODE_700_length_1243_cov_13.223618_g589_i0 PRJNA608660 700 1243 13.223618 164.36957174 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 137 3.6199999999999997e-34   NR XP_067750673.1 164328 g589 i0 37.9 1.88736926790024 195 118 47.1 2 562 1146 1 192 XP_067750673.1 Vesicle-associated membrane protein 7B [Phytophthora ramorum] diamond 2346 138 0.992753623188406 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora ramorum

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