RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

4 rows where analysis = "blastn", bioproject = "PRJNA849646" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 4 ✖

tax_clade 1

bioproject 1

  • PRJNA849646 · 4 ✖

analysis 1

  • blastn · 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
2113882 2113882 PRJNA849646_P_NODE_8642_length_290_cov_4.041475_g8524_i0 PRJNA849646 8642 290 4.041475 11.7202775 Phytophthora angustata 3073753 SAR_Eukaryotes SAR_Eukaryotes 180 1.18e-40   NTclustered gi|2689410834|gb|OR588318.1| 3073753 g8524 i0 78.007 8.15862068965517 291 60 99 4 2 290 37 325 Phytophthora angustata isolate NI121 60S ribosomal protein L10 (rpl10) gene, partial cds blastn 2366 180 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora angustata
14866236 14866236 PRJNA849646_P_NODE_2972_length_332_cov_3.644788_g2854_i0 PRJNA849646 2972 332 3.644788 12.10069616 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 318 2.79e-82   NTclustered gi|166044589|emb|CU367498.1| 100861 g2854 i0 100 79.0632530120482 172 0 61 0 1 172 177 348 Aphanomyces euteiches cDNA blastn 26249 318 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
16535896 16535896 PRJNA849646_P_NODE_23753_length_261_cov_2.117021_g23635_i0 PRJNA849646 23753 261 2.117021 5.52542481 root 1 Root_unresolved Root_unresolved 477 3.3099999999999986e-130   NTclustered gi|166046482|emb|CU367599.1| 100861 g23635 i0 99.617 100 261 1 100 0 1 261 153 413 Aphanomyces euteiches cDNA blastn 26100 477 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
25064438 25064438 PRJNA849646_P_NODE_320_length_939_cov_11.543880_g223_i0 PRJNA849646 320 939 11.54388 108.3970332 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 1005 0   NTclustered gi|325194231|emb|FR825088.1| 890382 g223 i0 95.016 7.71884984025559 642 28 82 3 299 939 935 1573 Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 blastn 7248 1005 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii

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