RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "diamond", bioproject = "PRJNA573544" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 3

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA573544 · 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
14588184 14588184 PRJNA573544_P_NODE_4912_length_261_cov_1.382979_g4894_i0 PRJNA573544 4912 261 1.382979 3.60957519 Symbiodinium microadriaticum 2951 SAR_Eukaryotes SAR_Eukaryotes 73.2 4.14e-13   NR CAE7827161.1 2951 g4894 i0 45.2 0.839080459770115 73 39 82.8 1 258 43 112 184 CAE7827161.1 CCAMK, partial [Symbiodinium microadriaticum] diamond 219 73.2 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium microadriaticum
27882759 27882759 PRJNA573544_P_NODE_5285_length_253_cov_0.866667_g5267_i0 PRJNA573544 5285 253 0.866667 2.19266751 root 1 Root_unresolved Root_unresolved 84.7 9.55e-18   NR KAL3790894.1 382360 g5267 i0 59.3 2.89328063241107 54 22 64 0 5 166 102 155 KAL3790894.1 hypothetical protein ACHAWO_010891 [Cyclotella atomus] diamond 732 84.7 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Cyclotella Cyclotella atomus
29258199 29258199 PRJNA573544_P_NODE_4429_length_275_cov_1.405941_g4411_i0 PRJNA573544 4429 275 1.405941 3.86633775 Plasmodium yoelii 5861 SAR_Eukaryotes SAR_Eukaryotes 62 9.07e-9   NR XP_728965.1 5861 g4411 i0 38.5 2.73818181818182 78 45 85.1 2 2 235 27 101 XP_728965.1 uncharacterized protein PY17X_1243100 [Plasmodium yoelii] diamond 753 62 1 Eukaryota Sar   Apicomplexa Aconoidasida Haemosporida Plasmodiidae Plasmodium Plasmodium yoelii
31722954 31722954 PRJNA573544_P_NODE_5177_length_254_cov_1.651934_g5159_i0 PRJNA573544 5177 254 1.651934 4.19591236 Cercozoa sp. M6MM 1215613 SAR_Eukaryotes SAR_Eukaryotes 92.8 2.1e-20   NR MES1911029.1 1215613 g5159 i0 55.6 0.956692913385827 81 36 95.7 0 1 243 204 284 MES1911029.1 hypothetical protein [Cercozoa sp. M6MM] diamond 243 92.8 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);;