RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "diamond", bioproject = "PRJNA886442" and tax_clade = "Sar"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_phylum 2

tax_superkingdom 1

tax_clade 1

bioproject 1

  • PRJNA886442 · 3 ✖

analysis 1

  • diamond · 3 ✖

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
28863316 28863316 PRJNA886442_P_NODE_9748_length_259_cov_1.446237_g9584_i0 PRJNA886442 9748 259 1.446237 3.74575383 Tetrahymenidae 291294 SAR_Eukaryotes SAR_Eukaryotes 65.9 3.02e-10   NR XP_004024223.1 5932 g9584 i0 44 1.93436293436293 84 47 97.3 0 257 6 3 86 XP_004024223.1 hypothetical protein IMG5_197540 [Ichthyophthirius multifiliis] diamond 501 65.9 1 Eukaryota Sar   Ciliophora Oligohymenophorea Hymenostomatida   Ichthyophthirius Ichthyophthirius multifiliis
29203006 29203006 PRJNA886442_P_NODE_9289_length_265_cov_1.218750_g9125_i0 PRJNA886442 9289 265 1.21875 3.2296875 Symbiodinium sp. CCMP2592 631055 SAR_Eukaryotes SAR_Eukaryotes 45.4 0.00528   NR CAE7343670.1 631055 g9125 i0 35.5 0.70188679245283 62 25 53.2 1 29 169 238 299 CAE7343670.1 tig, partial [Symbiodinium sp. CCMP2592] diamond 186 45.4 1 Eukaryota Sar     Dinophyceae Suessiales Symbiodiniaceae Symbiodinium Symbiodinium sp. CCMP2592
32237182 32237182 PRJNA886442_P_NODE_5498_length_327_cov_0.996063_g5334_i0 PRJNA886442 5498 327 0.996063 3.25712601 Stephanodiscus triporus 2934178 SAR_Eukaryotes SAR_Eukaryotes 51.6 7.56e-5   NR KAL3786910.1 2934178 g5334 i0 57.8 0.412844036697248 45 18 40.4 1 195 326 205 249 KAL3786910.1 hypothetical protein ACHAW5_011289 [Stephanodiscus triporus] diamond 135 51.6 1 Eukaryota Sar   Bacillariophyta Coscinodiscophyceae Stephanodiscales Stephanodiscaceae Stephanodiscus Stephanodiscus triporus

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