RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

21 rows where analysis = "diamond", bioproject = "PRJNA1196438" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_clade 1

  • Sar · 21 ✖

bioproject 1

  • PRJNA1196438 · 21 ✖

analysis 1

  • diamond · 21 ✖

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
18175014 18175014 PRJNA1196438_P_NODE_64075_length_253_cov_0.866667_g63648_i0 PRJNA1196438 64075 253 0.866667 2.19266751 Paramecium sonneborni 65129 SAR_Eukaryotes SAR_Eukaryotes 67.4 8.58e-11   NR CAD8091707.1 65129 g63648 i0 40.9 1.10276679841897 93 42 98.4 3 251 3 341 430 CAD8091707.1 unnamed protein product [Paramecium sonneborni] diamond 279 67.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium sonneborni
26787770 26787770 PRJNA1196438_P_NODE_12841_length_312_cov_6.276151_g12415_i0 PRJNA1196438 12841 312 6.276151 19.58159112 Polarella glacialis 89957 SAR_Eukaryotes SAR_Eukaryotes 42.4 0.0361   NR CAK0854905.1 89957 g12415 i0 46.5 0.413461538461538 43 21 41.3 1 18 146 38 78 CAK0854905.1 unnamed protein product [Polarella glacialis] diamond 129 42.4 1 Eukaryota Sar     Dinophyceae Suessiales Suessiaceae Polarella Polarella glacialis
26819507 26819507 PRJNA1196438_P_NODE_65021_length_252_cov_0.871508_g64594_i0 PRJNA1196438 65021 252 0.871508 2.19620016 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 55.5 1.35e-6   NR CDW80548.1 5949 g64594 i0 37 1.95238095238095 92 41 100 2 252 1 290 372 CDW80548.1 UNKNOWN [Stylonychia lemnae] diamond 492 55.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
26945837 26945837 PRJNA1196438_P_NODE_76062_length_242_cov_0.923077_g75635_i0 PRJNA1196438 76062 242 0.923077 2.23384634 Euplotes aediculatus 5940 SAR_Eukaryotes SAR_Eukaryotes 82 2.75e-16   NR QTT61050.1 5940 g75635 i0 71.9 0.706611570247934 57 16 70.7 0 62 232 282 338 QTT61050.1 hypothetical protein [Euplotes aediculatus] diamond 171 82 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes aediculatus
27641357 27641357 PRJNA1196438_P_NODE_50404_length_272_cov_2.929648_g49977_i0 PRJNA1196438 50404 272 2.929648 7.96864256 Eunotia naegelii 1458866 SAR_Eukaryotes SAR_Eukaryotes 64.3 1.38e-9   NR YP_009495442.1 1458866 g49977 i0 71.1 0.496323529411765 45 13 49.6 0 7 141 177 221 YP_009495442.1 NADH dehydrogenase subunit 2 [Eunotia naegelii] diamond 135 64.3 1 Eukaryota Sar   Bacillariophyta Bacillariophyceae Eunotiales Eunotiaceae Eunotia Eunotia naegelii
28083090 28083090 PRJNA1196438_P_NODE_33285_length_299_cov_3.101770_g32859_i0 PRJNA1196438 33285 299 3.10177 9.2742923 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 43.9 0.0277   NR XP_001032992.3 312017 g32859 i0 70 0.301003344481605 30 9 30.1 0 25 114 26 55 XP_001032992.3 C2 domain protein [Tetrahymena thermophila SB210] diamond 90 43.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28291432 28291432 PRJNA1196438_P_NODE_48346_length_276_cov_1.359606_g47919_i0 PRJNA1196438 48346 276 1.359606 3.75251256 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 93.6 6.15e-21   NR YP_010227897.1 41456 g47919 i0 51.1 32.1521739130435 92 42 96.7 1 8 274 88 179 YP_010227897.1 cytochrome oxidase subunit 2 [Polymyxa betae] diamond 8874 93.6 1 Eukaryota Sar   Endomyxa Phytomyxea Plasmodiophorida Plasmodiophoridae Polymyxa Polymyxa betae
28430585 28430585 PRJNA1196438_P_NODE_3286_length_535_cov_4.515152_g2878_i0 PRJNA1196438 3286 535 4.515152 24.1560632 Arachnula sp. CL12 862247 SAR_Eukaryotes SAR_Eukaryotes 183 2.91e-52   NR ADK90073.1 862247 g2878 i0 56 2.50654205607477 150 59 84.1 2 534 85 295 437 ADK90073.1 elongation factor 1 alpha, partial [Arachnula sp. CL12] diamond 1341 183 1 Eukaryota Sar   Endomyxa   Vampyrellida Leptophryidae Arachnula Arachnula sp. CL12
28430633 28430633 PRJNA1196438_P_NODE_75006_length_243_cov_0.917647_g74579_i0 PRJNA1196438 75006 243 0.917647 2.22988221 Albugo laibachii Nc14 890382 SAR_Eukaryotes SAR_Eukaryotes 60.5 5.32e-9   NR CCA22303.1 890382 g74579 i0 39.4 0.876543209876543 71 43 87.7 0 217 5 1 71 CCA22303.1 Hypothetical protein W07E6.6 putative [Albugo laibachii Nc14] diamond 213 60.5 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
28481034 28481034 PRJNA1196438_P_NODE_26706_length_301_cov_5.508772_g26280_i0 PRJNA1196438 26706 301 5.508772 16.58140372 Euplotidae 100127 SAR_Eukaryotes SAR_Eukaryotes 43.5 0.0382   NR ACX30945.1 74792 g26280 i0 54 0.996677740863787 50 23 49.8 0 151 300 336 385 ACX30945.1 cytochrome b [Moneuplotes minuta] diamond 300 43.9 0.990888382687927 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes minuta
29093706 29093706 PRJNA1196438_P_NODE_50608_length_272_cov_2.040201_g50181_i0 PRJNA1196438 50608 272 2.040201 5.54934672 Fragilaria crotonensis 210448 SAR_Eukaryotes SAR_Eukaryotes 83.2 2.62e-18   NR KAI2500408.1 210448 g50181 i0 86 3.94852941176471 50 7 55.1 0 272 123 51 100 KAI2500408.1 mttA/Hcf106 family [Fragilaria crotonensis] diamond 1074 83.2 1 Eukaryota Sar   Bacillariophyta Fragilariophyceae Fragilariales Fragilariaceae Fragilaria Fragilaria crotonensis
29459511 29459511 PRJNA1196438_P_NODE_82270_length_229_cov_2.589744_g81843_i0 PRJNA1196438 82270 229 2.589744 5.93051376 root 1 Root_unresolved Root_unresolved 48.5 2.74e-4   NR CDW74993.1 5949 g81843 i0 69.7 6.05240174672489 33 10 43.2 0 127 225 145 177 CDW74993.1 arsenical pump-driving atpase [Stylonychia lemnae] diamond 1386 48.5 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29819564 29819564 PRJNA1196438_P_NODE_68171_length_249_cov_0.886364_g67744_i0 PRJNA1196438 68171 249 0.886364 2.20704636 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 72 1.98e-12   NR CDW76481.1 5949 g67744 i0 81.4 0.518072289156627 43 8 51.8 0 181 53 274 316 CDW76481.1 tpr domain containing protein [Stylonychia lemnae] diamond 129 72 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
29883148 29883148 PRJNA1196438_P_NODE_82331_length_229_cov_2.243590_g81904_i0 PRJNA1196438 82331 229 2.24359 5.1378211 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.0018600000000000001   NR XP_001022969.2 312017 g81904 i0 52.9 0.668122270742358 51 24 66.8 0 173 21 1744 1794 XP_001022969.2 hypothetical protein TTHERM_00348140 [Tetrahymena thermophila SB210] diamond 153 46.2 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
30691686 30691686 PRJNA1196438_P_NODE_78373_length_237_cov_3.176829_g77946_i0 PRJNA1196438 78373 237 3.176829 7.52908473 Rhodophyta 2763 SAR_Eukaryotes SAR_Eukaryotes 99.8 2.32e-22   NR ACS27157.1 2829 g77946 i0 70.5 6.48101265822785 61 18 77.2 0 236 54 432 492 ACS27157.1 cytochrome c oxidase subunit I [Heterosigma akashiwo] diamond 1536 100 0.998 Eukaryota Sar     Raphidophyceae Chattonellales Chattonellaceae Heterosigma Heterosigma akashiwo
31241429 31241429 PRJNA1196438_P_NODE_74955_length_243_cov_0.917647_g74528_i0 PRJNA1196438 74955 243 0.917647 2.22988221 Tetrahymena thermophila 5911 SAR_Eukaryotes SAR_Eukaryotes 79.7 3.36e-15   NR ABY59948.1 5911 g74528 i0 51.3 1.97530864197531 80 39 98.8 0 241 2 288 367 ABY59948.1 cytochrome P450 monooxygenase CYP5001A1 [Tetrahymena thermophila] diamond 480 79.7 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
31494754 31494754 PRJNA1196438_P_NODE_78736_length_236_cov_4.325153_g78309_i0 PRJNA1196438 78736 236 4.325153 10.20736108 Paramecium tetraurelia 5888 SAR_Eukaryotes SAR_Eukaryotes 86.3 1.56e-17   NR XP_001448247.1 5888 g78309 i0 89.4 62.7330508474576 47 5 59.7 0 235 95 44 90 XP_001448247.1 uncharacterized protein GSPATT00015709001 [Paramecium tetraurelia] diamond 14805 86.3 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
31558091 31558091 PRJNA1196438_P_NODE_79836_length_234_cov_2.894410_g79409_i0 PRJNA1196438 79836 234 2.89441 6.7729194 Stylonychia lemnae 5949 SAR_Eukaryotes SAR_Eukaryotes 55.1 1.5e-6   NR CDW77142.1 5949 g79409 i0 57.1 0.717948717948718 56 21 70.5 2 195 31 41 94 CDW77142.1 UNKNOWN [Stylonychia lemnae] diamond 168 55.1 1 Eukaryota Sar   Ciliophora Spirotrichea Sporadotrichida Oxytrichidae Stylonychia Stylonychia lemnae
31810908 31810908 PRJNA1196438_P_NODE_45377_length_280_cov_2.536232_g44950_i0 PRJNA1196438 45377 280 2.536232 7.1014496 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 106 1.5499999999999998e-24   NR CAI2361196.1 5936 g44950 i0 59.1 0.942857142857143 88 36 94.3 0 266 3 344 431 CAI2361196.1 unnamed protein product [Moneuplotes crassus] diamond 264 106 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
32589306 32589306 PRJNA1196438_P_NODE_9939_length_335_cov_2.847328_g9514_i0 PRJNA1196438 9939 335 2.847328 9.5385488 Symbiodinium 2949 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.012   NR CAE7175166.1 2951 g9514 i0 34.3 1.2 67 44 60 0 51 251 602 668 CAE7175166.1 unnamed protein product [Symbiodinium microadriaticum] diamond 402 45.4 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
32664523 32664523 PRJNA1196438_P_NODE_76300_length_242_cov_0.923077_g75873_i0 PRJNA1196438 76300 242 0.923077 2.23384634 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 75.5 7.46e-14   NR CAI2374586.1 5936 g75873 i0 83.7 0.607438016528926 49 8 60.7 0 162 16 1 49 CAI2374586.1 unnamed protein product [Moneuplotes crassus] diamond 147 75.5 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus

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