RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "diamond", bioproject = "PRJNA1073183" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA1073183 · 10 ✖

analysis 1

  • diamond · 10 ✖

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
15489842 15489842 PRJNA1073183_P_NODE_2373_length_801_cov_1.476648_g2296_i0 PRJNA1073183 2373 801 1.476648 11.82795048 Cercozoa sp. DMV 1342330 SAR_Eukaryotes SAR_Eukaryotes 412 2.6099999999999997e-140   NR BAN37425.1 1342330 g2296 i0 71.8 5.97752808988764 266 75 99.6 0 3 800 141 406 BAN37425.1 elongation factor 1-alpha [Cercozoa sp. DMV] diamond 4788 412 1 Eukaryota Sar   Cercozoa         Cercozoa sp. DMV
15489880 15489880 PRJNA1073183_P_NODE_2593_length_771_cov_1.954155_g2513_i0 PRJNA1073183 2593 771 1.954155 15.06653505 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 286 2e-95   NR ADK47156.1 323453 g2513 i0 96.6 0.56420233463035 145 5 56.4 0 726 292 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
16764364 16764364 PRJNA1073183_P_NODE_4494_length_596_cov_2.279159_g4402_i0 PRJNA1073183 4494 596 2.279159 13.58378764 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 256 1.36e-84   NR ADK26622.1 323453 g4402 i0 94.6 0.654362416107383 130 7 65.4 0 30 419 1 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 390 256 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
19312699 19312699 PRJNA1073183_P_NODE_11636_length_378_cov_1.498361_g11541_i0 PRJNA1073183 11636 378 1.498361 5.66380458 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 194 2.08e-61   NR ADK47156.1 323453 g11541 i0 80.5 1.87301587301587 118 23 93.7 0 355 2 1 118 ADK47156.1 ribosomal protein S23a [Heteromita sp. PRA-74] diamond 708 194 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
21864040 21864040 PRJNA1073183_P_NODE_2298_length_815_cov_1.877358_g2221_i0 PRJNA1073183 2298 815 1.877358 15.3004677 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 297 4.59e-97   NR MES1911029.1 1215613 g2221 i0 59.5 1.00858895705521 274 96 99 5 814 8 42 305 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 822 297 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
26846161 26846161 PRJNA1073183_P_NODE_20401_length_289_cov_1.421296_g20306_i0 PRJNA1073183 20401 289 1.421296 4.10754544 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 115 5.18e-29   NR MES1907458.1 1215613 g20306 i0 72 2.60553633217993 75 21 77.9 0 226 2 4 78 MES1907458.1 hypothetical protein [Cercozoa sp. M6MM] diamond 753 115 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
29624755 29624755 PRJNA1073183_P_NODE_9850_length_408_cov_2.752239_g9756_i0 PRJNA1073183 9850 408 2.752239 11.22913512 Bigelowiella natans 227086 SAR_Eukaryotes SAR_Eukaryotes 134 3.38e-37   NR AAY21202.1 227086 g9756 i0 68 2.875 97 31 71.3 0 312 22 17 113 AAY21202.1 Rpl7A, partial [Bigelowiella natans] diamond 1173 134 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Bigelowiella Bigelowiella natans
30825637 30825637 PRJNA1073183_P_NODE_34094_length_241_cov_0.916667_g33999_i0 PRJNA1073183 34094 241 0.916667 2.20916747 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 107 2.21e-25   NR MES1910618.1 1215613 g33999 i0 66.7 2.9253112033195 78 26 97.1 0 239 6 105 182 MES1910618.1 hypothetical protein [Cercozoa sp. M6MM] diamond 705 107 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
30983842 30983842 PRJNA1073183_P_NODE_30754_length_246_cov_0.890173_g30659_i0 PRJNA1073183 30754 246 0.890173 2.18982558 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 62.4 7.41e-10   NR MES1908819.1 1215613 g30659 i0 43.6 1.81707317073171 78 42 93.9 2 246 16 81 157 MES1908819.1 hypothetical protein [Cercozoa sp. M6MM] diamond 447 62.4 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31204372 31204372 PRJNA1073183_P_NODE_20215_length_290_cov_2.129032_g20120_i0 PRJNA1073183 20215 290 2.129032 6.1741928 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 133 7.49e-36   NR MES1911029.1 1215613 g20120 i0 69.1 5.03793103448276 97 29 99.3 1 2 289 59 155 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 1461 133 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);;