RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

7 rows where analysis = "blastn", bioproject = "PRJEB29441" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 7 ✖

tax_clade 1

bioproject 1

  • PRJEB29441 · 7 ✖

analysis 1

  • blastn · 7 ✖

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
988145 988145 PRJEB29441_P_NODE_10621_length_345_cov_9.060811_g10180_i0 PRJEB29441 10621 345 9.060811 31.25979795 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 632 9.17e-177   NTclustered gi|363498776|gb|JN662487.1| 120398 g10180 i0 99.71 99.8608695652174 345 1 100 0 1 345 721 377 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 34452 638 0.990595611285266 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
2576460 2576460 PRJEB29441_P_NODE_31423_length_187_cov_1.108696_g30982_i0 PRJEB29441 31423 187 1.108696 2.07326152 Thraustotheca clavata 74557 SAR_Eukaryotes SAR_Eukaryotes 134 5.56e-27   NTclustered gi|59894163|gb|AY729864.1| 74557 g30982 i0 79.679 2.39572192513369 187 36 99 2 1 186 1203 1018 Thraustotheca clavata heat shock protein 90 gene, partial cds blastn 448 134 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Thraustotheca Thraustotheca clavata
8953617 8953617 PRJEB29441_P_NODE_35988_length_174_cov_1.328000_g35547_i0 PRJEB29441 35988 174 1.328 2.31072 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 82.4 1.87e-11   NTclustered gi|325194684|emb|FR825494.1| 890382 g35547 i0 76.19 1.93103448275862 168 33 95 6 10 174 202 39 Albugo laibachii Nc14, genomic contig CONTIG_2365_NC14_v4_847_33331 blastn 336 82.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
11504265 11504265 PRJEB29441_P_NODE_10730_length_343_cov_3.017007_g10289_i0 PRJEB29441 10730 343 3.017007 10.34833401 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 617 2.55e-172   NTclustered gi|698793876|ref|XR_717098.1| 112090 g10289 i0 99.125 101.68804664723 343 3 100 0 1 343 2156 2498 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 34879 617 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
11504888 11504888 PRJEB29441_P_NODE_45610_length_162_cov_0.902655_g45169_i0 PRJEB29441 45610 162 0.902655 1.4623011 uncultured Oomycota 179533 SAR_Eukaryotes SAR_Eukaryotes 75 2.88e-9   NTclustered gi|307939675|gb|HM441352.1| 179533 g45169 i0 83.75 13.0802469135802 80 11 49 2 35 114 291 368 Uncultured oomycete clone o8-Alf-22 large subunit ribosomal RNA gene, partial sequence blastn 2119 75 1 Eukaryota Sar   Oomycota         uncultured Oomycota
12467363 12467363 PRJEB29441_P_NODE_28790_length_195_cov_1.917808_g28349_i0 PRJEB29441 28790 195 1.917808 3.7397256 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 289 1.1799999999999998e-73   NTclustered gi|1812102600|ref|NC_045922.1| 143451 g28349 i0 93.333 101.066666666667 195 13 100 0 1 195 2284 2090 Plasmopara viticola mitochondrion, complete genome blastn 19708 289 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Plasmopara Plasmopara viticola
14054669 14054669 PRJEB29441_P_NODE_27692_length_199_cov_2.033333_g27251_i0 PRJEB29441 27692 199 2.033333 4.04633267 Aphanomyces sp. 1982524 SAR_Eukaryotes SAR_Eukaryotes 368 1.51e-97   NTclustered gi|1578815424|gb|MK546601.1| 1982524 g27251 i0 100 99.929648241206 199 0 100 0 1 199 601 799 Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence blastn 19886 368 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces sp.

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