contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA924320" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2174661 | 2174661 | PRJNA924320_S_NODE_50882_length_164_cov_1.773913_g50740_i0 | PRJNA924320 | 50882 | 164 | 1.773913 | 2.90921732 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 152 | 1.31e-32 | NTclustered | gi|2432150950|ref|XM_053107694.1| | 110093 | g50740 | i0 | 84.177 | 0.963414634146341 | 158 | 23 | 96 | 2 | 8 | 164 | 1807 | 1651 | Polychytrium aggregatum elongation factor EF-3 (BJ171DRAFT_424968), partial mRNA | blastn | 158 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 6002388 | 6002388 | PRJNA924320_S_NODE_36745_length_184_cov_0.866667_g36603_i0 | PRJNA924320 | 36745 | 184 | 0.866667 | 1.59466728 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 69.4 | 1.56e-7 | NTclustered | gi|2432085723|ref|XM_053072715.1| | 1396493 | g36603 | i0 | 93.617 | 0.255434782608696 | 47 | 2 | 26 | 1 | 1 | 47 | 180 | 135 | Fimicolochytrium jonesii ribosomal protein L6e-domain-containing protein (EV422DRAFT_569050), partial mRNA | blastn | 47 | 69.4 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 11102838 | 11102838 | PRJNA924320_S_NODE_4509_length_444_cov_1.420253_g4368_i0 | PRJNA924320 | 4509 | 444 | 1.420253 | 6.30592332 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 137 | 1.1500000000000002e-27 | NTclustered | gi|2432100115|ref|XM_053071323.1| | 1396493 | g4368 | i0 | 78.505 | 0.481981981981982 | 214 | 42 | 48 | 4 | 166 | 377 | 275 | 486 | Fimicolochytrium jonesii 50S ribosomal protein L30e-like protein (EV422DRAFT_543230), mRNA | blastn | 214 | 137 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 14927061 | 14927061 | PRJNA924320_S_NODE_22052_length_223_cov_1.528736_g21910_i0 | PRJNA924320 | 22052 | 223 | 1.528736 | 3.40908128 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 231 | 2.3699999999999997e-56 | NTclustered | gi|2432143596|ref|XM_053110630.1| | 110093 | g21910 | i0 | 85.52 | 37.6636771300448 | 221 | 32 | 99 | 0 | 3 | 223 | 487 | 267 | Polychytrium aggregatum cyclophilin B precursor (BJ171DRAFT_501021), mRNA | blastn | 8399 | 231 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 16202035 | 16202035 | PRJNA924320_S_NODE_17313_length_245_cov_2.336735_g17171_i0 | PRJNA924320 | 17313 | 245 | 2.336735 | 5.72500075 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 145 | 3.5499999999999996e-30 | NTclustered | gi|2432147654|ref|XM_053111044.1| | 110093 | g17171 | i0 | 80.102 | 49.5959183673469 | 196 | 37 | 80 | 2 | 51 | 245 | 608 | 802 | Polychytrium aggregatum Enolase, C-terminal TIM barrel domain-containing protein (BJ171DRAFT_505639), mRNA | blastn | 12151 | 145 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 16554699 | 16554699 | PRJNA924320_S_NODE_47753_length_166_cov_1.170940_g47611_i0 | PRJNA924320 | 47753 | 166 | 1.17094 | 1.9437604 | Fungi | 4751 | Fungi | Fungi | 158 | 2.8599999999999993e-34 | NTclustered | gi|2432132411|ref|XM_053109501.1| | 110093 | g47611 | i0 | 87.05 | 44.4759036144578 | 139 | 18 | 84 | 0 | 1 | 139 | 766 | 904 | Polychytrium aggregatum ribosomal protein L3-domain-containing protein (BJ171DRAFT_489537), mRNA | blastn | 7383 | 158 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 22576465 | 22576465 | PRJNA924320_S_NODE_53558_length_163_cov_0.894737_g53416_i0 | PRJNA924320 | 53558 | 163 | 0.894737 | 1.45842131 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 62.1 | 2.26e-5 | NTclustered | gi|2432131134|ref|XM_053109254.1| | 110093 | g53416 | i0 | 97.222 | 0.220858895705521 | 36 | 1 | 22 | 0 | 43 | 78 | 178 | 143 | Polychytrium aggregatum uncharacterized protein (BJ171DRAFT_487112), mRNA | blastn | 36 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum |
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);;