RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

15 rows where analysis = "diamond", bioproject = "PRJNA986481" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 15 ✖

tax_clade 1

bioproject 1

  • PRJNA986481 · 15 ✖

analysis 1

  • diamond · 15 ✖

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
12453245 12453245 PRJNA986481_P_NODE_7530_length_591_cov_4.245387_g7030_i0 PRJNA986481 7530 591 4.245387 25.09023717 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 346 4.41e-118   NR ADK26624.1 323453 g7030 i0 89.3 0.949238578680203 187 20 94.9 0 2 562 90 276 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 561 346 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
15001936 15001936 PRJNA986481_P_NODE_6812_length_619_cov_6.331579_g6328_i0 PRJNA986481 6812 619 6.331579 39.19247401 Hondaea 2315209 SAR_Eukaryotes SAR_Eukaryotes 261 5.38e-85   NR MES1912193.1 1215613 g6328 i0 61.7 4.78836833602585 196 75 95 0 19 606 43 238 MES1912193.1 60S ribosomal protein L7B [Cercozoa sp. M6MM] diamond 2964 261 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
16276198 16276198 PRJNA986481_P_NODE_19033_length_375_cov_1.858896_g18508_i0 PRJNA986481 19033 375 1.858896 6.97086 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 140 3.42e-38   NR MES1911029.1 1215613 g18508 i0 58.1 1.976 124 48 96 2 1 360 152 275 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 741 140 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27058012 27058012 PRJNA986481_P_NODE_28102_length_309_cov_2.369231_g27577_i0 PRJNA986481 28102 309 2.369231 7.32092379 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 65.9 4.21e-10   NR MES1911029.1 1215613 g27577 i0 50 0.737864077669903 76 38 73.8 0 308 81 225 300 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 228 65.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27279341 27279341 PRJNA986481_P_NODE_22823_length_343_cov_2.540816_g22298_i0 PRJNA986481 22823 343 2.540816 8.71499888 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 85.1 1.43e-16   NR MES1913050.1 1215613 g22298 i0 41.4 0.865889212827988 99 57 86.6 1 302 6 190 287 MES1913050.1 hypothetical protein [Cercozoa sp. M6MM] diamond 297 85.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
27879302 27879302 PRJNA986481_P_NODE_52165_length_250_cov_1.004975_g51640_i0 PRJNA986481 52165 250 1.004975 2.5124375 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 61.2 1.26e-8   NR MES1907871.1 1215613 g51640 i0 34.9 1.032 86 53 99.6 3 1 249 66 151 MES1907871.1 hypothetical protein [Cercozoa sp. M6MM] diamond 258 61.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28573828 28573828 PRJNA986481_P_NODE_31027_length_293_cov_3.413934_g30502_i0 PRJNA986481 31027 293 3.413934 10.00282662 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 47 7.65e-4   NR ADK47156.1 323453 g30502 i0 91.3 0.235494880546075 23 2 23.5 0 10 78 123 145 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 69 47 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
29836790 29836790 PRJNA986481_P_NODE_33091_length_284_cov_1.719149_g32566_i0 PRJNA986481 33091 284 1.719149 4.88238316 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 84 6.63e-17   NR MES1911029.1 1215613 g32566 i0 52.7 1.95422535211268 91 41 96.1 1 1 273 206 294 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 555 84 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30089546 30089546 PRJNA986481_P_NODE_9572_length_528_cov_4.283925_g9053_i0 PRJNA986481 9572 528 4.283925 22.619124 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 123 6.82e-29   NR MES1907871.1 1215613 g9053 i0 40.7 0.852272727272727 150 87 85.2 1 51 500 305 452 MES1907871.1 hypothetical protein [Cercozoa sp. M6MM] diamond 450 123 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31100487 31100487 PRJNA986481_P_NODE_12695_length_460_cov_2.722628_g12171_i0 PRJNA986481 12695 460 2.722628 12.5240888 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 181 2.49e-53   NR MES1911029.1 1215613 g12171 i0 57.7 7.53260869565217 156 62 99.1 1 2 457 113 268 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 3465 181 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31290191 31290191 PRJNA986481_P_NODE_24775_length_330_cov_1.323843_g24250_i0 PRJNA986481 24775 330 1.323843 4.3686819 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 171 1.14e-50   NR ADK26624.1 323453 g24250 i0 73.6 1 110 29 100 0 330 1 161 270 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 330 171 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
31321886 31321886 PRJNA986481_P_NODE_45335_length_257_cov_2.086538_g44810_i0 PRJNA986481 45335 257 2.086538 5.36240266 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 74.3 7.67e-14   NR MES1913771.1 1215613 g44810 i0 39.5 1.93774319066148 81 44 94.6 1 3 245 89 164 MES1913771.1 hypothetical protein [Cercozoa sp. M6MM] diamond 498 74.3 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31764740 31764740 PRJNA986481_P_NODE_47297_length_255_cov_0.980583_g46772_i0 PRJNA986481 47297 255 0.980583 2.50048665 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 70.1 9.84e-12   NR MES1909875.1 1215613 g46772 i0 40.2 2.2 92 48 100 1 255 1 268 359 MES1909875.1 hypothetical protein [Cercozoa sp. M6MM] diamond 561 70.1 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31859555 31859555 PRJNA986481_P_NODE_62257_length_229_cov_2.211111_g61732_i0 PRJNA986481 62257 229 2.211111 5.06344419 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 48.9 4.92e-5   NR MES1912234.1 1215613 g61732 i0 61.3 0.812227074235808 31 12 40.6 0 136 228 85 115 MES1912234.1 hypothetical protein [Cercozoa sp. M6MM] diamond 186 48.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32081092 32081092 PRJNA986481_P_NODE_55978_length_245_cov_5.382653_g55453_i0 PRJNA986481 55978 245 5.382653 13.18749985 Lotharella oceanica 641309 SAR_Eukaryotes SAR_Eukaryotes 67.4 6.67e-13   NR AIB09582.1 641309 g55453 i0 57.4 0.661224489795918 54 23 66.1 0 206 45 1 54 AIB09582.1 hypothetical protein M951_chr1100 [Lotharella oceanica] diamond 162 67.4 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Lotharella Lotharella oceanica

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