RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

14 rows where analysis = "diamond", bioproject = "PRJNA608894" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 14 ✖

tax_clade 1

bioproject 1

  • PRJNA608894 · 14 ✖

analysis 1

  • diamond · 14 ✖

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
585119 585119 PRJNA608894_P_NODE_22741_length_412_cov_1.471976_g22244_i0 PRJNA608894 22741 412 1.471976 6.06454112 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 186 4.309999999999998e-56   NR ADK26624.1 323453 g22244 i0 90.6 0.699029126213592 96 9 69.9 0 289 2 2 97 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 288 186 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
3135866 3135866 PRJNA608894_P_NODE_13543_length_621_cov_4.029197_g13065_i0 PRJNA608894 13543 621 4.029197 25.02131337 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 255 2.72e-84   NR ADK26622.1 323453 g13065 i0 94.6 0.628019323671498 130 7 62.8 0 576 187 1 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 390 255 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
3136292 3136292 PRJNA608894_P_NODE_35243_length_304_cov_1.809524_g34744_i0 PRJNA608894 35243 304 1.809524 5.50095296 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 191 1.04e-58   NR ADK26624.1 323453 g34744 i0 90 0.986842105263158 100 10 98.7 0 3 302 161 260 ADK26624.1 elongation factor 2, partial [Heteromita sp. PRA-74] diamond 300 191 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
4412809 4412809 PRJNA608894_P_NODE_26704_length_364_cov_1.587629_g26206_i0 PRJNA608894 26704 364 1.587629 5.77896956 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 218 5.47e-71   NR ADK26622.1 323453 g26206 i0 88.1 0.972527472527473 118 14 97.3 0 11 364 1 118 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 354 218 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
6963872 6963872 PRJNA608894_P_NODE_4346_length_1491_cov_6.721439_g3723_i1 PRJNA608894 4346 1491 6.721439 100.21665549 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 575 7.01e-201   NR MES1909605.1 1215613 g3723 i1 75.3 3.01810865191147 365 90 73.4 0 1489 395 69 433 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 4500 577 0.996533795493934 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
13339164 13339164 PRJNA608894_P_NODE_17071_length_516_cov_3.749436_g16575_i0 PRJNA608894 17071 516 3.749436 19.34708976 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 286 1.0099999999999999e-96   NR ADK47156.1 323453 g16575 i0 96.6 0.843023255813954 145 5 84.3 0 473 39 1 145 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 435 286 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
23537404 23537404 PRJNA608894_P_NODE_10979_length_738_cov_4.063158_g10516_i0 PRJNA608894 10979 738 4.063158 29.98610604 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 188 1.01e-54   NR MES1911029.1 1215613 g10516 i0 53.4 0.829268292682927 204 80 80.9 5 738 142 112 305 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 612 188 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
24811782 24811782 PRJNA608894_P_NODE_3960_length_1580_cov_6.039814_g3723_i0 PRJNA608894 3960 1580 6.039814 95.4290612 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 575 2.1299999999999998e-200   NR MES1909605.1 1215613 g3723 i0 75.3 3.5411392405063302 365 90 69.3 0 1578 484 69 433 MES1909605.1 hypothetical protein [Cercozoa sp. M6MM] diamond 5595 576 0.998263888888889 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
28027756 28027756 PRJNA608894_P_NODE_26045_length_371_cov_1.879195_g25548_i0 PRJNA608894 26045 371 1.879195 6.97181345 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 60.5 2.06e-8   NR MES1913617.1 1215613 g25548 i0 43.7 0.574123989218329 71 39 57.4 1 126 338 104 173 MES1913617.1 hypothetical protein [Cercozoa sp. M6MM] diamond 213 60.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29795655 29795655 PRJNA608894_P_NODE_27191_length_359_cov_2.723776_g26692_i0 PRJNA608894 27191 359 2.723776 9.77835584 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 139 7.199999999999999e-38   NR MES1907458.1 1215613 g26692 i0 69.8 1.62116991643454 96 29 80.2 0 70 357 4 99 MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] diamond 582 139 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30680224 30680224 PRJNA608894_P_NODE_23853_length_397_cov_1.413580_g23356_i0 PRJNA608894 23853 397 1.41358 5.6119126 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 110 3.3799999999999993e-28   NR ADK26622.1 323453 g23356 i0 83.6 0.415617128463476 55 9 41.6 0 2 166 76 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 165 110 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
31217166 31217166 PRJNA608894_P_NODE_47095_length_259_cov_1.258065_g46596_i0 PRJNA608894 47095 259 1.258065 3.25838835 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 144 2.2799999999999993e-42   NR ADK26622.1 323453 g46596 i0 81.3 0.926640926640927 80 15 92.7 0 3 242 51 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 240 144 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
32829830 32829830 PRJNA608894_P_NODE_45660_length_263_cov_2.968421_g45161_i0 PRJNA608894 45660 263 2.968421 7.80694723 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 73.9 2.16e-13   NR MES1916528.1 1215613 g45161 i0 53.8 1.65399239543726 65 27 70.7 1 78 263 3 67 MES1916528.1 hypothetical protein [Cercozoa sp. M6MM] diamond 435 73.9 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32861195 32861195 PRJNA608894_P_NODE_42120_length_275_cov_5.772277_g41621_i0 PRJNA608894 42120 275 5.772277 15.87376175 Gymnochlora stellata 67809 SAR_Eukaryotes SAR_Eukaryotes 97.8 4.66e-24   NR ACF24578.1 67809 g41621 i0 59.5 0.807272727272727 74 30 80.7 0 222 1 1 74 ACF24578.1 60S ribosomal protein L34 [Gymnochlora stellata] diamond 222 97.8 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Gymnochlora Gymnochlora stellata

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