RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

  • PRJNA900028 · 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
875418 875418 PRJNA900028_P_NODE_28521_length_243_cov_1.561856_g27772_i0 PRJNA900028 28521 243 1.561856 3.79531008 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 176 1.25e-39   NTclustered gi|325194231|emb|FR825088.1| 890382 g27772 i0 90.441 0.860082304526749 136 10 55 3 1 134 596 730 Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 blastn 209 176 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
8528738 8528738 PRJNA900028_P_NODE_73587_length_188_cov_1.100719_g72838_i0 PRJNA900028 73587 188 1.100719 2.06935172 Achlya hypogyna 1202772 SAR_Eukaryotes SAR_Eukaryotes 132 2.01e-26   NTclustered gi|542687346|ref|NC_022178.1| 1202772 g72838 i0 87.069 36.4574468085106 116 15 62 0 65 180 15406 15291 Achlya hypogyna mitochondrion, complete genome blastn 6854 132 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya hypogyna
10173681 10173681 PRJNA900028_P_NODE_24968_length_253_cov_1.406863_g24219_i0 PRJNA900028 24968 253 1.406863 3.55936339 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 468 1.92e-127   NTclustered gi|363498776|gb|JN662487.1| 120398 g24219 i0 100 97.1581027667984 253 0 100 0 1 253 598 346 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 24581 468 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
11078878 11078878 PRJNA900028_P_NODE_2929_length_638_cov_1.660441_g2228_i0 PRJNA900028 2929 638 1.660441 10.59361358 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 935 0   NTclustered gi|325194231|emb|FR825088.1| 890382 g2228 i0 94.702 1.61912225705329 604 28 95 3 1 604 1534 935 Albugo laibachii Nc14, genomic contig CONTIG_1612_NC14_v4_1853_85 blastn 1033 935 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
17453019 17453019 PRJNA900028_P_NODE_153954_length_164_cov_1.286957_g153205_i0 PRJNA900028 153954 164 1.286957 2.11060948 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 287 3.45e-73   NTclustered gi|698793876|ref|XR_717098.1| 112090 g153205 i0 98.171 74.3536585365854 164 3 100 0 1 164 2283 2120 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 12194 287 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
20002849 20002849 PRJNA900028_P_NODE_99456_length_176_cov_1.251969_g98707_i0 PRJNA900028 99456 176 1.251969 2.20346544 Albugo laibachii 653948 SAR_Eukaryotes SAR_Eukaryotes 292 8.04e-75   NTclustered gi|325194423|emb|FR825253.1| 890382 g98707 i0 96.591 99.8295454545455 176 6 100 0 1 176 327 502 Albugo laibachii Nc14, genomic contig CONTIG_1950_NC14_v4_1284_22758 blastn 17570 292 1 Eukaryota Sar   Oomycota Peronosporomycetes Albuginales Albuginaceae Albugo Albugo laibachii
21277693 21277693 PRJNA900028_P_NODE_57597_length_199_cov_2.040000_g56848_i0 PRJNA900028 57597 199 2.04 4.0596 Peronospora rumicis 162101 SAR_Eukaryotes SAR_Eukaryotes 363 7.019999999999998e-96   NTclustered gi|33520206|gb|AY273951.1| 162101 g56848 i0 99.497 99.9447236180904 199 1 100 0 1 199 551 749 Peronospora rumicis large subunit ribosomal RNA gene, partial sequence blastn 19889 363 1 Eukaryota Sar   Oomycota Peronosporomycetes Peronosporales Peronosporaceae Peronospora Peronospora rumicis

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