contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA473201" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 443725 | 443725 | PRJNA473201_P_NODE_35781_length_333_cov_1.111538_g35039_i0 | PRJNA473201 | 35781 | 333 | 1.111538 | 3.70142154 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 250 | 1.04e-61 | NTclustered | gi|2897839259|gb|CP161931.1| | 109871 | g35039 | i0 | 82.131 | 72.8888888888889 | 291 | 52 | 87 | 0 | 35 | 325 | 786904 | 787194 | Batrachochytrium dendrobatidis strain JEL423 chromosome 9 | blastn | 24272 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 1718259 | 1718259 | PRJNA473201_P_NODE_16662_length_488_cov_1.110843_g15920_i0 | PRJNA473201 | 16662 | 488 | 1.110843 | 5.42091384 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 172 | 3.499999999999999e-38 | NTclustered | gi|2432162630|ref|XM_053112000.1| | 110093 | g15920 | i0 | 78.676 | 28.2602459016393 | 272 | 48 | 55 | 6 | 213 | 482 | 523 | 260 | Polychytrium aggregatum ribosomal protein L22/L17 (BJ171DRAFT_515986), mRNA | blastn | 13791 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 6821889 | 6821889 | PRJNA473201_P_NODE_63566_length_257_cov_0.956522_g62824_i0 | PRJNA473201 | 63566 | 257 | 0.956522 | 2.45826154 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 156 | 1.73e-33 | NTclustered | gi|2432130088|ref|XM_053109047.1| | 110093 | g62824 | i0 | 79.646 | 1.24513618677043 | 226 | 38 | 86 | 7 | 30 | 251 | 92 | 313 | Polychytrium aggregatum ribosomal protein L11 (BJ171DRAFT_484855), mRNA | blastn | 320 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 10647168 | 10647168 | PRJNA473201_P_NODE_14089_length_533_cov_1.256522_g13348_i0 | PRJNA473201 | 14089 | 533 | 1.256522 | 6.69726226 | Neocallimastix cameroonii | 1764037 | Fungi | Fungi | 691 | 0 | NTclustered | gi|1388116238|gb|MH043806.1| | 1764037 | g13348 | i0 | 95.195 | 2.43151969981238 | 437 | 21 | 82 | 0 | 97 | 533 | 1014 | 578 | Neocallimastix cameroonii strain G3 Glycosyl hydrolase family 19 mRNA, partial cds | blastn | 1296 | 691 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix cameroonii | |
| 13197412 | 13197412 | PRJNA473201_P_NODE_39731_length_317_cov_1.889344_g38989_i0 | PRJNA473201 | 39731 | 317 | 1.889344 | 5.98922048 | Neocallimastix cameroonii | 1764037 | Fungi | Fungi | 453 | 6.970000000000001e-123 | NTclustered | gi|1388116238|gb|MH043806.1| | 1764037 | g38989 | i0 | 92.097 | 2.70031545741325 | 329 | 14 | 100 | 2 | 1 | 317 | 442 | 114 | Neocallimastix cameroonii strain G3 Glycosyl hydrolase family 19 mRNA, partial cds | blastn | 856 | 453 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix cameroonii | |
| 17021888 | 17021888 | PRJNA473201_P_NODE_77494_length_245_cov_0.895349_g76752_i0 | PRJNA473201 | 77494 | 245 | 0.895349 | 2.19360505 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 215 | 2.67e-51 | NTclustered | gi|2432172524|ref|XM_053106693.1| | 110093 | g76752 | i0 | 82.645 | 16.8204081632653 | 242 | 42 | 99 | 0 | 4 | 245 | 2780 | 2539 | Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_251536), mRNA | blastn | 4121 | 215 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 20846319 | 20846319 | PRJNA473201_P_NODE_86297_length_239_cov_3.475904_g85555_i0 | PRJNA473201 | 86297 | 239 | 3.475904 | 8.30741056 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 121 | 5.81e-23 | NTclustered | gi|2432138713|ref|XM_053107478.1| | 110093 | g85555 | i0 | 84.252 | 8.24686192468619 | 127 | 16 | 52 | 3 | 115 | 239 | 148 | 24 | Polychytrium aggregatum large subunit ribosomal protein 29 (BJ171DRAFT_421272), partial mRNA | blastn | 1971 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 23396364 | 23396364 | PRJNA473201_P_NODE_59879_length_266_cov_2.994819_g59137_i0 | PRJNA473201 | 59879 | 266 | 2.994819 | 7.96621854 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 119 | 2.36e-22 | NTclustered | gi|1026981961|ref|XM_016752543.1| | 645134 | g59137 | i0 | 81.579 | 0.571428571428571 | 152 | 20 | 57 | 5 | 90 | 240 | 225 | 81 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S30 (SPPG_04300), mRNA | blastn | 152 | 119 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Spizellomycetaceae | Spizellomyces | Spizellomyces punctatus |
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);;