contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA340009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6769597 | 6769597 | PRJNA340009_P_NODE_23586_length_251_cov_5.886139_g23279_i0 | PRJNA340009 | 23586 | 251 | 5.886139 | 14.77420889 | Neocallimastigomycota sp. LLME10_2 PML-2011x | 1105088 | Fungi | Fungi | 150 | 7.84e-32 | NTclustered | gi|354683748|gb|JN049555.1| | 1105088 | g23279 | i0 | 91.667 | 47.9003984063745 | 108 | 9 | 43 | 0 | 134 | 241 | 141 | 248 | Neocallimastigomycota sp. LLME10_2 PML-2011x 28S ribosomal RNA gene, partial sequence | blastn | 12023 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigomycota sp. LLME10_2 PML-2011x | ||||
| 13145912 | 13145912 | PRJNA340009_P_NODE_50431_length_183_cov_1.171642_g50124_i0 | PRJNA340009 | 50431 | 183 | 1.171642 | 2.14410486 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 174 | 3.19e-39 | NTclustered | gi|2432084117|ref|XM_053070665.1| | 1396493 | g50124 | i0 | 84.571 | 62.9398907103825 | 175 | 27 | 96 | 0 | 9 | 183 | 894 | 1068 | Fimicolochytrium jonesii P-loop containing nucleoside triphosphate hydrolase protein (EV422DRAFT_534391), mRNA | blastn | 11518 | 174 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 15694887 | 15694887 | PRJNA340009_P_NODE_46673_length_188_cov_6.604317_g46366_i0 | PRJNA340009 | 46673 | 188 | 6.604317 | 12.41611596 | Dinomyces arenysensis | 1477495 | Fungi | Fungi | 143 | 9.289999999999999e-30 | NTclustered | gi|2214409771|gb|ON113503.1| | 1477495 | g46366 | i0 | 84.211 | 46.9946808510638 | 152 | 19 | 80 | 5 | 23 | 172 | 474 | 326 | Dinomyces arenysensis strain ICMB1101 large subunit ribosomal RNA gene, partial sequence | blastn | 8835 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Dinomycetaceae | Dinomyces | Dinomyces arenysensis |
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);;