RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA1092581" and tax_phylum = "Cercozoa"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Cercozoa · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA1092581 · 4 ✖

analysis 1

  • diamond · 4 ✖

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
4023751 4023751 PRJNA1092581_P_NODE_5044_length_1113_cov_5.700000_g4761_i0 PRJNA1092581 5044 1113 5.7 63.441 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 358 1.9699999999999995e-119   NR MES1911029.1 1215613 g4761 i0 61.6 0.849056603773585 315 106 83.6 5 37 966 1 305 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 945 358 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
5299109 5299109 PRJNA1092581_P_NODE_17985_length_656_cov_2.289880_g17469_i0 PRJNA1092581 17985 656 2.28988 15.0216128 Heteromita sp. PRA-74 323453 SAR_Eukaryotes SAR_Eukaryotes 256 1.4499999999999999e-84   NR ADK26622.1 323453 g17469 i0 94.6 0.594512195121951 130 7 59.5 0 79 468 1 130 ADK26622.1 rps22a [Heteromita sp. PRA-74] diamond 390 256 1 Eukaryota Sar   Cercozoa   Cercomonadida Heteromitidae Heteromita Heteromita sp. PRA-74
28204389 28204389 PRJNA1092581_P_NODE_69466_length_314_cov_4.074689_g68933_i0 PRJNA1092581 69466 314 4.074689 12.79452346 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 119 1.52e-28   NR MES1909874.1 1215613 g68933 i0 60 0.907643312101911 95 27 88.9 2 313 35 701 786 MES1909874.1 hypothetical protein [Cercozoa sp. M6MM] diamond 285 119 1 Eukaryota Sar   Cercozoa         Cercozoa sp. M6MM
31291145 31291145 PRJNA1092581_P_NODE_74675_length_301_cov_4.552632_g74142_i0 PRJNA1092581 74675 301 4.552632 13.70342232 Eukaryota 2759 SAR_Eukaryotes SAR_Eukaryotes 44.7 0.0158   NR MES1907661.1 1215613 g74142 i0 46.3 3.30897009966777 67 33 65.8 2 32 229 727 791 MES1907661.1 hypothetical protein [Cercozoa sp. M6MM] diamond 996 45.1 0.991130820399113 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);;