RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

16 rows where analysis = "diamond", bioproject = "PRJNA743294" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 16 ✖

tax_clade 1

bioproject 1

  • PRJNA743294 · 16 ✖

analysis 1

  • diamond · 16 ✖

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
4550580 4550580 PRJNA743294_P_NODE_3704_length_781_cov_13.956215_g3318_i0 PRJNA743294 3704 781 13.956215 108.99803915 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 272 1.63e-88   NR MES1912193.1 1215613 g3318 i0 57.3 8.99231754161332 234 100 89.9 0 26 727 5 238 MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] diamond 7023 272 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
12201475 12201475 PRJNA743294_P_NODE_3810_length_774_cov_1.927247_g3419_i0 PRJNA743294 3810 774 1.927247 14.91689178 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 210 1.54e-65   NR ADK26622.1 323453 g3419 i0 86.5 0.430232558139535 111 15 43 0 1 333 20 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 333 210 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
14750946 14750946 PRJNA743294_P_NODE_3232_length_834_cov_2.582129_g2866_i0 PRJNA743294 3232 834 2.582129 21.53495586 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 406 1.39e-140   NR ADK26624.1 323453 g2866 i0 73.1 0.974820143884892 271 71 96.8 1 12 818 6 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 813 406 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
14751167 14751167 PRJNA743294_P_NODE_832_length_1398_cov_10.686792_g682_i0 PRJNA743294 832 1398 10.686792 149.40135216 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 513 3.0499999999999993e-177   NR MES1909605.1 1215613 g682 i0 74 2.95278969957082 334 87 71.7 0 1397 396 100 433 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 4128 513 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
21600527 21600527 PRJNA743294_P_NODE_48817_length_250_cov_0.881356_g48361_i0 PRJNA743294 48817 250 0.881356 2.20339 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 114 7.13e-28   NR AAT09099.1 227086 g48361 i0 63.1 5.028 84 30 99.6 1 249 1 310 393 AAT09099.1 protein disulfide isomerase [Bigelowiella natans] diamond 1257 114 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
22399711 22399711 PRJNA743294_P_NODE_59498_length_227_cov_3.259740_g59042_i0 PRJNA743294 59498 227 3.25974 7.3996098 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 141 2.49e-41   NR ADK26622.1 323453 g59042 i0 90.7 0.991189427312775 75 7 99.1 0 227 3 30 104 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 225 141 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
27157136 27157136 PRJNA743294_P_NODE_41322_length_265_cov_1.625000_g40866_i0 PRJNA743294 41322 265 1.625 4.30625 root 1 Root_unresolved Root_unresolved 82.8 2.79e-16   NR MES1912702.1 1215613 g40866 i0 47.1 2.96603773584906 87 43 95.1 1 264 13 190 276 MES1912702.1 hypothetical protein [Cercozoa sp. M6MM] diamond 786 82.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28695062 28695062 PRJNA743294_P_NODE_8827_length_530_cov_3.074398_g8371_i0 PRJNA743294 8827 530 3.074398 16.2943094 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 148 7.3e-42   NR AAY21202.1 227086 g8371 i0 61.3 3.3622641509434 119 45 67.4 1 359 3 18 135 AAY21202.1 Rpl7A, partial [Bigelowiella natans] diamond 1782 148 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
28789352 28789352 PRJNA743294_P_NODE_24727_length_331_cov_1.286822_g24271_i0 PRJNA743294 24727 331 1.286822 4.25938082 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00521   NR MES1906781.1 1215613 g24271 i0 30.9 0.61631419939577 68 35 50.8 2 331 164 124 191 MES1906781.1 hypothetical protein [Cercozoa sp. M6MM] diamond 204 46.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29294720 29294720 PRJNA743294_P_NODE_53649_length_245_cov_0.906977_g53193_i0 PRJNA743294 53649 245 0.906977 2.22209365 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 86.7 1.91e-18   NR MES1915897.1 1215613 g53193 i0 61.1 0.881632653061225 72 28 88.2 0 19 234 11 82 MES1915897.1 hypothetical protein [Cercozoa sp. M6MM] diamond 216 86.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29294726 29294726 PRJNA743294_P_NODE_59129_length_229_cov_2.589744_g58673_i0 PRJNA743294 59129 229 2.589744 5.93051376 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 46.2 0.00171   NR MES1912174.1 1215613 g58673 i0 34.8 2.5938864628821 66 38 85.2 3 202 8 181 242 MES1912174.1 hypothetical protein [Cercozoa sp. M6MM] diamond 594 46.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29483916 29483916 PRJNA743294_P_NODE_44590_length_257_cov_0.989130_g44134_i0 PRJNA743294 44590 257 0.98913 2.5420641 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 56.6 3.72e-7   NR MES1913979.1 1215613 g44134 i0 41 1.96108949416342 83 49 96.9 0 256 8 19 101 MES1913979.1 hypothetical protein [Cercozoa sp. M6MM] diamond 504 56.6 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31348297 31348297 PRJNA743294_P_NODE_18556_length_375_cov_2.900662_g18100_i0 PRJNA743294 18556 375 2.900662 10.8774825 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 89.7 3.8e-18   NR MES1909105.1 1215613 g18100 i0 42.6 0.976 122 59 90.4 4 343 5 2 121 MES1909105.1 hypothetical protein [Cercozoa sp. M6MM] diamond 366 89.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32044150 32044150 PRJNA743294_P_NODE_60798_length_201_cov_5.101562_g60342_i0 PRJNA743294 60798 201 5.101562 10.25413962 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 89.7 5.16e-22   NR MES1911722.1 1215613 g60342 i0 76.5 0.761194029850746 51 12 76.1 0 199 47 2 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 153 89.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32265873 32265873 PRJNA743294_P_NODE_3998_length_756_cov_3.136164_g3600_i0 PRJNA743294 3998 756 3.136164 23.70939984 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 143 1.7699999999999998e-37   NR MES1908779.1 1215613 g3600 i0 38.5 0.98015873015873 247 147 97.2 3 22 756 21 264 MES1908779.1 hypothetical protein [Cercozoa sp. M6MM] diamond 741 143 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32360806 32360806 PRJNA743294_P_NODE_6519_length_609_cov_3.294776_g6068_i0 PRJNA743294 6519 609 3.294776 20.06518584 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 110 6.9e-25   NR MES1914608.1 1215613 g6068 i0 69.2 0.960591133004926 65 20 32 0 199 5 251 315 MES1914608.1 hypothetical protein [Cercozoa sp. M6MM] diamond 585 110 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);;