RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where analysis = "diamond", bioproject = "PRJEB8827" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 6 ✖

tax_clade 1

bioproject 1

  • PRJEB8827 · 6 ✖

analysis 1

  • diamond · 6 ✖

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
32930994 32930994 PRJEB8827b_S_NODE_31905_length_174_cov_2.928058_g31853_i0 PRJEB8827 31905 174 2.928058 5.09482092 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 87.8 2.0500000000000003e-21   NR MES1911722.1 1215613 g31853 i0 73.1 0.896551724137931 52 14 89.7 0 9 164 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 87.8 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32931326 32931326 PRJEB8827g_S_NODE_4753_length_178_cov_2.993007_g4732_i0 PRJEB8827 4753 178 2.993007 5.32755246 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 86.7 6.41e-21   NR MES1911722.1 1215613 g4732 i0 73.1 0.876404494382023 52 14 87.6 0 14 169 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 86.7 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
32982776 32982776 PRJEB8827h_S_NODE_1651_length_248_cov_5.046948_g1632_i0 PRJEB8827 1651 248 5.046948 12.51643104 Lotharella oceanica 641309 SAR_Eukaryotes SAR_Eukaryotes 67.8 4.88e-13   NR AIB09582.1 641309 g1632 i0 57.4 0.653225806451613 54 23 65.3 0 222 61 1 54 AIB09582.1 hypothetical protein M951_chr1100 [Lotharella oceanica] diamond 162 67.8 1 Eukaryota Sar   Cercozoa Chlorarachniophyceae     Lotharella Lotharella oceanica
33050507 33050507 PRJEB8827b_S_NODE_1741_length_250_cov_2.525581_g1689_i0 PRJEB8827 1741 250 2.525581 6.3139525 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 83.2 2.6e-18   NR MES1912234.1 1215613 g1689 i0 54.7 1.8 75 31 90 2 244 20 49 120 MES1912234.1 hypothetical protein [Cercozoa sp. M6MM] diamond 450 83.2 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
33101927 33101927 PRJEB8827f_S_NODE_1966_length_294_cov_7.374517_g1946_i0 PRJEB8827 1966 294 7.374517 21.68107998 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 90.5 9.06e-22   NR MES1911722.1 1215613 g1946 i0 73.1 0.530612244897959 52 14 53.1 0 273 118 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 90.5 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
33118938 33118938 PRJEB8827f_S_NODE_2287_length_279_cov_1123.872951_g2267_i0 PRJEB8827 2287 279 1123.872951 3135.60553329 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 88.2 5.91e-21   NR MES1911722.1 1215613 g2267 i0 73.1 0.559139784946237 52 14 55.9 0 238 83 1 52 MES1911722.1 hypothetical protein [Cercozoa sp. M6MM] diamond 156 88.2 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);;