RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA415856 · 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
1694304 1694304 PRJNA415856_P_NODE_5462_length_410_cov_9.163435_g5201_i0 PRJNA415856 5462 410 9.163435 37.5700835 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 597 4.029999999999999e-166   NTclustered gi|325195057|emb|FR825852.1| 890382 g5201 i0 93.596 86.6243902439024 406 16 98 7 11 410 90 491 Albugo laibachii Nc14, genomic contig CONTIG_2891_NC14_v4_540_391 blastn 35516 597 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
4246322 4246322 PRJNA415856_P_NODE_25824_length_182_cov_1.165414_g25563_i0 PRJNA415856 25824 182 1.165414 2.12105348 Phytophthora sojae 67593 SAR_Eukaryotes SAR_Eukaryotes 58.4 3.33e-4   NTclustered gi|695463676|ref|XM_009540482.1| 67593 g25563 i0 100 0.17032967032967 31 0 17 0 18 48 1695 1725 Phytophthora sojae hypothetical protein partial mRNA blastn 31 58.4 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora sojae
6186339 6186339 PRJNA415856_P_NODE_12285_length_249_cov_1.840000_g12024_i0 PRJNA415856 12285 249 1.84 4.5816 Peronosporaceae 4777 SAR_Eukaryotes SAR_Eukaryotes 433 6.89e-117   NTclustered gi|2316773050|gb|OP642369.1| 291622 g12024 i0 98.374 98.7068273092369 246 4 99 0 1 246 618 863 Pseudoperonospora cannabina strain 06032022-5043 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence blastn 24578 433 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Pseudoperonospora Pseudoperonospora cannabina
8736274 8736274 PRJNA415856_P_NODE_24867_length_183_cov_4.514925_g24606_i0 PRJNA415856 24867 183 4.514925 8.26231275 Phytophthora 4783 SAR_Eukaryotes SAR_Eukaryotes 339 1.07e-88   NTclustered gi|2288302438|gb|OP269656.1| 4784 g24606 i0 100 100 183 0 100 0 1 183 1114 1296 Phytophthora capsici isolate D3 large subunit ribosomal RNA gene, partial sequence blastn 18300 339 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici
13173216 13173216 PRJNA415856_P_NODE_51211_length_161_cov_1.562500_g50950_i0 PRJNA415856 51211 161 1.5625 2.515625 Peronospora calotheca 162108 SAR_Eukaryotes SAR_Eukaryotes 246 5.7199999999999986e-61   NTclustered gi|33520215|gb|AY273960.1| 162108 g50950 i0 94.375 99.3788819875776 160 9 99 0 2 161 575 734 Peronospora calotheca large subunit ribosomal RNA gene, partial sequence blastn 16000 246 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora calotheca
13173240 13173240 PRJNA415856_P_NODE_53671_length_160_cov_2.657658_g53410_i0 PRJNA415856 53671 160 2.657658 4.2522528 Phytophthora cinnamomi 4785 SAR_Eukaryotes SAR_Eukaryotes 139 9.9e-29   NTclustered gi|151368176|gb|EF661646.1| 4785 g53410 i0 82.822 4.9875 163 20 99 6 2 160 756 914 Phytophthora cinnamomi strain 20080 28S ribosomal RNA, partial sequence; intergenic spacer, complete sequence; and 18S ribosomal RNA, partial sequence blastn 798 139 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora cinnamomi
15111061 15111061 PRJNA415856_P_NODE_16472_length_214_cov_2.812121_g16211_i0 PRJNA415856 16472 214 2.812121 6.01793894 Peronosporomycetes 3418804 SAR_Eukaryotes SAR_Eukaryotes 396 7.559999999999996e-106   NTclustered gi|1238675774|gb|MF783088.1| 4784 g16211 i0 100 100 214 0 100 0 1 214 972 759 Phytophthora capsici isolate CACAO small subunit ribosomal RNA gene, partial sequence blastn 21400 396 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Phytophthora Phytophthora capsici

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