RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where analysis = "blastn", bioproject = "PRJEB28062" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 8 ✖

tax_clade 1

bioproject 1

  • PRJEB28062 · 8 ✖

analysis 1

  • blastn · 8 ✖

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
2262288 2262288 PRJEB28062_P_NODE_114602_length_274_cov_2.029851_g112239_i0 PRJEB28062 114602 274 2.029851 5.56179174 root 1 Root_unresolved Root_unresolved 501 2.08e-137   NTclustered gi|166046558|emb|CU367675.1| 100861 g112239 i0 99.635 103.748175182482 274 1 100 0 1 274 693 420 Aphanomyces euteiches cDNA blastn 28427 501 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
2262314 2262314 PRJEB28062_P_NODE_118242_length_265_cov_1.333333_g115879_i0 PRJEB28062 118242 265 1.333333 3.53333245 root 1 Root_unresolved Root_unresolved 457 4.39e-124   NTclustered gi|166046538|emb|CU367655.1| 100861 g115879 i0 100 18.6415094339623 247 0 93 0 19 265 452 698 Aphanomyces euteiches cDNA blastn 4940 457 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
3538178 3538178 PRJEB28062_P_NODE_51723_length_494_cov_7.391924_g49372_i0 PRJEB28062 51723 494 7.391924 36.51610456 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 708 0   NTclustered gi|33520214|gb|AY273959.1| 162095 g49372 i0 95.133 91.0728744939271 452 15 91 6 26 474 357 804 Peronospora pulveracea large subunit ribosomal RNA gene, partial sequence blastn 44990 708 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora pulveracea
6402166 6402166 PRJEB28062_P_NODE_132466_length_235_cov_2.518519_g130102_i0 PRJEB28062 132466 235 2.518519 5.91851965 Peronospora pulveracea 162095 SAR_Eukaryotes SAR_Eukaryotes 379 8.509999999999998e-101   NTclustered gi|1359853439|gb|MH057164.1| 162095 g130102 i0 99.057 87.1191489361702 212 1 90 1 20 231 620 830 Peronospora pulveracea strain 16-1687 large subunit ribosomal RNA gene, partial sequence blastn 20473 379 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora pulveracea
7677816 7677816 PRJEB28062_P_NODE_81667_length_371_cov_22.050336_g79305_i0 PRJEB28062 81667 371 22.050336 81.80674656 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 311 5.27e-80   NTclustered gi|325195470|emb|FR826264.1| 890382 g79305 i0 91.556 0.606469002695418 225 19 61 0 24 248 225 1 Albugo laibachii Nc14, genomic contig CONTIG_3390_NC14_v4_382_47 blastn 225 311 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
11190324 11190324 PRJEB28062_P_NODE_120529_length_259_cov_2.758065_g118165_i0 PRJEB28062 120529 259 2.758065 7.14338835 root 1 Root_unresolved Root_unresolved 422 1.56e-113   NTclustered gi|166046519|emb|CU367636.1| 100861 g118165 i0 100 88.1081081081081 228 0 88 0 10 237 658 431 Aphanomyces euteiches cDNA blastn 22820 422 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
16600902 16600902 PRJEB28062_P_NODE_135354_length_222_cov_6.026846_g132990_i0 PRJEB28062 135354 222 6.026846 13.37959812 Saprolegnia ferax 4770 SAR_Eukaryotes SAR_Eukaryotes 337 4.85e-88   NTclustered gi|50261276|ref|NC_005984.1| 4770 g132990 i0 97.462 99.3063063063063 197 5 89 0 26 222 9744 9940 Saprolegnia ferax mitochondrion, complete genome blastn 22046 337 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia ferax
20114451 20114451 PRJEB28062_P_NODE_91876_length_339_cov_4.048872_g89514_i0 PRJEB28062 91876 339 4.048872 13.72567608 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 392 1.66e-104   NTclustered gi|2440150|emb|X75631.1| 4788 g89514 i0 93.233 66.4719764011799 266 18 95 0 74 339 3623 3358 P.megasperma gene for 28S ribosomal RNA blastn 22534 392 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora megasperma

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