RNAquarium Metadata Server
Institute Website Terms of Use Privacy Policy

contig_metadata

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

✎ View and edit SQL

This data as json, CSV (advanced)

analysis 2

tax_superkingdom 1

tax_phylum 1

  • Oomycota · 6 ✖

tax_clade 1

bioproject 1

  • PRJNA1101048 · 6 ✖

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
7863907 7863907 PRJNA1101048_P_NODE_4127_length_308_cov_3.800000_g4071_i0 PRJNA1101048 4127 308 3.8 11.704 Saprolegnia parasitica 101203 SAR_Eukaryotes SAR_Eukaryotes 453 6.75e-123   NTclustered gi|813199067|ref|XR_001099866.1| 695850 g4071 i0 93.485 77.288961038961 307 16 99 4 4 308 1665 1361 Saprolegnia parasitica CBS 223.65 28S ribosomal RNA rRNA blastn 23805 453 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Saprolegniaceae Saprolegnia Saprolegnia parasitica
9138818 9138818 PRJNA1101048_P_NODE_2288_length_382_cov_2.608414_g2232_i0 PRJNA1101048 2288 382 2.608414 9.96414148 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 678 0   NTclustered gi|1111669722|ref|NC_032051.1| 112090 g2232 i0 98.691 107.452879581152 382 5 100 0 1 382 2466 2085 Aphanomyces astaci isolate AP03 mitochondrion, complete genome blastn 41047 678 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
11223259 11223259 PRJNA1101048_P_NODE_1569_length_446_cov_1.276139_g1513_i0 PRJNA1101048 1569 446 1.276139 5.69157994 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 652 0   NTclustered gi|1111669722|ref|NC_032051.1| 112090 g1513 i0 96.03 96.0896860986547 403 13 99 3 45 446 4306 3906 Aphanomyces astaci isolate AP03 mitochondrion, complete genome blastn 42856 658 0.990881458966565 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces astaci
15047524 15047524 PRJNA1101048_P_NODE_6292_length_263_cov_2.321053_g6236_i0 PRJNA1101048 6292 263 2.321053 6.10436939 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 300 7.77e-77   NTclustered gi|166041637|emb|CU357669.1| 100861 g6236 i0 98.81 106.220532319392 168 2 87 0 1 168 55 222 Aphanomyces euteiches cDNA blastn 27936 303 0.99009900990099 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
23972131 23972131 PRJNA1101048_P_NODE_2979_length_347_cov_2.281022_g2923_i0 PRJNA1101048 2979 347 2.281022 7.91514634 Aphanomyces 100860 SAR_Eukaryotes SAR_Eukaryotes 603 7.229999999999999e-168   NTclustered gi|166048041|emb|CU364162.1| 100861 g2923 i0 99.398 94.657060518732 332 2 96 0 2 333 230 561 Aphanomyces euteiches cDNA blastn 32846 603 1 Eukaryota Sar   Oomycota Saprolegniomycetes Saprolegniales Verrucalvaceae Aphanomyces Aphanomyces euteiches
31869242 31869242 PRJNA1101048_P_NODE_9157_length_243_cov_0.917647_g9101_i0 PRJNA1101048 9157 243 0.917647 2.22988221 Aphanomyces astaci 112090 SAR_Eukaryotes SAR_Eukaryotes 62.8 1.33e-9   NR KAF0709168.1 112090 g9101 i0 49.1 0.654320987654321 53 26 65.4 1 243 85 172 223 KAF0709168.1 hypothetical protein AaE_012954 [Aphanomyces astaci] diamond 159 62.8 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);;