RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

26 rows where analysis = "diamond", bioproject = "PRJNA800053" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 26 ✖

bioproject 1

  • PRJNA800053 · 26 ✖

analysis 1

  • diamond · 26 ✖

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
10148382 10148382 PRJNA800053_P_NODE_14588_length_268_cov_1.579487_g14424_i0 PRJNA800053 14588 268 1.579487 4.23302516 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 125 4.2e-31   NR CDW81236.1 5949 g14424 i0 58.4 0.996268656716418 89 37 99.6 0 268 2 147 235 CDW81236.1 malate dehydrogenase [Stylonychia lemnae] diamond 267 125 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
26642449 26642449 PRJNA800053_P_NODE_13001_length_280_cov_1.091787_g12837_i0 PRJNA800053 13001 280 1.091787 3.0570036 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.0159   NR XP_009537268.1 67593 g12837 i0 50 0.428571428571429 40 20 42.9 0 278 159 468 507 XP_009537268.1 hypothetical protein PHYSODRAFT_340757 [Phytophthora sojae] diamond 120 44.3 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
26705627 26705627 PRJNA800053_P_NODE_17541_length_251_cov_0.865169_g17377_i0 PRJNA800053 17541 251 0.865169 2.17157419 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 71.6 1.25e-12   NR XP_001018318.1 312017 g17377 i0 48.6 0.860557768924303 72 37 86.1 0 35 250 111 182 XP_001018318.1 enoyl-CoA hydratase/delta3,5-delta2,4-dienoyl-CoA isomerase [Tetrahymena thermophila SB210] diamond 216 71.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27063004 27063004 PRJNA800053_P_NODE_15222_length_264_cov_1.198953_g15058_i0 PRJNA800053 15222 264 1.198953 3.16523592 root 1 Root_unresolved Root_unresolved 115 1.57e-27   NR XP_001021485.3 312017 g15058 i0 61.4 10 88 34 100 0 1 264 441 528 XP_001021485.3 succinyl-CoA:3-ketoacid-coenzyme A transferase [Tetrahymena thermophila SB210] diamond 2640 115 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
27243688 27243688 PRJNA800053_P_NODE_19643_length_247_cov_2.643678_g19479_i0 PRJNA800053 19643 247 2.643678 6.52988466 Nitzschia inconspicua 303405 SAR_Eukaryotes SAR_Eukaryotes 78.2 1.36e-15   NR KAG7352363.1 303405 g19479 i0 54.5 2.80566801619433 77 35 93.5 0 235 5 112 188 KAG7352363.1 hypothetical protein IV203_008411 [Nitzschia inconspicua] diamond 693 78.2 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Bacillariales Bacillariaceae Nitzschia Nitzschia inconspicua
27370462 27370462 PRJNA800053_P_NODE_19843_length_247_cov_0.885057_g19679_i0 PRJNA800053 19843 247 0.885057 2.18609079 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 46.6 0.00167   NR CAI2369249.1 5936 g19679 i0 54.1 0.449392712550607 37 17 44.9 0 4 114 211 247 CAI2369249.1 unnamed protein product [Moneuplotes crassus] diamond 111 46.6 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
28348919 28348919 PRJNA800053_P_NODE_14066_length_272_cov_1.356784_g13902_i0 PRJNA800053 14066 272 1.356784 3.69045248 Cyclotella cryptica 29204 SAR_Eukaryotes SAR_Eukaryotes 112 1.64e-26   NR KAL3795670.1 29204 g13902 i0 87.7 0.716911764705882 65 8 71.7 0 197 3 355 419 KAL3795670.1 hypothetical protein HJC23_002077 [Cyclotella cryptica] diamond 195 112 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella cryptica
28348924 28348924 PRJNA800053_P_NODE_24566_length_232_cov_3.069182_g24402_i0 PRJNA800053 24566 232 3.069182 7.12050224 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 91.3 2.21e-19   NR KAF0752888.1 112090 g24402 i0 78.8 0.672413793103448 52 11 67.2 0 76 231 42 93 KAF0752888.1 hypothetical protein AaE_005876 [Aphanomyces astaci] diamond 156 91.3 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
28727875 28727875 PRJNA800053_P_NODE_15407_length_263_cov_0.910526_g15243_i0 PRJNA800053 15407 263 0.910526 2.39468338 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 42.7 0.0493   NR CAE8599083.1 89957 g15243 i0 32.9 0.866920152091255 76 48 83.3 1 25 243 1695 1770 CAE8599083.1 unnamed protein product [Polarella glacialis] diamond 228 42.7 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
28759332 28759332 PRJNA800053_P_NODE_11147_length_294_cov_4.339367_g10983_i0 PRJNA800053 11147 294 4.339367 12.75773898 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 84.7 1.12e-17   NR RHY00224.1 112090 g10983 i0 71.2 2 52 15 53.1 0 157 2 1 52 RHY00224.1 hypothetical protein DYB25_013817 [Aphanomyces astaci] diamond 588 84.7 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
28949087 28949087 PRJNA800053_P_NODE_22388_length_243_cov_0.905882_g22224_i0 PRJNA800053 22388 243 0.905882 2.20129326 Pythium insidiosum 114742 SAR_Eukaryotes SAR_Eukaryotes 48.1 4.48e-4   NR GLD95010.1 114742 g22224 i0 31.5 2.58024691358025 73 49 88.9 1 3 218 352 424 GLD95010.1 hypothetical protein PINS_up003635 [Pythium insidiosum] diamond 627 48.1 1 Eukaryota Sar   Oomycota Peronosporomycetes Pythiales Pythiaceae Pythium Pythium insidiosum
29210565 29210565 PRJNA800053_P_NODE_12569_length_283_cov_1.100000_g12405_i0 PRJNA800053 12569 283 1.1 3.113 Paramecium 5884 SAR_Eukaryotes SAR_Eukaryotes 82.4 3.93e-16   NR XP_001450671.1 5888 g12405 i0 44.3 6.53003533568905 88 42 89 2 256 5 42 126 XP_001450671.1 uncharacterized protein GSPATT00017618001 [Paramecium tetraurelia] diamond 1848 83.2 0.990384615384615 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
29359410 29359410 PRJNA800053_P_NODE_23649_length_241_cov_0.916667_g23485_i0 PRJNA800053 23649 241 0.916667 2.20916747 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 68.6 2.89e-11   NR XP_001033076.2 312017 g23485 i0 65.1 0.535269709543568 43 15 53.5 0 132 4 416 458 XP_001033076.2 ubiquitin carboxyl-terminal hydrolase [Tetrahymena thermophila SB210] diamond 129 68.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
29422265 29422265 PRJNA800053_P_NODE_14229_length_271_cov_0.994949_g14065_i0 PRJNA800053 14229 271 0.994949 2.69631179 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 77.4 3.25e-14   NR XP_001448566.1 5888 g14065 i0 51.5 2.19188191881919 66 32 73.1 0 3 200 562 627 XP_001448566.1 uncharacterized protein GSPATT00016010001 [Paramecium tetraurelia] diamond 594 77.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
29526214 29526214 PRJNA800053_P_NODE_15250_length_263_cov_5.926316_g15086_i0 PRJNA800053 15250 263 5.926316 15.58621108 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 69.3 2.99e-13   NR ETW38010.1 1036725 g15086 i0 52.2 2.33840304182509 67 32 76.4 0 261 61 2 68 ETW38010.1 hypothetical protein PFTANZ_01288 [Plasmodium falciparum Tanzania (2000708)] diamond 615 69.7 0.994261119081779 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium falciparum
29611601 29611601 PRJNA800053_P_NODE_13950_length_273_cov_1.230000_g13786_i0 PRJNA800053 13950 273 1.23 3.3579 Cryptosporidium felis 83540 SAR_Eukaryotes SAR_Eukaryotes 56.6 6.35e-7   NR KAF7458391.1 83540 g13786 i0 69.7 0.758241758241758 33 10 36.3 0 234 136 157 189 KAF7458391.1 ZPR1 zinc-finger domain protein [Cryptosporidium felis] diamond 207 56.6 1 Eukaryota Sar   Apicomplexa Conoidasida Eucoccidiorida Cryptosporidiidae Cryptosporidium Cryptosporidium felis
29737953 29737953 PRJNA800053_P_NODE_6750_length_360_cov_1.606272_g6586_i0 PRJNA800053 6750 360 1.606272 5.7825792 Tetrahymena malaccensis 5901 SAR_Eukaryotes SAR_Eukaryotes 110 1.83e-25   NR KAL4449249.1 5901 g6586 i0 63 0.766666666666667 92 34 76.7 0 356 81 605 696 KAL4449249.1 hypothetical protein ABPG74_015631 [Tetrahymena malaccensis] diamond 276 110 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
30211863 30211863 PRJNA800053_P_NODE_18792_length_249_cov_0.875000_g18628_i0 PRJNA800053 18792 249 0.875 2.17875 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0276   NR CDW81038.1 5949 g18628 i0 81.8 0.265060240963855 22 4 26.5 0 2 67 106 127 CDW81038.1 nli interacting factor-like phosphatase family protein [Stylonychia lemnae] diamond 66 43.1 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
30307338 30307338 PRJNA800053_P_NODE_17972_length_250_cov_0.870056_g17808_i0 PRJNA800053 17972 250 0.870056 2.17514 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 72 1.36e-12   NR KAI2497134.1 210448 g17808 i0 48.7 2.376 76 38 90 1 21 245 132 207 KAI2497134.1 hypothetical protein MHU86_17395 [Fragilaria crotonensis] diamond 594 72 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
30370486 30370486 PRJNA800053_P_NODE_23212_length_242_cov_0.911243_g23048_i0 PRJNA800053 23212 242 0.911243 2.20520806 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 64.7 1.04e-10   NR CAI2376927.1 5936 g23048 i0 43.4 0.942148760330578 76 33 94.2 1 4 231 62 127 CAI2376927.1 unnamed protein product [Moneuplotes crassus] diamond 228 64.7 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
30402085 30402085 PRJNA800053_P_NODE_21913_length_244_cov_0.900585_g21749_i0 PRJNA800053 21913 244 0.900585 2.1974274 Fistulifera solaris 1519565 SAR_Eukaryotes SAR_Eukaryotes 79.3 5.04e-15   NR GAX12872.1 1519565 g21749 i0 47.4 0.934426229508197 76 34 93.4 1 241 14 360 429 GAX12872.1 hypothetical protein FisN_32Lu084, partial [Fistulifera solaris] diamond 228 79.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Fistulifera Fistulifera solaris
30559371 30559371 PRJNA800053_P_NODE_15833_length_260_cov_1.427807_g15669_i0 PRJNA800053 15833 260 1.427807 3.7122982 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 90.1 3.79e-19   NR CDW76069.1 5949 g15669 i0 86.5 0.6 52 7 60 0 4 159 186 237 CDW76069.1 UNKNOWN [Stylonychia lemnae] diamond 156 90.1 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31127956 31127956 PRJNA800053_P_NODE_10195_length_305_cov_6.435345_g10031_i0 PRJNA800053 10195 305 6.435345 19.62780225 Seminavis robusta 568900 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0145   NR CAB9509116.1 568900 g10031 i0 30.9 0.924590163934426 94 57 89.5 2 4 276 41 129 CAB9509116.1 hypothetical protein SEMRO_376_G129600.1 [Seminavis robusta] diamond 282 44.7 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Naviculales Naviculaceae Seminavis Seminavis robusta
31254714 31254714 PRJNA800053_P_NODE_15795_length_260_cov_1.700535_g15631_i0 PRJNA800053 15795 260 1.700535 4.421391 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 172 5.01e-52   NR RHY00224.1 112090 g15631 i0 88.2 1.96153846153846 85 10 98.1 0 257 3 52 136 RHY00224.1 hypothetical protein DYB25_013817 [Aphanomyces astaci] diamond 510 172 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
31643106 31643106 PRJNA800053_P_NODE_7436_length_346_cov_3.355311_g7272_i0 PRJNA800053 7436 346 3.355311 11.60937606 root 1 Root_unresolved Root_unresolved 52.8 3.09e-5   NR KAG7386366.1 109152 g7272 i0 69.7 1.39595375722543 33 10 28.6 0 344 246 274 306 KAG7386366.1 hypothetical protein PHYBOEH_008712 [Phytophthora boehmeriae] diamond 483 52.8 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora boehmeriae
31823942 31823942 PRJNA800053_P_NODE_4457_length_426_cov_3.127479_g4294_i0 PRJNA800053 4457 426 3.127479 13.32306054 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 276 1.9e-92   NR RLO04354.1 112090 g4294 i0 94.3 3.97183098591549 141 8 99.3 0 424 2 26 166 RLO04354.1 hypothetical protein DYB28_006525 [Aphanomyces astaci] diamond 1692 276 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci

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