RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

24 rows where analysis = "diamond", bioproject = "PRJNA1000943" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 24 ✖

tax_clade 1

bioproject 1

  • PRJNA1000943 · 24 ✖

analysis 1

  • diamond · 24 ✖

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
2695385 2695385 PRJNA1000943_P_NODE_6803_length_312_cov_1.451883_g6665_i0 PRJNA1000943 6803 312 1.451883 4.52987496 Thaumatomonas sp. TMT 45100 SAR_Eukaryotes SAR_Eukaryotes 163 3.36e-47   NR ACF24486.1 407209 g6665 i0 79.6 9.83653846153846 98 20 94.2 0 15 308 61 158 ACF24486.1 70 kDa heat shock protein, partial [Thaumatomonas sp. TMT002] diamond 3069 163 1 Eukaryota Sar   Cercozoa Imbricatea Thaumatomonadida Thaumatomastigidae Thaumatomonas Thaumatomonas sp. TMT002
9927238 9927238 PRJNA1000943_P_NODE_208_length_1376_cov_4.871067_g164_i0 PRJNA1000943 208 1376 4.871067 67.02588192 Cercozoa sp. DMV 1342330 SAR_Eukaryotes SAR_Eukaryotes 593 1.8e-208   NR BAN37425.1 1342330 g164 i0 81.1 0.760901162790698 349 66 76.1 0 1374 328 94 442 BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV] diamond 1047 593 1 Eukaryota Sar   Cercozoa         Cercozoa sp. DMV
9927246 9927246 PRJNA1000943_P_NODE_2868_length_454_cov_2.383202_g2731_i0 PRJNA1000943 2868 454 2.383202 10.81973708 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 241 1.56e-77   NR ADK26624.1 323453 g2731 i0 78.7 0.991189427312775 150 32 99.1 0 3 452 86 235 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 450 241 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
12898764 12898764 PRJNA1000943_P_NODE_12071_length_250_cov_1.762712_g11933_i0 PRJNA1000943 12071 250 1.762712 4.40678 Gymnochlora stellata 67809 SAR_Eukaryotes SAR_Eukaryotes 132 2.21e-36   NR ACF24565.1 67809 g11933 i0 85.5 0.996 83 12 99.6 0 2 250 21 103 ACF24565.1 proteasome alpha 4 subunit [Gymnochlora stellata] diamond 249 132 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata
15027122 15027122 PRJNA1000943_P_NODE_8052_length_291_cov_1.357798_g7914_i0 PRJNA1000943 8052 291 1.357798 3.95119218 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 114 3.4e-28   NR MES1913390.1 1215613 g7914 i0 46.9 0.989690721649485 96 51 99 0 4 291 212 307 MES1913390.1 hypothetical protein [Cercozoa sp. M6MM] diamond 288 114 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
15447815 15447815 PRJNA1000943_P_NODE_1453_length_628_cov_2.144144_g1320_i0 PRJNA1000943 1453 628 2.144144 13.46522432 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 292 4.039999999999999e-96   NR MES1911029.1 1215613 g1320 i0 70.6 1.00796178343949 211 58 98.9 1 2 622 9 219 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 633 292 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
19270730 19270730 PRJNA1000943_P_NODE_4796_length_362_cov_2.591696_g4659_i0 PRJNA1000943 4796 362 2.5916960000000002 9.38193952 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 173 2.51e-53   NR ADK26622.1 323453 g4659 i0 78.3 0.878453038674033 106 23 87.8 0 44 361 1 106 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 318 173 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
20546266 20546266 PRJNA1000943_P_NODE_1437_length_631_cov_2.152330_g1304_i0 PRJNA1000943 1437 631 2.15233 13.5812023 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 227 1.74e-70   NR MES1913008.1 1215613 g1304 i0 53.1 3 211 97 99.4 2 1 627 50 260 MES1913008.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1893 227 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
24371073 24371073 PRJNA1000943_P_NODE_680_length_880_cov_5.753408_g577_i0 PRJNA1000943 680 880 5.753408 50.6299904 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 365 1.43e-123   NR MES1911029.1 1215613 g577 i0 62.6 0.985227272727273 289 104 97.2 1 14 868 1 289 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 867 365 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
24371081 24371081 PRJNA1000943_P_NODE_7420_length_302_cov_1.021834_g7282_i0 PRJNA1000943 7420 302 1.021834 3.08593868 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 123 2.72e-33   NR AAT09077.1 227086 g7282 i0 64 0.993377483443709 100 33 99.3 1 301 2 66 162 AAT09077.1 transcription factor BTF3 [Bigelowiella natans] diamond 300 123 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
25225338 25225338 PRJNA1000943_P_NODE_120_length_1648_cov_5.478730_g96_i0 PRJNA1000943 120 1648 5.47873 90.2894704 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 674 2.23e-239   NR MES1909605.1 1215613 g96 i0 77.5 4.66565533980583 418 94 76.1 0 1 1254 16 433 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 7689 678 0.994100294985251 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26876440 26876440 PRJNA1000943_P_NODE_3681_length_406_cov_1.870871_g3544_i0 PRJNA1000943 3681 406 1.870871 7.59573626 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 144 1.17e-41   NR AAP34635.1 227086 g3544 i0 88.6 1.16748768472906 79 9 58.4 0 406 170 52 130 AAP34635.1 ubiquitin/ribosomal protein L40 fusion [Bigelowiella natans] diamond 474 144 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
27034326 27034326 PRJNA1000943_P_NODE_5202_length_350_cov_1.675090_g5065_i0 PRJNA1000943 5202 350 1.67509 5.862815 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 107 1.0999999999999998e-24   NR MES1915849.1 1215613 g5065 i0 58.4 0.66 77 32 66 0 311 81 198 274 MES1915849.1 hypothetical protein [Cercozoa sp. M6MM] diamond 231 107 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27413882 27413882 PRJNA1000943_P_NODE_12123_length_250_cov_0.881356_g11985_i0 PRJNA1000943 12123 250 0.881356 2.20339 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 105 8.72e-25   NR MES1909316.1 1215613 g11985 i0 59 0.996 83 33 99.6 1 1 249 122 203 MES1909316.1 hypothetical protein [Cercozoa sp. M6MM] diamond 249 105 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27603260 27603260 PRJNA1000943_P_NODE_5304_length_347_cov_1.890511_g5166_i0 PRJNA1000943 5304 347 1.890511 6.56007317 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 125 4.6299999999999994e-35   NR AAP34642.1 227086 g5166 i0 72.1 0.743515850144092 86 23 73.5 1 342 88 5 90 AAP34642.1 small ubiquitin-like modifier [Bigelowiella natans] diamond 258 125 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
27729718 27729718 PRJNA1000943_P_NODE_2484_length_485_cov_1.946602_g2347_i0 PRJNA1000943 2484 485 1.946602 9.4410197 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 80.5 7.19e-16   NR ADK47156.1 323453 g2347 i0 90.5 0.25979381443299 42 4 26 0 1 126 104 145 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 126 80.5 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
28045052 28045052 PRJNA1000943_P_NODE_10365_length_260_cov_1.668449_g10227_i0 PRJNA1000943 10365 260 1.668449 4.3379674 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 87.4 3.26e-18   NR MES1910793.1 1215613 g10227 i0 51.2 0.969230769230769 84 41 96.9 0 5 256 216 299 MES1910793.1 hypothetical protein [Cercozoa sp. M6MM] diamond 252 87.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28297614 28297614 PRJNA1000943_P_NODE_11926_length_251_cov_0.876404_g11788_i0 PRJNA1000943 11926 251 0.876404 2.19977404 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 105 2.9199999999999998e-24   NR MES1908318.1 1215613 g11788 i0 59 0.99203187250996006 83 34 99.2 0 249 1 442 524 MES1908318.1 hypothetical protein [Cercozoa sp. M6MM] diamond 249 105 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28708305 28708305 PRJNA1000943_P_NODE_13227_length_247_cov_1.344828_g13089_i0 PRJNA1000943 13227 247 1.344828 3.32172516 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 67 1.12e-10   NR MES1908036.1 1215613 g13089 i0 48.1 1.93117408906883 79 40 96 1 10 246 552 629 MES1908036.1 hypothetical protein [Cercozoa sp. M6MM] diamond 477 67 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29402776 29402776 PRJNA1000943_P_NODE_3749_length_403_cov_2.021212_g3612_i0 PRJNA1000943 3749 403 2.021212 8.14548436 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 159 1.4e-45   NR ADK26624.1 323453 g3612 i0 68.2 0.818858560794045 110 35 81.9 0 1 330 167 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 330 159 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
29718277 29718277 PRJNA1000943_P_NODE_5230_length_349_cov_2.456522_g5092_i0 PRJNA1000943 5230 349 2.456522 8.57326178 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 65.1 1.42e-10   NR AAT09102.1 227086 g5092 i0 36.5 1.46131805157593 85 54 73.1 0 27 281 1 85 AAT09102.1 cysteine proteinase, partial [Bigelowiella natans] diamond 510 65.1 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
29876524 29876524 PRJNA1000943_P_NODE_391_length_1096_cov_3.733138_g324_i0 PRJNA1000943 391 1096 3.733138 40.91519248 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 364 5.96e-122   NR MES1911029.1 1215613 g324 i0 61.6 0.840328467153285 307 112 82.9 2 19 927 1 305 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 921 364 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31045750 31045750 PRJNA1000943_P_NODE_12795_length_248_cov_1.782857_g12657_i0 PRJNA1000943 12795 248 1.782857 4.42148536 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 57.4 2.19e-7   NR MES1913540.1 1215613 g12657 i0 35.2 0.858870967741935 71 44 83.5 1 246 40 209 279 MES1913540.1 hypothetical protein [Cercozoa sp. M6MM] diamond 213 57.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32342495 32342495 PRJNA1000943_P_NODE_6859_length_311_cov_1.310924_g6721_i0 PRJNA1000943 6859 311 1.310924 4.07697364 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 78.6 1.77e-14   NR MES1911487.1 1215613 g6721 i0 47.4 0.916398713826367 95 48 91.6 2 2 286 300 392 MES1911487.1 hypothetical protein [Cercozoa sp. M6MM] diamond 285 78.6 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);;