RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

6 rows where bioproject = "PRJNA509429", tax_clade = "Sar" and tax_phylum = "Oomycota"

✎ View and edit SQL

This data as json, CSV (advanced)

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA509429 · 6 ✖

analysis 1

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
485285 485285 PRJNA509429_P_NODE_7321_length_538_cov_28.457256_g6546_i0 PRJNA509429 7321 538 28.457256 153.10003728 Aphanomyces sp. 1982524 SAR_Eukaryotes SAR_Eukaryotes 773 0   NTclustered gi|1578815424|gb|MK546601.1| 1982524 g6546 i0 97.778 83.2546468401487 450 7 83 3 91 538 648 200 Aphanomyces sp. voucher CCIBt4545 large subunit ribosomal RNA gene, partial sequence blastn 44791 773 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces sp.
8138357 8138357 PRJNA509429_P_NODE_44267_length_168_cov_1.503759_g43439_i0 PRJNA509429 44267 168 1.503759 2.52631512 Achlya hypogyna 1202772 SAR_Eukaryotes SAR_Eukaryotes 267 4.63e-67   NTclustered gi|542687346|ref|NC_022178.1| 1202772 g43439 i0 95.294 23.5 170 5 100 3 1 168 8666 8834 Achlya hypogyna mitochondrion, complete genome blastn 3948 267 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Achlyaceae Achlya Achlya hypogyna
8763761 8763761 PRJNA509429_P_NODE_18967_length_312_cov_14.935018_g18139_i0 PRJNA509429 18967 312 14.935018 46.59725616 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 501 2.41e-137   NTclustered gi|166048041|emb|CU364162.1| 100861 g18139 i0 99.635 89.2564102564103 274 1 99 0 2 275 189 462 Aphanomyces euteiches cDNA blastn 27848 501 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
9413353 9413353 PRJNA509429_P_NODE_28788_length_232_cov_1.406091_g27960_i0 PRJNA509429 28788 232 1.406091 3.26213112 Saprolegnia ferax 4770 SAR_Eukaryotes SAR_Eukaryotes 241 4.130000000000001e-59   NTclustered gi|50261276|ref|NC_005984.1| 4770 g27960 i0 97.203 67.2801724137931 143 3 61 1 91 232 9119 9261 Saprolegnia ferax mitochondrion, complete genome blastn 15609 241 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia ferax
15138811 15138811 PRJNA509429_P_NODE_32972_length_209_cov_1.816092_g32144_i0 PRJNA509429 32972 209 1.816092 3.79563228 root 1 Root_unresolved Root_unresolved 353 4.489999999999999e-93   NTclustered gi|50261276|ref|NC_005984.1| 4770 g32144 i0 97.129 104.55980861244 209 6 100 0 1 209 7456 7664 Saprolegnia ferax mitochondrion, complete genome blastn 21853 353 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia ferax
18962381 18962381 PRJNA509429_P_NODE_33455_length_207_cov_1.395349_g32627_i0 PRJNA509429 33455 207 1.395349 2.88837243 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 361 2.65e-95   NTclustered gi|1375986852|gb|MH180320.1| 112090 g32627 i0 98.068 98.8550724637681 207 4 100 0 1 207 227 433 Aphanomyces astaci voucher StGM11/SBAu11 small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 20463 361 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);;