RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

8 rows where bioproject = "PRJNA715461", tax_clade = "Sar" 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

  • PRJNA715461 · 8 ✖

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
1981142 1981142 PRJNA715461_S_NODE_422_length_417_cov_15846.427326_g348_i0 PRJNA715461 422 417 15846.427326 66079.60194942 Aphanomyces stellatus 120398 SAR_Eukaryotes SAR_Eukaryotes 505 2.56e-138   NTclustered gi|7658194|gb|AF119587.1| 120398 g348 i0 97.306 66.2230215827338 297 8 71 0 4 300 268 564 Aphanomyces stellatus strain AR 51 large subunit ribosomal RNA gene, partial sequence blastn 27615 505 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces stellatus
1981151 1981151 PRJNA715461_S_NODE_982_length_250_cov_4.598870_g908_i0 PRJNA715461 982 250 4.59887 11.497175 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 357 4.28e-94   NTclustered gi|698793876|ref|XR_717098.1| 112090 g908 i0 100 77.06 193 0 77 0 55 247 1860 1668 Aphanomyces astaci 28S ribosomal RNA rRNA blastn 19265 357 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
2467563 2467563 PRJNA715461_S_NODE_242_length_557_cov_11.338843_g187_i0 PRJNA715461 242 557 11.338843 63.15735551 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 929 0   NTclustered gi|166048041|emb|CU364162.1| 100861 g187 i0 99.414 92.8886894075404 512 3 92 0 1 512 67 578 Aphanomyces euteiches cDNA blastn 51739 935 0.993582887700535 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
2467567 2467567 PRJNA715461_S_NODE_882_length_267_cov_16.164948_g808_i0 PRJNA715461 882 267 16.164948 43.16041116 Saprolegniales 4763 SAR_Eukaryotes SAR_Eukaryotes 451 2.06e-122   NTclustered gi|1043539652|gb|KT935281.1| 92984 g808 i0 97.026 100.393258426966 269 6 100 1 1 267 18 286 Leptolegnia chapmanii voucher CEP 433 28S ribosomal RNA gene, partial sequence blastn 26805 455 0.991208791208791 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Leptolegnia Leptolegnia chapmanii
9633659 9633659 PRJNA715461_S_NODE_1128_length_235_cov_14484.833333_g1054_i0 PRJNA715461 1128 235 14484.833333 34039.35833255 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 263 8.94e-66   NTclustered gi|698793877|ref|XR_717099.1| 112090 g1054 i0 97.419 65.863829787234 155 3 66 1 4 157 601 755 Aphanomyces astaci 18S ribosomal RNA rRNA blastn 15478 263 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
14734104 14734104 PRJNA715461_S_NODE_1072_length_243_cov_0.888235_g998_i0 PRJNA715461 1072 243 0.888235 2.15841105 Aphanomyces sp. 1982524 SAR_Eukaryotes SAR_Eukaryotes 427 3.11e-115   NTclustered gi|1923460157|gb|MW187635.1| 1982524 g998 i0 98.354 101 243 4 100 0 1 243 30 272 Aphanomyces sp. isolate CCRJB_30 small subunit ribosomal RNA gene, partial sequence; mitochondrial blastn 24543 427 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces sp.
15220741 15220741 PRJNA715461_S_NODE_332_length_477_cov_5816.349010_g265_i0 PRJNA715461 332 477 5816.34901 27743.9847777 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 708 0   NTclustered gi|1111669722|ref|NC_032051.1| 112090 g265 i0 98.504 92.559748427673 401 6 84 0 4 404 3575 3975 Aphanomyces astaci isolate AP03 mitochondrion, complete genome blastn 44151 710 0.997183098591549 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
20318616 20318616 PRJNA715461_S_NODE_356_length_456_cov_6307.266319_g284_i0 PRJNA715461 356 456 6307.266319 28761.13441464 Verrucalvaceae 120409 SAR_Eukaryotes SAR_Eukaryotes 658 0   NTclustered gi|698793877|ref|XR_717099.1| 112090 g284 i0 98.656 81.3859649122807 372 4 81 1 4 374 601 972 Aphanomyces astaci 18S ribosomal RNA rRNA blastn 37112 658 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);;