RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

20 rows where analysis = "diamond", bioproject = "PRJNA744060" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 20 ✖

tax_clade 1

bioproject 1

  • PRJNA744060 · 20 ✖

analysis 1

  • diamond · 20 ✖

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
7576433 7576433 PRJNA744060_P_NODE_43166_length_254_cov_2.486188_g42837_i0 PRJNA744060 43166 254 2.486188 6.31491752 Gymnochlora 67808 SAR_Eukaryotes SAR_Eukaryotes 108 1.9400000000000003e-27   NR ACF24574.1 67809 g42837 i0 86.9 1.46456692913386 61 8 72 0 183 1 7 67 ACF24574.1 Ras-related small GTPase Rab5 [Gymnochlora stellata] diamond 372 108 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
10927587 10927587 PRJNA744060_P_NODE_5169_length_694_cov_5.322061_g4864_i0 PRJNA744060 5169 694 5.322061 36.93510334 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 218 3.01e-67   NR ADK26624.1 323453 g4864 i0 68.9 0.639769452449568 148 46 64 0 2 445 129 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 444 218 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
13477447 13477447 PRJNA744060_P_NODE_52391_length_237_cov_2.518293_g52062_i0 PRJNA744060 52391 237 2.518293 5.96835441 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 119 3.07e-32   NR ADK47156.1 323453 g52062 i0 81.7 0.89873417721519 71 13 89.9 0 25 237 1 71 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 213 119 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
17301193 17301193 PRJNA744060_P_NODE_20854_length_354_cov_2.202847_g20525_i0 PRJNA744060 20854 354 2.2028470000000002 7.79807838 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 124 1.8599999999999998e-32   NR MES1911136.1 1215613 g20525 i0 82.4 0.576271186440678 68 12 57.6 0 352 149 185 252 MES1911136.1 hypothetical protein [Cercozoa sp. M6MM] diamond 204 124 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
23676549 23676549 PRJNA744060_P_NODE_4559_length_739_cov_1.657658_g4261_i0 PRJNA744060 4559 739 1.657658 12.25009262 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 315 1.8099999999999998e-104   NR MES1907996.1 1215613 g4261 i0 66.7 0.998646820027064 246 82 99.9 0 2 739 36 281 MES1907996.1 hypothetical protein [Cercozoa sp. M6MM] diamond 738 315 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
24950258 24950258 PRJNA744060_P_NODE_8620_length_544_cov_1.970276_g8295_i0 PRJNA744060 8620 544 1.970276 10.71830144 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 129 1.9499999999999999e-31   NR MES1908287.1 1215613 g8295 i0 41.8 5.11764705882353 165 77 91 4 45 539 278 423 MES1908287.1 hypothetical protein [Cercozoa sp. M6MM] diamond 2784 129 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26894705 26894705 PRJNA744060_P_NODE_26161_length_318_cov_2.061224_g25832_i0 PRJNA744060 26161 318 2.061224 6.55469232 Gymnochlora stellata 67809 SAR_Eukaryotes SAR_Eukaryotes 108 1.26e-27   NR ACF24561.1 67809 g25832 i0 64.8 0.858490566037736 91 31 84.9 1 18 287 45 135 ACF24561.1 multiprotein bridging factor type 1 [Gymnochlora stellata] diamond 273 108 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
27052775 27052775 PRJNA744060_P_NODE_22122_length_344_cov_2.952030_g21793_i0 PRJNA744060 22122 344 2.95203 10.1549832 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 87.8 1.75e-17   NR MES1912100.1 1215613 g21793 i0 37.3 0.959302325581395 110 69 95.9 0 1 330 411 520 MES1912100.1 hypothetical protein [Cercozoa sp. M6MM] diamond 330 87.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27147091 27147091 PRJNA744060_P_NODE_47662_length_247_cov_1.287356_g47333_i0 PRJNA744060 47662 247 1.287356 3.17976932 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 47.8 6.04e-4   NR ADK26624.1 323453 g47333 i0 73.3 0.364372469635628 30 8 36.4 0 7 96 247 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 90 47.8 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
27210568 27210568 PRJNA744060_P_NODE_54782_length_215_cov_96.535211_g54453_i0 PRJNA744060 54782 215 96.535211 207.55070365 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 90.9 2.21e-22   NR MES1911722.1 1215613 g54453 i0 76.9 0.725581395348837 52 12 72.6 0 22 177 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 90.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27400455 27400455 PRJNA744060_P_NODE_11403_length_474_cov_2.598504_g11075_i0 PRJNA744060 11403 474 2.598504 12.31690896 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 189 1.9900000000000002e-56   NR MES1911029.1 1215613 g11075 i0 60 1.0126582278481 160 60 98.7 1 2 469 109 268 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 480 189 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27716442 27716442 PRJNA744060_P_NODE_13324_length_439_cov_4.300546_g12995_i0 PRJNA744060 13324 439 4.300546 18.87939694 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 148 9.49e-40   NR MES1911487.1 1215613 g12995 i0 49.6 0.854214123006834 125 62 84.7 1 439 68 283 407 MES1911487.1 hypothetical protein [Cercozoa sp. M6MM] diamond 375 148 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27947162 27947162 PRJNA744060_P_NODE_38125_length_269_cov_0.994898_g37796_i0 PRJNA744060 38125 269 0.994898 2.67627562 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 82.4 5.01e-17   NR ACF24570.1 67809 g37796 i0 63.4 9.39033457249071 71 24 77 1 268 62 140 210 ACF24570.1 Ras-related small GTPase Rab2 [Gymnochlora stellata] diamond 2526 82.8 0.995169082125604 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
28379084 28379084 PRJNA744060_P_NODE_24146_length_330_cov_2.922179_g23817_i0 PRJNA744060 24146 330 2.922179 9.6431907 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 108 1.1399999999999999e-24   NR MES1909718.1 1215613 g23817 i0 56 0.909090909090909 100 41 90.9 1 3 302 1425 1521 MES1909718.1 hypothetical protein [Cercozoa sp. M6MM] diamond 300 108 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28505407 28505407 PRJNA744060_P_NODE_25967_length_319_cov_2.231707_g25638_i0 PRJNA744060 25967 319 2.231707 7.11914533 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 58.2 3.27e-7   NR MES1907093.1 1215613 g25638 i0 40.3 0.630094043887147 67 39 62.1 1 3 200 380 446 MES1907093.1 hypothetical protein [Cercozoa sp. M6MM] diamond 201 58.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30274120 30274120 PRJNA744060_P_NODE_1472_length_1193_cov_7.625893_g1302_i0 PRJNA744060 1472 1193 7.625893 90.97690349 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 182 3.19e-50   NR MES1907597.1 1215613 g1302 i0 49.1 1.49371332774518 173 79 43.5 1 406 924 11 174 MES1907597.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1782 182 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31064025 31064025 PRJNA744060_P_NODE_54655_length_220_cov_4.034014_g54326_i0 PRJNA744060 54655 220 4.034014 8.8748308 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 92 8.339999999999999e-23   NR MES1911722.1 1215613 g54326 i0 76.9 0.709090909090909 52 12 70.9 0 211 56 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 92 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31253343 31253343 PRJNA744060_P_NODE_18075_length_379_cov_2.781046_g17746_i0 PRJNA744060 18075 379 2.781046 10.54016434 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 99.4 1.8000000000000001e-22   NR MES1912216.1 1215613 g17746 i0 54.9 0.649076517150396 82 37 64.9 0 377 132 178 259 MES1912216.1 hypothetical protein [Cercozoa sp. M6MM] diamond 246 99.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32234359 32234359 PRJNA744060_P_NODE_8578_length_545_cov_3.264831_g8253_i0 PRJNA744060 8578 545 3.264831 17.79332895 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 132 4.15e-33   NR MES1909105.1 1215613 g8253 i0 43.3 0.990825688073395 180 84 91.9 6 507 7 2 176 MES1909105.1 hypothetical protein [Cercozoa sp. M6MM] diamond 540 132 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32455775 32455775 PRJNA744060_P_NODE_47819_length_247_cov_0.896552_g47490_i0 PRJNA744060 47819 247 0.896552 2.21448344 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 68.2 4.17e-11   NR MES1907809.1 1215613 g47490 i0 86.1 0.88663967611336 36 5 43.7 0 3 110 584 619 MES1907809.1 ABC transporter E member 2 [Cercozoa sp. M6MM] diamond 219 68.2 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);;