RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJEB12982 · 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
21037 21037 PRJEB12982_P_NODE_3061_length_440_cov_1.373402_g2900_i0 PRJEB12982 3061 440 1.373402 6.0429688 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 78.7 7.02e-10   NTclustered gi|695382888|ref|XM_009519246.1| 67593 g2900 i0 100 0.547727272727273 42 0 10 0 214 255 398 357 Phytophthora sojae hypothetical protein mRNA blastn 241 78.7 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
3847198 3847198 PRJEB12982_P_NODE_20204_length_162_cov_0.902655_g20041_i0 PRJEB12982 20204 162 0.902655 1.4623011 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 165 1.66e-36   NTclustered gi|698803539|ref|XM_009836497.1| 112090 g20041 i0 87.162 1.85185185185185 148 16 91 3 1 147 1130 985 Aphanomyces astaci leukotriene A-4 hydrolase/aminopeptidase mRNA blastn 300 165 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
6088812 6088812 PRJEB12982_P_NODE_4085_length_375_cov_1.656442_g3922_i0 PRJEB12982 4085 375 1.656442 6.2116575 Verrucalvaceae 120409 SAR_Eukaryotes SAR_Eukaryotes 676 0   NTclustered gi|226818989|gb|FJ794894.1| 637496 g3922 i0 99.202 99.9333333333333 376 2 100 1 1 375 518 893 Aphanomyces sp. APH1 strain APH1_SAN01 18S ribosomal RNA gene, partial sequence blastn 37475 682 0.991202346041056 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces sp. APH1
10223666 10223666 PRJEB12982_P_NODE_16069_length_171_cov_1.672131_g15906_i0 PRJEB12982 16069 171 1.672131 2.85934401 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 145 2.3e-30   NTclustered gi|673035777|ref|XM_008873628.1| 157072 g15906 i0 86.014 1.52631578947368 143 11 84 5 19 161 325 458 Aphanomyces invadans hypothetical protein mRNA blastn 261 145 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
10223810 10223810 PRJEB12982_P_NODE_7969_length_255_cov_1.868932_g7806_i0 PRJEB12982 7969 255 1.868932 4.7657766 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 409 1.19e-109   NTclustered gi|673042664|ref|XM_008877071.1| 157072 g7806 i0 95.669 27.6666666666667 254 11 99 0 2 255 467 214 Aphanomyces invadans ubiquitin-40S ribosomal protein S27a mRNA blastn 7055 409 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
14049045 14049045 PRJEB12982_P_NODE_16652_length_168_cov_0.747899_g16489_i0 PRJEB12982 16652 168 0.747899 1.25647032 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 122 1.06e-23   NTclustered gi|2795047393|ref|XM_067937896.1| 4785 g16489 i0 87.156 1.69642857142857 109 12 64 2 59 166 117 10 Phytophthora cinnamomi Nucleoside diphosphate kinase B (IUM83_13233), partial mRNA blastn 285 122 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
20421671 20421671 PRJEB12982_P_NODE_21077_length_161_cov_0.910714_g20914_i0 PRJEB12982 21077 161 0.910714 1.46624954 Aphanomyces invadans 157072 SAR_Eukaryotes SAR_Eukaryotes 86.1 1.32e-12   NTclustered gi|673039864|ref|XM_008875671.1| 157072 g20914 i0 96.226 0.614906832298137 53 1 32 1 109 160 259 207 Aphanomyces invadans ubiquitin-60S ribosomal protein L40 mRNA blastn 99 86.1 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces invadans
21697743 21697743 PRJEB12982_P_NODE_5058_length_333_cov_1.176056_g4895_i0 PRJEB12982 5058 333 1.176056 3.91626648 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 311 4.69e-80   NTclustered gi|166044823|emb|CU351082.1| 100861 g4895 i0 84.049 58.0570570570571 326 49 97 3 1 324 468 144 Aphanomyces euteiches cDNA blastn 19333 311 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches

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