contig_metadata
3 rows where analysis = "blastn", bioproject = "PRJNA312899" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 5483305 | 5483305 | PRJNA312899_P_NODE_57925_length_223_cov_2.637931_g57483_i0 | PRJNA312899 | 57925 | 223 | 2.637931 | 5.88258613 | Orpinomyces sp. OUS1 | 301046 | Fungi | Fungi | 137 | 5.31e-28 | NTclustered | gi|55859492|emb|AJ864475.1| | 301046 | g57483 | i0 | 85.714 | 47.4035874439462 | 133 | 15 | 59 | 4 | 5 | 135 | 4590 | 4720 | Orpinomyces sp. OUS1 partial 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2 and partial 28S rRNA, clone V5-1 | blastn | 10571 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Orpinomyces | Orpinomyces sp. OUS1 | |
| 9307291 | 9307291 | PRJNA312899_P_NODE_27868_length_352_cov_3.023102_g27426_i0 | PRJNA312899 | 27868 | 352 | 3.023102 | 10.64131904 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 115 | 4.1800000000000005e-21 | NTclustered | gi|2432112660|ref|XM_053066439.1| | 1396493 | g27426 | i0 | 77 | 0.568181818181818 | 200 | 46 | 57 | 0 | 99 | 298 | 219 | 418 | Fimicolochytrium jonesii ras-related GTP-binding protein A-like protein (EV422DRAFT_338844), mRNA | blastn | 200 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 18231574 | 18231574 | PRJNA312899_P_NODE_60975_length_215_cov_7.987952_g60533_i0 | PRJNA312899 | 60975 | 215 | 7.987952 | 17.1740968 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 145 | 3.04e-30 | NTclustered | gi|2432095821|ref|XM_053071168.1| | 1396493 | g60533 | i0 | 81.977 | 19.0558139534884 | 172 | 29 | 80 | 2 | 45 | 215 | 284 | 114 | Fimicolochytrium jonesii ribosomal protein S27-domain-containing protein (EV422DRAFT_540954), mRNA | blastn | 4097 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii |
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);;