RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

25 rows where analysis = "diamond", bioproject = "PRJNA749559" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

  • Sar · 25 ✖

bioproject 1

  • PRJNA749559 · 25 ✖

analysis 1

  • diamond · 25 ✖

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
24952453 24952453 PRJNA749559_P_NODE_1600_length_352_cov_1.749141_g1530_i0 PRJNA749559 1600 352 1.749141 6.15697632 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 115 3.06e-29   NR UKJ89683.1 68886 g1530 i0 49.1 6.31534090909091 106 53 90.3 1 318 1 70 174 UKJ89683.1 40S ribosomal protein S3 [Theileria orientalis] diamond 2223 116 0.991379310344828 Eukaryota Sar   Apicomplexa Aconoidasida Piroplasmida Theileriidae Theileria Theileria orientalis
26682745 26682745 PRJNA749559_P_NODE_1241_length_408_cov_1.138329_g1171_i0 PRJNA749559 1241 408 1.138329 4.64438232 Ciliophora 5878 SAR_Eukaryotes SAR_Eukaryotes 106 1.2e-25   NR XP_004030147.1 5932 g1171 i0 40.5 2.73529411764706 121 72 89 0 372 10 79 199 XP_004030147.1 hypothetical protein IMG5_167050 [Ichthyophthirius multifiliis] diamond 1116 106 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
26831316 26831316 PRJNA749559_P_NODE_2841_length_257_cov_1.908163_g2771_i0 PRJNA749559 2841 257 1.908163 4.90397891 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 43.1 0.0134   NR OMJ87203.1 5963 g2771 i0 50 0.560311284046693 48 23 54.9 1 70 210 90 137 OMJ87203.1 hypothetical protein SteCoe_11128 [Stentor coeruleus] diamond 144 43.1 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
27252301 27252301 PRJNA749559_P_NODE_3923_length_215_cov_1.577922_g3853_i0 PRJNA749559 3923 215 1.577922 3.3925323 Tetrahymena 5890 SAR_Eukaryotes SAR_Eukaryotes 51.6 1.95e-5   NR KAL4455068.1 5901 g3853 i0 43.9 1.64651162790698 57 32 79.5 0 7 177 826 882 KAL4455068.1 hypothetical protein ABPG74_006450 [Tetrahymena malaccensis] diamond 354 52 0.992307692307692 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena malaccensis
27400558 27400558 PRJNA749559_P_NODE_3663_length_224_cov_2.196319_g3593_i0 PRJNA749559 3663 224 2.196319 4.91975456 Tetrahymena thermophila SB21 5911 SAR_Eukaryotes SAR_Eukaryotes 108 6.58e-28   NR XP_001013641.1 312017 g3593 i0 72.6 1.95535714285714 73 19 97.8 1 6 224 5 76 XP_001013641.1 60S ribosomal protein L11 [Tetrahymena thermophila SB210] diamond 438 108 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida Tetrahymenidae Tetrahymena Tetrahymena thermophila
28325880 28325880 PRJNA749559_P_NODE_1286_length_400_cov_1.643068_g1216_i0 PRJNA749559 1286 400 1.643068 6.572272 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 110 3.1e-28   NR XP_004024378.1 5932 g1216 i0 48.7 3.495 117 58 87.8 1 19 369 6 120 XP_004024378.1 ribosomal protein, putative [Ichthyophthirius multifiliis] diamond 1398 110 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
28505490 28505490 PRJNA749559_P_NODE_1307_length_396_cov_1.537313_g1237_i0 PRJNA749559 1307 396 1.537313 6.08775948 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 92 8.63e-20   NR CAG9310866.1 1481888 g1237 i0 42.3 1.78787878787879 130 64 96.2 2 1 381 106 227 CAG9310866.1 unnamed protein product [Blepharisma stoltei] diamond 708 92 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
28758035 28758035 PRJNA749559_P_NODE_1807_length_329_cov_1.671642_g1737_i0 PRJNA749559 1807 329 1.671642 5.49970218 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 60.5 5.09e-9   NR OMJ86847.1 5963 g1737 i0 38.4 0.90273556231003 99 55 90.3 3 2 298 13 105 OMJ86847.1 hypothetical protein SteCoe_11556 [Stentor coeruleus] diamond 297 60.5 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
28852623 28852623 PRJNA749559_P_NODE_3248_length_239_cov_1.713483_g3178_i0 PRJNA749559 3248 239 1.713483 4.09522437 Cryptocaryon irritans 153251 SAR_Eukaryotes SAR_Eukaryotes 69.3 1.1e-13   NR AGE89260.1 153251 g3178 i0 59.3 0.677824267782427 54 22 67.8 0 226 65 1 54 AGE89260.1 40S ribosomal protein S29 [Cryptocaryon irritans] diamond 162 69.3 1 Eukaryota Sar   Ciliophora       Cryptocaryon Cryptocaryon irritans
28884334 28884334 PRJNA749559_P_NODE_2668_length_266_cov_0.887805_g2598_i0 PRJNA749559 2668 266 0.887805 2.3615613 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 87.4 6.45e-20   NR CAG9313846.1 1481888 g2598 i0 61.2 2.42481203007519 67 26 75.6 0 242 42 50 116 CAG9313846.1 unnamed protein product [Blepharisma stoltei] diamond 645 87.4 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
29020982 29020982 PRJNA749559_P_NODE_4208_length_208_cov_2.612245_g4138_i0 PRJNA749559 4208 208 2.612245 5.4334696 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 88.6 7.01e-20   NR XP_001445461.1 5888 g4138 i0 71.2 1.70192307692308 59 17 85.1 0 1 177 141 199 XP_001445461.1 uncharacterized protein GSPATT00013511001 [Paramecium tetraurelia] diamond 354 88.6 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
29651745 29651745 PRJNA749559_P_NODE_3310_length_237_cov_1.943182_g3240_i0 PRJNA749559 3310 237 1.943182 4.60534134 root 1 Root_unresolved Root_unresolved 117 3.74e-31   NR XP_001445461.1 5888 g3240 i0 75.3 9.69620253164557 77 19 97.5 0 235 5 4 80 XP_001445461.1 uncharacterized protein GSPATT00013511001 [Paramecium tetraurelia] diamond 2298 117 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium tetraurelia
29926549 29926549 PRJNA749559_P_NODE_4571_length_205_cov_0.888889_g4501_i0 PRJNA749559 4571 205 0.888889 1.82222245 Paramecium primaurelia 5886 SAR_Eukaryotes SAR_Eukaryotes 92 3.4e-20   NR CAD8060455.1 5886 g4501 i0 62.1 3.8780487804878 66 25 96.6 0 4 201 218 283 CAD8060455.1 unnamed protein product [Paramecium primaurelia] diamond 795 92 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium primaurelia
29957939 29957939 PRJNA749559_P_NODE_1651_length_345_cov_0.869718_g1581_i0 PRJNA749559 1651 345 0.869718 3.0005271 Blastocystis sp. Blastoise 3128533 SAR_Eukaryotes SAR_Eukaryotes 54.3 2.05e-6   NR KAK8793392.1 3128533 g1581 i0 37.7 1.54782608695652 61 37 53 1 3 185 46 105 KAK8793392.1 hypothetical protein WA158_004751 [Blastocystis sp. Blastoise] diamond 534 54.3 1 Eukaryota Sar     Bigyra Opalinata Blastocystidae Blastocystis Blastocystis sp. Blastoise
29989620 29989620 PRJNA749559_P_NODE_2351_length_284_cov_2.295964_g2281_i0 PRJNA749559 2351 284 2.295964 6.52053776 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 78.2 1.04e-15   NR CAG9335356.1 1481888 g2281 i0 44 0.961267605633803 91 50 95.1 1 282 13 42 132 CAG9335356.1 unnamed protein product [Blepharisma stoltei] diamond 273 78.2 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
29989621 29989621 PRJNA749559_P_NODE_3851_length_218_cov_1.210191_g3781_i0 PRJNA749559 3851 218 1.210191 2.63821638 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 110 3.84e-26   NR CAI2379686.1 5936 g3781 i0 61.1 0.990825688073395 72 28 99.1 0 216 1 725 796 CAI2379686.1 unnamed protein product [Moneuplotes crassus] diamond 216 110 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
30052611 30052611 PRJNA749559_P_NODE_1811_length_329_cov_1.380597_g1741_i0 PRJNA749559 1811 329 1.380597 4.54216413 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 72.4 2.19e-12   NR OMJ86421.1 5963 g1741 i0 35.1 0.857142857142857 94 60 85.7 1 3 284 23 115 OMJ86421.1 hypothetical protein SteCoe_12082 [Stentor coeruleus] diamond 282 72.4 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
30179033 30179033 PRJNA749559_P_NODE_2592_length_270_cov_0.746411_g2522_i0 PRJNA749559 2592 270 0.746411 2.0153097 Moneuplotes crassus 5936 SAR_Eukaryotes SAR_Eukaryotes 103 2.78e-24   NR CAI2374236.1 5936 g2522 i0 63.6 3.34444444444444 77 27 85.6 1 39 269 218 293 CAI2374236.1 unnamed protein product [Moneuplotes crassus] diamond 903 103 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Moneuplotes Moneuplotes crassus
30400792 30400792 PRJNA749559_P_NODE_4933_length_202_cov_0.907801_g4863_i0 PRJNA749559 4933 202 0.907801 1.83375802 Paramecium octaurelia 43137 SAR_Eukaryotes SAR_Eukaryotes 62.4 2.55e-9   NR CAD8166261.1 43137 g4863 i0 41.8 2.0049504950495 67 36 98 2 202 5 444 508 CAD8166261.1 unnamed protein product [Paramecium octaurelia] diamond 405 62.4 1 Eukaryota Sar   Ciliophora Oligohymenophorea Peniculida Parameciidae Paramecium Paramecium octaurelia
30716165 30716165 PRJNA749559_P_NODE_4394_length_207_cov_0.876712_g4324_i0 PRJNA749559 4394 207 0.876712 1.81479384 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 82 3.44e-16   NR OMJ75484.1 5963 g4324 i0 62.3 2 69 23 100 1 207 1 609 674 OMJ75484.1 hypothetical protein SteCoe_25370 [Stentor coeruleus] diamond 414 82 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
31538301 31538301 PRJNA749559_P_NODE_2396_length_281_cov_2.286364_g2326_i0 PRJNA749559 2396 281 2.286364 6.42468284 Ichthyophthirius multifiliis 5932 SAR_Eukaryotes SAR_Eukaryotes 105 3.53e-27   NR XP_004030095.1 5932 g2326 i0 61.2 0.907473309608541 85 32 90.7 1 273 19 14 97 XP_004030095.1 hypothetical protein IMG5_167680 [Ichthyophthirius multifiliis] diamond 255 105 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
32139220 32139220 PRJNA749559_P_NODE_4218_length_208_cov_1.598639_g4148_i0 PRJNA749559 4218 208 1.598639 3.32516912 Blepharisma stoltei 1481888 SAR_Eukaryotes SAR_Eukaryotes 51.6 1.14e-5   NR CAG9314992.1 1481888 g4148 i0 43.1 0.836538461538462 58 33 83.7 0 203 30 68 125 CAG9314992.1 unnamed protein product [Blepharisma stoltei] diamond 174 51.6 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Blepharismidae Blepharisma Blepharisma stoltei
32297770 32297770 PRJNA749559_P_NODE_4659_length_204_cov_1.916084_g4589_i0 PRJNA749559 4659 204 1.916084 3.90881136 Pseudocohnilembus persalinus 266149 SAR_Eukaryotes SAR_Eukaryotes 63.5 1.49e-10   NR KRX01081.1 266149 g4589 i0 55 0.882352941176471 60 27 88.2 0 204 25 33 92 KRX01081.1 hypothetical protein PPERSA_02177 [Pseudocohnilembus persalinus] diamond 180 63.5 1 Eukaryota Sar   Ciliophora Oligohymenophorea Philasterida Pseudocohnilembidae Pseudocohnilembus Pseudocohnilembus persalinus
32329362 32329362 PRJNA749559_P_NODE_5059_length_201_cov_0.914286_g4989_i0 PRJNA749559 5059 201 0.914286 1.83771486 Stentor coeruleus 5963 SAR_Eukaryotes SAR_Eukaryotes 70.5 3.31e-12   NR OMJ87097.1 5963 g4989 i0 50 0.985074626865672 66 33 98.5 0 200 3 287 352 OMJ87097.1 hypothetical protein SteCoe_11246 [Stentor coeruleus] diamond 198 70.5 1 Eukaryota Sar   Ciliophora Heterotrichea Heterotrichida Stentoridae Stentor Stentor coeruleus
32833919 32833919 PRJNA749559_P_NODE_3360_length_235_cov_3.304598_g3290_i0 PRJNA749559 3360 235 3.304598 7.7658053 Euplotes vannus 5939 SAR_Eukaryotes SAR_Eukaryotes 66.2 5.63e-12   NR AAU88249.1 5939 g3290 i0 52.2 0.880851063829787 69 33 88.1 0 235 29 2 70 AAU88249.1 acidic ribosomal P2 protein, partial [Euplotes vannus] diamond 207 66.2 1 Eukaryota Sar   Ciliophora Spirotrichea Euplotida Euplotidae Euplotes Euplotes vannus

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