RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA1143173" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 14 ✖

bioproject 1

  • PRJNA1143173 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
2836845 2836845 PRJNA1143173_P_NODE_19843_length_287_cov_6.733645_g19817_i0 PRJNA1143173 19843 287 6.733645 19.32556115 root 1 Root_unresolved Root_unresolved 144 1.32e-37   NR CAE7860305.1 2951 g19817 i0 74.2 1.96515679442509 93 24 97.2 0 281 3 648 740 CAE7860305.1 gdhA [Symbiodinium microadriaticum] diamond 564 145 0.993103448275862 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
20688078 20688078 PRJNA1143173_P_NODE_42777_length_210_cov_4.350365_g42751_i0 PRJNA1143173 42777 210 4.350365 9.1357665 Oomycota 4762 SAR_Eukaryotes SAR_Eukaryotes 124 8.17e-32   NR TMW64105.1 41045 g42751 i0 86.8 14.5857142857143 68 9 97.1 0 5 208 71 138 TMW64105.1 hypothetical protein Poli38472_014222 [Pythium oligandrum] diamond 3063 125 0.992 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium oligandrum
26595363 26595363 PRJNA1143173_P_NODE_31161_length_254_cov_5.287293_g31135_i0 PRJNA1143173 31161 254 5.287293 13.42972422 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 94 4.17e-20   NR CAE7860319.1 2951 g31135 i0 47.4 0.921259842519685 78 41 92.1 0 236 3 153 230 CAE7860319.1 20 [Symbiodinium microadriaticum] diamond 234 94 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
27070366 27070366 PRJNA1143173_P_NODE_11862_length_310_cov_2.654008_g11836_i0 PRJNA1143173 11862 310 2.654008 8.2274248 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 52.8 2.53e-5   NR CAE7860319.1 2951 g11836 i0 46.9 0.474193548387097 49 25 47.4 1 162 308 1154 1201 CAE7860319.1 20 [Symbiodinium microadriaticum] diamond 147 52.8 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
27639282 27639282 PRJNA1143173_P_NODE_9644_length_310_cov_4.763713_g9618_i0 PRJNA1143173 9644 310 4.763713 14.7675103 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 77 7.93e-14   NR CAE7860319.1 2951 g9618 i0 66.7 0.464516129032258 48 16 46.5 0 306 163 125 172 CAE7860319.1 20 [Symbiodinium microadriaticum] diamond 144 77 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
28238782 28238782 PRJNA1143173_P_NODE_40666_length_222_cov_7.181208_g40640_i0 PRJNA1143173 40666 222 7.181208 15.94228176 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 88.6 2.15e-18   NR CAE7860322.1 2951 g40640 i0 59.7 0.905405405405405 67 27 90.5 0 207 7 466 532 CAE7860322.1 17 [Symbiodinium microadriaticum] diamond 201 88.6 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
28807062 28807062 PRJNA1143173_P_NODE_44408_length_199_cov_5.039683_g44382_i0 PRJNA1143173 44408 199 5.039683 10.02896917 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 89 1.12e-18   NR CAE7860228.1 2951 g44382 i0 54.5 1.98994974874372 66 30 99.5 0 1 198 1043 1108 CAE7860228.1 prkA [Symbiodinium microadriaticum] diamond 396 89 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
29743335 29743335 PRJNA1143173_P_NODE_41450_length_218_cov_4.806897_g41424_i0 PRJNA1143173 41450 218 4.806897 10.47903546 root 1 Root_unresolved Root_unresolved 107 3.42e-25   NR CAE7860319.1 2951 g41424 i0 68.1 1.98165137614679 72 23 99.1 0 217 2 1540 1611 CAE7860319.1 20 [Symbiodinium microadriaticum] diamond 432 108 0.990740740740741 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
30165030 30165030 PRJNA1143173_P_NODE_34412_length_245_cov_3.936047_g34386_i0 PRJNA1143173 34412 245 3.936047 9.64331515 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 119 4.45e-29   NR CAE7860226.1 2951 g34386 i0 65.4 0.991836734693878 81 28 99.2 0 243 1 781 861 CAE7860226.1 dnaE [Symbiodinium microadriaticum] diamond 243 119 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
30375820 30375820 PRJNA1143173_P_NODE_9092_length_310_cov_5.514768_g9066_i0 PRJNA1143173 9092 310 5.514768 17.0957808 root 1 Root_unresolved Root_unresolved 108 8.93e-25   NR CAE7860283.1 2951 g9066 i0 43.7 3.65806451612903 126 46 97.7 1 307 5 1090 1215 CAE7860283.1 18 [Symbiodinium microadriaticum] diamond 1134 108 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
31271155 31271155 PRJNA1143173_P_NODE_25235_length_271_cov_8.070707_g25209_i0 PRJNA1143173 25235 271 8.070707 21.87161597 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 162 3.68e-44   NR CAE7860319.1 2951 g25209 i0 86.7 1.99261992619926 90 12 99.6 0 2 271 1598 1687 CAE7860319.1 20 [Symbiodinium microadriaticum] diamond 540 162 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
31397769 31397769 PRJNA1143173_P_NODE_29616_length_259_cov_2.198925_g29590_i0 PRJNA1143173 29616 259 2.198925 5.69521575 Phaeodactylum tricornutum CCAP 1 2850 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0154   NR XP_002178802.1 556484 g29590 i0 34.7 0.833976833976834 72 47 83.4 0 39 254 119 190 XP_002178802.1 predicted protein [Phaeodactylum tricornutum CCAP 1055/1] diamond 216 43.9 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Phaeodactylaceae Phaeodactylum Phaeodactylum tricornutum
32125418 32125418 PRJNA1143173_P_NODE_5618_length_362_cov_4.058824_g5592_i0 PRJNA1143173 5618 362 4.058824 14.69294288 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.87e-15   NR CAE7860305.1 2951 g5592 i0 54.2 0.596685082872928 72 33 59.7 0 360 145 939 1010 CAE7860305.1 gdhA [Symbiodinium microadriaticum] diamond 216 82.4 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
32505070 32505070 PRJNA1143173_P_NODE_30919_length_255_cov_3.708791_g30893_i0 PRJNA1143173 30919 255 3.708791 9.45741705 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 147 1e-38   NR CAE7860283.1 2951 g30893 i0 69.4 2 85 26 100 0 255 1 1003 1087 CAE7860283.1 18 [Symbiodinium microadriaticum] diamond 510 147 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum

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