RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

23 rows where analysis = "diamond", bioproject = "PRJNA520845" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 23 ✖

tax_clade 1

bioproject 1

  • PRJNA520845 · 23 ✖

analysis 1

  • diamond · 23 ✖

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
488028 488028 PRJNA520845_P_NODE_13421_length_1066_cov_6.171198_g12366_i0 PRJNA520845 13421 1066 6.171198 65.78497068 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 375 1.64e-126   NR MES1911029.1 1215613 g12366 i0 64.1 0.855534709193246 304 104 85 3 32 937 1 301 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 912 375 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
489449 489449 PRJNA520845_P_NODE_186881_length_272_cov_1.547739_g185382_i0 PRJNA520845 186881 272 1.547739 4.20985008 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 137 9.07e-38   NR ADK26624.1 323453 g185382 i0 68.5 1.01470588235294 92 27 99.3 1 271 2 2 93 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 276 137 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
3043673 3043673 PRJNA520845_P_NODE_67603_length_452_cov_2.029024_g66104_i0 PRJNA520845 67603 452 2.029024 9.17118848 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 128 3.5800000000000004e-33   NR ADK26624.1 323453 g66104 i0 73.3 0.570796460176991 86 23 57.1 0 450 193 191 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 258 128 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
6869609 6869609 PRJNA520845_P_NODE_33126_length_660_cov_2.321976_g31676_i0 PRJNA520845 33126 660 2.321976 15.3250416 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 268 1.1499999999999996e-87   NR MES1912193.1 1215613 g31676 i0 61.1 3.74545454545455 208 81 94.5 0 643 20 31 238 MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] diamond 2472 268 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
9417057 9417057 PRJNA520845_P_NODE_164568_length_290_cov_1.235023_g163069_i0 PRJNA520845 164568 290 1.235023 3.5815667 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 159 4.19e-46   NR MES1912635.1 1215613 g163069 i0 77.1 2.96896551724138 96 22 99.3 0 1 288 91 186 MES1912635.1 hypothetical protein [Cercozoa sp. M6MM] diamond 861 159 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
10697065 10697065 PRJNA520845_P_NODE_87549_length_397_cov_1.049383_g86050_i0 PRJNA520845 87549 397 1.049383 4.16605051 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 189 4.6399999999999984e-55   NR MES1914930.1 1215613 g86050 i0 64.4 1.99496221662469 132 47 99.7 0 1 396 63 194 MES1914930.1 Inositol-3-phosphate synthase [Cercozoa sp. M6MM] diamond 792 189 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
13243543 13243543 PRJNA520845_P_NODE_192091_length_268_cov_1.476923_g190592_i0 PRJNA520845 192091 268 1.476923 3.95815364 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 156 3.6e-47   NR ADK26622.1 323453 g190592 i0 88.4 0.962686567164179 86 10 96.3 0 258 1 1 86 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 258 156 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
15796145 15796145 PRJNA520845_P_NODE_98833_length_374_cov_1.112957_g97334_i0 PRJNA520845 98833 374 1.112957 4.16245918 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 100 7.04e-22   NR MES1910716.1 1215613 g97334 i0 45.5 1.05882352941176 132 64 99.5 2 3 374 531 662 MES1910716.1 hypothetical protein [Cercozoa sp. M6MM] diamond 396 100 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
23443724 23443724 PRJNA520845_P_NODE_25559_length_760_cov_2.104803_g24171_i0 PRJNA520845 25559 760 2.104803 15.9965028 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 156 8.299999999999998e-41   NR BAJ14650.1 39717 g24171 i0 78.5 3.64342105263158 93 20 36.7 0 760 482 341 433 BAJ14650.1 elongation factor 1alpha, partial [Paulinella chromatophora] diamond 2769 156 1 Eukaryota Sar   Cercozoa Imbricatea Euglyphida Paulinellidae Paulinella Paulinella chromatophora
24063801 24063801 PRJNA520845_P_NODE_43259_length_572_cov_1.979960_g41778_i0 PRJNA520845 43259 572 1.97996 11.3253712 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 259 2.14e-83   NR MES1911029.1 1215613 g41778 i0 72.1 8.53846153846154 179 49 93.4 1 37 570 1 179 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 4884 259 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
24718751 24718751 PRJNA520845_P_NODE_6760_length_1488_cov_7.724382_g6062_i0 PRJNA520845 6760 1488 7.724382 114.93880416 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 638 5.8999999999999985e-226   NR MES1909605.1 1215613 g6062 i0 77.3 3.30645161290323 400 91 80.6 0 1 1200 34 433 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 4920 640 0.996875 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26602194 26602194 PRJNA520845_P_NODE_217301_length_251_cov_0.865169_g215802_i0 PRJNA520845 217301 251 0.865169 2.17157419 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 95.9 4.7e-22   NR MES1916307.1 1215613 g215802 i0 51.3 2.86852589641434 80 39 95.6 0 3 242 106 185 MES1916307.1 hypothetical protein [Cercozoa sp. M6MM] diamond 720 95.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26633992 26633992 PRJNA520845_P_NODE_112241_length_351_cov_2.190647_g110742_i0 PRJNA520845 112241 351 2.190647 7.68917097 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 168 2.19e-48   NR MES1912265.1 1215613 g110742 i0 66.7 3 117 39 100 0 351 1 84 200 MES1912265.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1053 168 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26697336 26697336 PRJNA520845_P_NODE_222481_length_250_cov_0.870056_g220982_i0 PRJNA520845 222481 250 0.870056 2.17514 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 80.9 5.89e-17   NR AAY21202.1 227086 g220982 i0 63.2 2.316 57 21 68.4 0 173 3 11 67 AAY21202.1 Rpl7A, partial [Bigelowiella natans] diamond 579 80.9 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
28087818 28087818 PRJNA520845_P_NODE_190265_length_269_cov_2.724490_g188766_i0 PRJNA520845 190265 269 2.72449 7.3288781 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 52.4 9.89e-7   NR MES1915915.1 1215613 g188766 i0 50 0.758364312267658 68 31 74.7 3 244 44 1 66 MES1915915.1 hypothetical protein [Cercozoa sp. M6MM] diamond 204 52.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28340561 28340561 PRJNA520845_P_NODE_205286_length_257_cov_1.673913_g203787_i0 PRJNA520845 205286 257 1.673913 4.30195641 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 99.8 3.17e-22   NR MES1910324.1 1215613 g203787 i0 59.7 0.782101167315175 67 27 78.2 0 202 2 202 268 MES1910324.1 hypothetical protein [Cercozoa sp. M6MM] diamond 201 99.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28530135 28530135 PRJNA520845_P_NODE_179487_length_278_cov_1.482927_g177988_i0 PRJNA520845 179487 278 1.482927 4.12253706 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 123 4.47e-34   NR MES1914773.1 1215613 g177988 i0 70 0.971223021582734 90 24 93.9 1 261 1 7 96 MES1914773.1 hypothetical protein [Cercozoa sp. M6MM] diamond 270 123 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29098404 29098404 PRJNA520845_P_NODE_206148_length_256_cov_2.491803_g204649_i0 PRJNA520845 206148 256 2.491803 6.37901568 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 76.3 7.21e-14   NR MES1909718.1 1215613 g204649 i0 57.8 0.75 64 27 75 0 10 201 1457 1520 MES1909718.1 hypothetical protein [Cercozoa sp. M6MM] diamond 192 76.3 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29397823 29397823 PRJNA520845_P_NODE_36189_length_630_cov_1.786355_g34729_i0 PRJNA520845 36189 630 1.786355 11.2540365 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 218 3.2599999999999996e-68   NR MES1908571.1 1215613 g34729 i0 55 1.9952380952381 209 94 99.5 0 628 2 8 216 MES1908571.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1257 218 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29508723 29508723 PRJNA520845_P_NODE_218610_length_250_cov_1.079096_g217111_i0 PRJNA520845 218610 250 1.079096 2.69774 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 105 4.73e-26   NR MES1915608.1 1215613 g217111 i0 59 0.996 83 34 99.6 0 1 249 4 86 MES1915608.1 hypothetical protein [Cercozoa sp. M6MM] diamond 249 105 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29982460 29982460 PRJNA520845_P_NODE_193151_length_267_cov_1.587629_g191652_i0 PRJNA520845 193151 267 1.587629 4.23896943 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 87 7.3e-18   NR MES1912357.1 1215613 g191652 i0 48.9 3.10112359550562 90 42 98.9 3 3 266 155 242 MES1912357.1 hypothetical protein [Cercozoa sp. M6MM] diamond 828 87 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30551051 30551051 PRJNA520845_P_NODE_158393_length_296_cov_1.376682_g156894_i0 PRJNA520845 158393 296 1.376682 4.07497872 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 55.8 1.69e-6   NR MES1913866.1 1215613 g156894 i0 64.7 0.344594594594595 34 12 34.5 0 212 111 384 417 MES1913866.1 hypothetical protein [Cercozoa sp. M6MM] diamond 102 55.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31277834 31277834 PRJNA520845_P_NODE_119695_length_341_cov_1.149254_g118196_i0 PRJNA520845 119695 341 1.149254 3.91895614 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 122 9.89e-33   NR AAY21202.1 227086 g118196 i0 71.4 1.35483870967742 77 22 67.7 0 111 341 18 94 AAY21202.1 Rpl7A, partial [Bigelowiella natans] diamond 462 122 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);;