RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

32 rows where analysis = "diamond", bioproject = "PRJNA758398" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 32 ✖

tax_clade 1

bioproject 1

  • PRJNA758398 · 32 ✖

analysis 1

  • diamond · 32 ✖

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
2015864 2015864 PRJNA758398_S_NODE_37282_length_176_cov_2.283465_g37141_i0 PRJNA758398 37282 176 2.283465 4.0188984 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 107 4.58e-28   NR ADK47156.1 323453 g37141 i0 87.9 0.988636363636364 58 7 98.9 0 174 1 5 62 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 174 107 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
2016050 2016050 PRJNA758398_S_NODE_7222_length_356_cov_2.107492_g7081_i0 PRJNA758398 7222 356 2.107492 7.50267152 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 150 4.85e-42   NR MES1913008.1 1215613 g7081 i0 59.7 1.00280898876405 119 47 99.4 1 1 354 43 161 MES1913008.1 hypothetical protein [Cercozoa sp. M6MM] diamond 357 150 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
2016072 2016072 PRJNA758398_S_NODE_822_length_953_cov_3.269912_g745_i0 PRJNA758398 822 953 3.269912 31.16226136 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 298 2.9e-96   NR MES1912634.1 1215613 g745 i0 64.2 0.774396642182581 246 78 75.9 3 231 953 6 246 MES1912634.1 hypothetical protein [Cercozoa sp. M6MM] diamond 738 298 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
4567855 4567855 PRJNA758398_S_NODE_1104_length_841_cov_10.516414_g1008_i0 PRJNA758398 1104 841 10.516414 88.44304174 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 246 2.5500000000000003e-79   NR ADK26622.1 323453 g1008 i0 88.5 0.463733650416171 130 15 46.4 0 25 414 1 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 390 246 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
7118384 7118384 PRJNA758398_S_NODE_186_length_1500_cov_61.237767_g155_i0 PRJNA758398 186 1500 61.237767 918.566505 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 517 3.2299999999999993e-178   NR MES1909605.1 1215613 g155 i0 73.6 2.776 337 89 67.4 0 2 1012 97 433 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 4164 519 0.996146435452794 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
9668284 9668284 PRJNA758398_S_NODE_32568_length_187_cov_1.478261_g32427_i0 PRJNA758398 32568 187 1.478261 2.76434807 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 93.6 3.62e-21   NR MES1911654.1 1215613 g32427 i0 74.2 21.5133689839572 62 15 97.9 1 3 185 168 229 MES1911654.1 hypothetical protein [Cercozoa sp. M6MM] diamond 4023 93.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
10943978 10943978 PRJNA758398_S_NODE_3989_length_474_cov_1.844706_g3848_i0 PRJNA758398 3989 474 1.844706 8.74390644 Thaumatomonas sp. (SA) 188940 SAR_Eukaryotes SAR_Eukaryotes 209 8.61e-62   NR AAP72162.1 188940 g3848 i0 81.8 5.09493670886076 165 22 99.4 1 472 2 153 317 AAP72162.1 heat shock protein 90, partial [Thaumatomonas sp. (SA)] diamond 2415 209 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. (SA)
14768630 14768630 PRJNA758398_S_NODE_27632_length_200_cov_2.192053_g27491_i0 PRJNA758398 27632 200 2.192053 4.384106 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 93.2 1.1500000000000002e-21   NR MES1910907.1 1215613 g27491 i0 66.7 2.97 66 22 99 0 199 2 54 119 MES1910907.1 hypothetical protein [Cercozoa sp. M6MM] diamond 594 93.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
15232906 15232906 PRJNA758398_S_NODE_32672_length_187_cov_1.108696_g32531_i0 PRJNA758398 32672 187 1.108696 2.07326152 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 95.9 3.509999999999999e-23   NR AAY21202.1 227086 g32531 i0 69 5.2620320855615 58 18 93 0 14 187 16 73 AAY21202.1 Rpl7A, partial [Bigelowiella natans] diamond 984 95.9 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
18591234 18591234 PRJNA758398_S_NODE_14255_length_261_cov_3.061321_g14114_i0 PRJNA758398 14255 261 3.061321 7.99004781 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 134 4.55e-35   NR MES1907382.1 1215613 g14114 i0 71.3 2.98850574712644 87 24 98.9 1 259 2 248 334 MES1907382.1 hypothetical protein [Cercozoa sp. M6MM] diamond 780 134 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
19866508 19866508 PRJNA758398_S_NODE_2076_length_637_cov_8.280612_g1949_i0 PRJNA758398 2076 637 8.280612 52.74749844 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 182 1.12e-54   NR AAT09077.1 227086 g1949 i0 71.2 0.588697017268446 125 36 58.9 0 631 257 1 125 AAT09077.1 transcription factor BTF3 [Bigelowiella natans] diamond 375 182 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
19866957 19866957 PRJNA758398_S_NODE_8376_length_333_cov_1.552817_g8235_i0 PRJNA758398 8376 333 1.552817 5.17088061 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 179 1.84e-49   NR MES1909743.1 1215613 g8235 i0 79.1 2.97297297297297 110 23 99.1 0 2 331 937 1046 MES1909743.1 hypothetical protein [Cercozoa sp. M6MM] diamond 990 179 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
22417371 22417371 PRJNA758398_S_NODE_7558_length_349_cov_2.453333_g7417_i0 PRJNA758398 7558 349 2.453333 8.56213217 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 80.5 2.8e-15   NR MES1911029.1 1215613 g7417 i0 58 1.12607449856734 69 29 59.3 0 347 141 197 265 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 393 80.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
24156106 24156106 PRJNA758398_S_NODE_54519_length_161_cov_0.910714_g54378_i0 PRJNA758398 54519 161 0.910714 1.46624954 Gymnochlora stellata 67809 SAR_Eukaryotes SAR_Eukaryotes 94.7 1.71e-22   NR ABW35315.1 67809 g54378 i0 83 1.97515527950311 53 9 98.8 0 1 159 80 132 ABW35315.1 Rab1A1 [Gymnochlora stellata] diamond 318 94.7 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
26609625 26609625 PRJNA758398_S_NODE_27381_length_201_cov_1.342105_g27240_i0 PRJNA758398 27381 201 1.342105 2.69763105 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 71.6 4.81e-14   NR MES1914773.1 1215613 g27240 i0 73.9 0.686567164179104 46 12 68.7 0 2 139 80 125 MES1914773.1 hypothetical protein [Cercozoa sp. M6MM] diamond 138 71.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26619577 26619577 PRJNA758398_S_NODE_20641_length_224_cov_1.748571_g20500_i0 PRJNA758398 20641 224 1.748571 3.91679904 root 1 Root_unresolved Root_unresolved 95.1 2.57e-21   NR MES1914601.1 1215613 g20500 i0 59.4 7.03125 69 28 92.4 0 209 3 236 304 MES1914601.1 UDP-glucose 6-dehydrogenase 1 [Cercozoa sp. M6MM] diamond 1575 95.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26799786 26799786 PRJNA758398_S_NODE_10501_length_299_cov_2.592000_g10360_i0 PRJNA758398 10501 299 2.592 7.75008 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 101 1.06e-24   NR MES1913460.1 1215613 g10360 i0 53.1 0.963210702341137 96 41 93.3 2 282 4 5 99 MES1913460.1 hypothetical protein [Cercozoa sp. M6MM] diamond 288 101 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26799811 26799811 PRJNA758398_S_NODE_25501_length_207_cov_1.126582_g25360_i0 PRJNA758398 25501 207 1.126582 2.33202474 Gymnochlora stellata 67809 SAR_Eukaryotes SAR_Eukaryotes 79.3 5.51e-16   NR ACF24562.1 67809 g25360 i0 63.5 0.91304347826087 63 23 91.3 0 3 191 160 222 ACF24562.1 proteasome alpha 5 subunit [Gymnochlora stellata] diamond 189 79.3 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
26831558 26831558 PRJNA758398_S_NODE_18821_length_232_cov_3.311475_g18680_i0 PRJNA758398 18821 232 3.311475 7.682622 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 80.5 2.36e-17   NR MES1912234.1 1215613 g18680 i0 55.4 1.91379310344828 74 30 95.7 2 10 231 49 119 MES1912234.1 hypothetical protein [Cercozoa sp. M6MM] diamond 444 80.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26831609 26831609 PRJNA758398_S_NODE_49321_length_163_cov_1.342105_g49180_i0 PRJNA758398 49321 163 1.342105 2.18763115 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 41.2 0.042   NR MES1914805.1 1215613 g49180 i0 50 0.552147239263804 30 15 55.2 0 101 12 231 260 MES1914805.1 hypothetical protein [Cercozoa sp. M6MM] diamond 90 41.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26841520 26841520 PRJNA758398_S_NODE_47101_length_165_cov_0.879310_g46960_i0 PRJNA758398 47101 165 0.87931 1.4508615 root 1 Root_unresolved Root_unresolved 70.5 2.09e-12   NR MES1912006.1 1215613 g46960 i0 66.7 3.87272727272727 54 18 98.2 0 164 3 391 444 MES1912006.1 hypothetical protein [Cercozoa sp. M6MM] diamond 639 70.9 0.994358251057828 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26926477 26926477 PRJNA758398_S_NODE_16902_length_243_cov_1.577320_g16761_i0 PRJNA758398 16902 243 1.57732 3.8328876 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 83.6 1.62e-16   NR MES1909201.1 1215613 g16761 i0 55.1 0.851851851851852 69 31 85.2 0 207 1 509 577 MES1909201.1 hypothetical protein [Cercozoa sp. M6MM] diamond 207 83.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26926501 26926501 PRJNA758398_S_NODE_37762_length_175_cov_2.023810_g37621_i0 PRJNA758398 37762 175 2.02381 3.5416675 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.00309   NR MES1912635.1 1215613 g37621 i0 38.1 3.24 63 33 97.7 1 2 172 24 86 MES1912635.1 hypothetical protein [Cercozoa sp. M6MM] diamond 567 44.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26989561 26989561 PRJNA758398_S_NODE_49082_length_163_cov_2.236842_g48941_i0 PRJNA758398 49082 163 2.236842 3.64605246 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 45.4 4.45e-4   NR MES1912353.1 1215613 g48941 i0 52.6 2.77914110429448 38 17 68.1 1 3 113 76 113 MES1912353.1 hypothetical protein [Cercozoa sp. M6MM] diamond 453 45.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27337622 27337622 PRJNA758398_S_NODE_13423_length_268_cov_1.986301_g13282_i0 PRJNA758398 13423 268 1.986301 5.32328668 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 47.8 9.08e-4   NR MES1908431.1 1215613 g13282 i0 50 0.470149253731343 42 21 47 0 134 259 943 984 MES1908431.1 hypothetical protein [Cercozoa sp. M6MM] diamond 126 47.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28032335 28032335 PRJNA758398_S_NODE_53845_length_161_cov_0.910714_g53704_i0 PRJNA758398 53845 161 0.910714 1.46624954 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 58.9 1.05e-8   NR MES1916568.1 1215613 g53704 i0 86.2 0.540372670807453 29 4 54 0 66 152 10 38 MES1916568.1 hypothetical protein [Cercozoa sp. M6MM] diamond 87 58.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28884622 28884622 PRJNA758398_S_NODE_34468_length_183_cov_0.977612_g34327_i0 PRJNA758398 34468 183 0.977612 1.78902996 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 44.3 0.00492   NR MES1911123.1 1215613 g34327 i0 41.4 0.950819672131147 58 30 95.1 1 180 7 375 428 MES1911123.1 hypothetical protein [Cercozoa sp. M6MM] diamond 174 44.3 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29358383 29358383 PRJNA758398_S_NODE_26529_length_203_cov_4.448052_g26388_i0 PRJNA758398 26529 203 4.448052 9.02954556 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 84 1.05e-19   NR MES1911722.1 1215613 g26388 i0 78.3 0.679802955665025 46 10 68 0 201 64 7 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 138 84 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30811334 30811334 PRJNA758398_S_NODE_4014_length_472_cov_2.780142_g3873_i0 PRJNA758398 4014 472 2.780142 13.12227024 Gymnochlora stellata 67809 SAR_Eukaryotes SAR_Eukaryotes 115 1.07e-29   NR ACF24561.1 67809 g3873 i0 55.7 0.775423728813559 122 50 75.6 2 3 359 18 138 ACF24561.1 multiprotein bridging factor type 1 [Gymnochlora stellata] diamond 366 115 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
30969514 30969514 PRJNA758398_S_NODE_5014_length_424_cov_1.904000_g4873_i0 PRJNA758398 5014 424 1.904 8.07296 Gymnochlora stellata 67809 SAR_Eukaryotes SAR_Eukaryotes 114 9.36e-29   NR ACF24574.1 67809 g4873 i0 60.7 0.629716981132076 89 35 63 0 424 158 107 195 ACF24574.1 Ras-related small GTPase Rab5 [Gymnochlora stellata] diamond 267 114 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
31822937 31822937 PRJNA758398_S_NODE_52637_length_162_cov_0.902655_g52496_i0 PRJNA758398 52637 162 0.902655 1.4623011 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 56.2 9.56e-8   NR MES1915354.1 1215613 g52496 i0 51.1 0.87037037037037 47 23 87 0 5 145 42 88 MES1915354.1 hypothetical protein [Cercozoa sp. M6MM] diamond 141 56.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32771124 32771124 PRJNA758398_S_NODE_11760_length_284_cov_1.910638_g11619_i0 PRJNA758398 11760 284 1.910638 5.42621192 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 63.9 2.11e-9   NR MES1914001.1 1215613 g11619 i0 46.2 0.982394366197183 93 47 98.2 2 1 279 301 390 MES1914001.1 hypothetical protein [Cercozoa sp. M6MM] diamond 279 63.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM

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