RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA938397" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 3 ✖

tax_clade 1

bioproject 1

  • PRJNA938397 · 3 ✖

analysis 1

  • blastn · 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
6016316 6016316 PRJNA938397_S_NODE_30545_length_199_cov_24.209877_g30304_i0 PRJNA938397 30545 199 24.209877 48.17765523 Aphanomyces brasiliensis 2525538 SAR_Eukaryotes SAR_Eukaryotes 368 1.51e-97   NTclustered gi|2098511708|gb|OK235679.1| 2525538 g30304 i0 100 100.381909547739 199 0 100 0 1 199 748 550 Aphanomyces brasiliensis voucher CCIBt4545 small subunit ribosomal RNA gene, partial sequence blastn 19976 368 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces brasiliensis
23864802 23864802 PRJNA938397_S_NODE_14699_length_285_cov_24.556452_g14458_i0 PRJNA938397 14699 285 24.556452 69.9858882 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 518 2.16e-142   NTclustered gi|363498776|gb|JN662487.1| 120398 g14458 i0 100 97.6842105263158 280 0 98 0 6 285 323 44 Aphanomyces stellatus strain GF 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence blastn 27840 518 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
25482520 25482520 PRJNA938397_S_NODE_22360_length_233_cov_19.265306_g22119_i0 PRJNA938397 22360 233 19.265306 44.88816298 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 363 8.479999999999997e-96   NTclustered gi|2099741709|gb|OK271022.1| 253176 g22119 i0 99.005 86.2660944206009 201 2 86 0 32 232 920 720 Aphanomyces cladogamus voucher CCIBt3854 small subunit ribosomal RNA gene, partial sequence blastn 20100 366 0.991803278688525 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces cladogamus

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