RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

10 rows where analysis = "blastn", bioproject = "PRJNA1111077" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 10 ✖

tax_clade 1

bioproject 1

  • PRJNA1111077 · 10 ✖

analysis 1

  • blastn · 10 ✖

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
215000 215000 PRJNA1111077_P_NODE_4521_length_533_cov_0.976087_g4300_i0 PRJNA1111077 4521 533 0.976087 5.20254371 Aphanomyces euteiches 100861 SAR_Eukaryotes SAR_Eukaryotes 394 7.55e-105   NTclustered gi|166052859|emb|CU367305.1| 100861 g4300 i0 80.151 24.4596622889306 529 103 99 2 1 528 885 358 Aphanomyces euteiches cDNA blastn 13037 394 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
1021109 1021109 PRJNA1111077_P_NODE_36381_length_241_cov_1.833333_g36160_i0 PRJNA1111077 36381 241 1.833333 4.41833253 root 1 Root_unresolved Root_unresolved 446 8.519999999999999e-121   NTclustered gi|166046524|emb|CU367641.1| 100861 g36160 i0 100 42.9460580912863 241 0 100 0 1 241 158 398 Aphanomyces euteiches cDNA blastn 10350 446 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
2765329 2765329 PRJNA1111077_P_NODE_22383_length_279_cov_1.475728_g22162_i0 PRJNA1111077 22383 279 1.475728 4.11728112 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 215 3.1e-51   NTclustered gi|698802469|ref|XM_009835962.1| 112090 g22162 i0 82.645 56.8637992831541 242 42 87 0 18 259 966 725 Aphanomyces astaci V-type H(+)-translocating pyrophosphatase mRNA blastn 15865 215 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
8674208 8674208 PRJNA1111077_P_NODE_13927_length_317_cov_2.524590_g13706_i0 PRJNA1111077 13927 317 2.52459 8.0029503 Salisapilia 983658 SAR_Eukaryotes SAR_Eukaryotes 202 2.79e-47   NTclustered gi|1244022750|gb|MF979505.1| 758748 g13706 i0 88.957 52.5520504731861 163 18 51 0 1 163 643 481 Salisapilia elongata strain NBRC 100786 large subunit ribosomal RNA gene, partial sequence blastn 16659 202 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Salisapiliaceae Salisapilia Salisapilia elongata
9142387 9142387 PRJNA1111077_P_NODE_27248_length_262_cov_1.222222_g27027_i0 PRJNA1111077 27248 262 1.222222 3.20222164 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 316 7.679999999999998e-82   NTclustered gi|695393603|ref|XM_009522363.1| 67593 g27027 i0 88.76 99.4427480916031 258 29 98 0 1 258 76 333 Phytophthora sojae hypothetical protein mRNA blastn 26054 316 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
11693719 11693719 PRJNA1111077_P_NODE_5770_length_478_cov_1.693827_g5549_i0 PRJNA1111077 5770 478 1.693827 8.09649306 Saprolegnia diclina 112098 SAR_Eukaryotes SAR_Eukaryotes 396 1.87e-105   NTclustered gi|669151349|ref|XM_008613015.1| 1156394 g5549 i0 81.667 28.8556485355649 480 84 100 3 1 478 1517 1040 Saprolegnia diclina VS20 adenosylhomocysteinase mRNA blastn 13793 396 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia diclina
16792102 16792102 PRJNA1111077_P_NODE_36234_length_242_cov_0.911243_g36013_i0 PRJNA1111077 36234 242 0.911243 2.20520806 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 148 2.6999999999999997e-31   NTclustered gi|698781800|ref|XM_009825642.1| 112090 g36013 i0 84.076 0.847107438016529 157 21 64 4 73 227 449 603 Aphanomyces astaci hypothetical protein mRNA blastn 205 148 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
20147505 20147505 PRJNA1111077_P_NODE_30176_length_251_cov_0.865169_g29955_i0 PRJNA1111077 30176 251 0.865169 2.17157419 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 459 1.1499999999999996e-124   NTclustered gi|189084007|gb|BT031523.1| 4784 g29955 i0 99.602 100.01593625498 251 1 100 0 1 251 1884 2134 Phytophthora capsici clone CBOT29-E20 mRNA sequence blastn 25104 459 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
23167005 23167005 PRJNA1111077_P_NODE_23519_length_275_cov_1.524752_g23298_i0 PRJNA1111077 23519 275 1.524752 4.193068 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 150 8.709999999999998e-32   NTclustered gi|695373065|ref|XM_009516665.1| 67593 g23298 i0 77.821 18.9563636363636 257 47 92 10 19 270 699 448 Phytophthora sojae hypothetical protein mRNA blastn 5213 150 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
24440956 24440956 PRJNA1111077_P_NODE_4620_length_528_cov_4.980220_g4399_i0 PRJNA1111077 4620 528 4.98022 26.2955616 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 296 2.17e-75   NTclustered gi|698822976|ref|XM_009846215.1| 112090 g4399 i0 78.243 66.7746212121212 478 92 90 9 48 520 527 57 Aphanomyces astaci 40S ribosomal protein S13 mRNA blastn 35257 296 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci

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