RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

12 rows where analysis = "diamond", bioproject = "PRJNA874604" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 12 ✖

tax_clade 1

bioproject 1

  • PRJNA874604 · 12 ✖

analysis 1

  • diamond · 12 ✖

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
6341696 6341696 PRJNA874604_P_NODE_1285_length_1276_cov_3.504572_g1116_i0 PRJNA874604 1285 1276 3.504572 44.71833872 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 488 1.0099999999999999e-167   NR MES1909605.1 1215613 g1116 i0 72.4 3.12225705329154 322 89 75.7 0 1276 311 112 433 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 3984 491 0.993890020366599 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
8504524 8504524 PRJNA874604_P_NODE_26107_length_363_cov_1.551724_g25755_i0 PRJNA874604 26107 363 1.551724 5.63275812 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 157 2.89e-46   NR AAY21202.1 227086 g25755 i0 68.3 7.91735537190083 120 37 99.2 1 361 2 38 156 AAY21202.1 Rpl7A, partial [Bigelowiella natans] diamond 2874 157 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
22528306 22528306 PRJNA874604_P_NODE_27578_length_356_cov_1.067138_g27226_i0 PRJNA874604 27578 356 1.067138 3.79901128 Gymnochlora stellata 67809 SAR_Eukaryotes SAR_Eukaryotes 184 3.19e-57   NR ACF24571.1 67809 g27226 i0 84.2 3.39606741573034 101 16 85.1 0 4 306 48 148 ACF24571.1 ubiquitin-conjugating enzyme 2 [Gymnochlora stellata] diamond 1209 184 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
26706760 26706760 PRJNA874604_P_NODE_87601_length_245_cov_0.895349_g87249_i0 PRJNA874604 87601 245 0.895349 2.19360505 Thaumatomonas sp. TMT 45100 SAR_Eukaryotes SAR_Eukaryotes 92.4 4.95e-22   NR ACF24503.1 407209 g87249 i0 56.2 1.08979591836735 89 30 98 1 242 3 21 109 ACF24503.1 eukaryotic translation elongation factor 2, partial [Thaumatomonas sp. TMT002] diamond 267 92.4 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. TMT002
26833790 26833790 PRJNA874604_P_NODE_59861_length_266_cov_1.549223_g59509_i0 PRJNA874604 59861 266 1.549223 4.12093318 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 47.8 7.91e-4   NR MES1907597.1 1215613 g59509 i0 38.5 0.733082706766917 65 37 72.2 2 73 264 2 64 MES1907597.1 hypothetical protein [Cercozoa sp. M6MM] diamond 195 47.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27402999 27402999 PRJNA874604_P_NODE_83363_length_246_cov_1.335260_g83011_i0 PRJNA874604 83363 246 1.33526 3.2847396 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 94 1.9300000000000003e-21   NR MES1915483.1 1215613 g83011 i0 53.1 1.97560975609756 81 38 98.8 0 244 2 25 105 MES1915483.1 hypothetical protein [Cercozoa sp. M6MM] diamond 486 94 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28065910 28065910 PRJNA874604_P_NODE_83785_length_246_cov_0.890173_g83433_i0 PRJNA874604 83785 246 0.890173 2.18982558 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 65.9 1.92e-10   NR MES1911654.1 1215613 g83433 i0 42.5 0.890243902439024 73 42 89 0 28 246 51 123 MES1911654.1 hypothetical protein [Cercozoa sp. M6MM] diamond 219 65.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28129182 28129182 PRJNA874604_P_NODE_16565_length_435_cov_1.798343_g16213_i0 PRJNA874604 16565 435 1.798343 7.82279205 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 65.1 6.7e-10   NR MES1913617.1 1215613 g16213 i0 36.6 0.979310344827586 142 56 96.6 6 433 14 64 173 MES1913617.1 hypothetical protein [Cercozoa sp. M6MM] diamond 426 65.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29076456 29076456 PRJNA874604_P_NODE_68148_length_251_cov_1.926966_g67796_i0 PRJNA874604 68148 251 1.926966 4.83668466 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 122 9.98e-34   NR ADK26622.1 323453 g67796 i0 83.3 0.860557768924303 72 12 86.1 0 34 249 1 72 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 216 122 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
29328837 29328837 PRJNA874604_P_NODE_22049_length_388_cov_1.838095_g21697_i0 PRJNA874604 22049 388 1.838095 7.1318086 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 178 1.11e-52   NR MES1911029.1 1215613 g21697 i0 66.2 1.02835051546392 133 41 99.7 1 2 388 81 213 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 399 178 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30497641 30497641 PRJNA874604_P_NODE_71833_length_250_cov_0.870056_g71481_i0 PRJNA874604 71833 250 0.870056 2.17514 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 89 8.63e-21   NR MES1916801.1 1215613 g71481 i0 54.3 1.848 81 36 97.2 1 248 6 28 107 MES1916801.1 hypothetical protein [Cercozoa sp. M6MM] diamond 462 89 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31255880 31255880 PRJNA874604_P_NODE_100275_length_241_cov_0.916667_g99923_i0 PRJNA874604 100275 241 0.916667 2.20916747 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 74.7 9.93e-14   NR AAT09089.1 227086 g99923 i0 43 0.983402489626556 79 43 95.9 1 236 6 44 122 AAT09089.1 calmodulin like myosin light chain [Bigelowiella natans] diamond 237 74.7 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans

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