contig_metadata
5 rows where bioproject = "PRJNA1120203", tax_clade = "Opisthokonta" and tax_phylum = "Chytridiomycota"
This data as json, CSV (advanced)
| 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2825345 | 2825345 | PRJNA1120203_P_NODE_19203_length_599_cov_7.264259_g18199_i0 | PRJNA1120203 | 19203 | 599 | 7.264259 | 43.51291141 | uncultured Chytridiomycota | 175247 | Fungi | Fungi | 444 | 8.37e-120 | NTclustered | gi|63169493|gb|AY969198.1| | 175247 | g18199 | i0 | 97.674 | 92.9298831385643 | 258 | 6 | 93 | 0 | 15 | 272 | 257 | 514 | Uncultured chytridiomycete isolate dfmo4344.082 18S ribosomal RNA gene, partial sequence | blastn | 55665 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | uncultured Chytridiomycota | |||||
| 12506821 | 12506821 | PRJNA1120203_P_NODE_67970_length_272_cov_3.869347_g66954_i0 | PRJNA1120203 | 67970 | 272 | 3.869347 | 10.52462384 | Lobulomyces | 642604 | Fungi | Fungi | 479 | 9.659999999999999e-131 | NTclustered | gi|295805544|emb|FN389642.1| | 175247 | g66954 | i0 | 100 | 94.875 | 259 | 0 | 95 | 0 | 13 | 271 | 259 | 1 | Uncultured chytridiomycete partial 18S rRNA gene, isolate 04CFTWW | blastn | 25806 | 479 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | uncultured Chytridiomycota | |||||
| 14304068 | 14304068 | PRJNA1120203_P_NODE_67092_length_274_cov_12.786070_g66076_i0 | PRJNA1120203 | 67092 | 274 | 12.78607 | 35.0338318 | uncultured Chytridiomycota | 175247 | Fungi | Fungi | 444 | 3.55e-120 | NTclustered | gi|295805539|emb|FN389637.1| | 175247 | g66076 | i0 | 97.683 | 94.3029197080292 | 259 | 5 | 94 | 1 | 3 | 260 | 1 | 259 | Uncultured chytridiomycete partial 18S rRNA gene, isolate 04CFVMT | blastn | 25839 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | uncultured Chytridiomycota | |||||
| 23227488 | 23227488 | PRJNA1120203_P_NODE_67559_length_273_cov_2.305000_g66543_i0 | PRJNA1120203 | 67559 | 273 | 2.305 | 6.29265 | uncultured Chytridiomycota | 175247 | Fungi | Fungi | 235 | 2.32e-57 | NTclustered | gi|295805619|emb|FN389717.1| | 175247 | g66543 | i0 | 97.143 | 52.007326007326 | 140 | 2 | 51 | 2 | 123 | 261 | 116 | 254 | Uncultured chytridiomycete partial 18S rRNA gene, isolate 06DJRYT | blastn | 14198 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | uncultured Chytridiomycota | |||||
| 31070577 | 31070577 | PRJNA1120203_P_NODE_74955_length_257_cov_1.967391_g73939_i0 | PRJNA1120203 | 74955 | 257 | 1.967391 | 5.05619487 | root | 1 | Root_unresolved | Root_unresolved | 53.9 | 5.11e-6 | NR | RKP01809.1 | 1555241 | g73939 | i0 | 46.5 | 2.82490272373541 | 43 | 23 | 50.2 | 0 | 3 | 131 | 553 | 595 | RKP01809.1 hypothetical protein CXG81DRAFT_11506, partial [Caulochytrium protostelioides] | diamond | 726 | 53.9 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Caulochytriales | Caulochytriaceae | Caulochytrium | Caulochytrium protostelioides |
Advanced export
JSON shape: default, array, newline-delimited
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);;