RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

3 rows where analysis = "blastn", bioproject = "PRJNA1199330" 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

  • PRJNA1199330 · 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
4152315 4152315 PRJNA1199330_P_NODE_25224_length_409_cov_2.232143_g24528_i0 PRJNA1199330 25224 409 2.232143 9.12946487 Phytophthora nicotianae 4792 SAR_Eukaryotes SAR_Eukaryotes 115 4.94e-21   NTclustered gi|675199294|ref|XM_008910284.1| 761204 g24528 i0 84.956 1.05867970660147 113 17 28 0 256 368 310 422 Phytophthora parasitica INRA-310 ubiquitin-conjugating enzyme E2 N mRNA blastn 433 115 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora nicotianae
10528868 10528868 PRJNA1199330_P_NODE_115089_length_243_cov_0.917647_g114390_i0 PRJNA1199330 115089 243 0.917647 2.22988221 Phytophthora mirabilis 129356 SAR_Eukaryotes SAR_Eukaryotes 135 2.11e-27   NTclustered gi|1233049529|gb|KX250492.1| 129356 g114390 i0 78.641 49.9135802469136 206 40 84 3 5 208 1662 1459 Phytophthora mirabilis isolate 30C2(authentic) heat shock protein 90 gene, partial cds blastn 12129 135 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora mirabilis
19451016 19451016 PRJNA1199330_P_NODE_108176_length_247_cov_4.189655_g107477_i0 PRJNA1199330 108176 247 4.189655 10.34844785 Phytophthora lilii 2077276 SAR_Eukaryotes SAR_Eukaryotes 154 5.95e-33   NTclustered gi|829497274|dbj|AB856779.1| 2077276 g107477 i0 79.545 14.178137651821899 220 41 88 4 29 246 1 218 Phytophthora lilii gene for ribosomal protein L10, partial cds, isolate: EL_8701 blastn 3502 154 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora lilii

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