contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA1166865" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6691669 | 6691669 | PRJNA1166865_P_NODE_7866_length_751_cov_1.330383_g7657_i0 | PRJNA1166865 | 7866 | 751 | 1.330383 | 9.99117633 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 562 | 2.81e-155 | NTclustered | gi|1759161090|ref|XM_031170872.1| | 1806994 | g7657 | i0 | 80.926 | 86.4314247669774 | 734 | 121 | 97 | 16 | 4 | 729 | 1343 | 621 | Synchytrium microbalum succinate dehydrogenase (SmJEL517_g04944), partial mRNA | blastn | 64910 | 562 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 14341273 | 14341273 | PRJNA1166865_P_NODE_2052_length_1270_cov_1.801170_g1958_i0 | PRJNA1166865 | 2052 | 1270 | 1.80117 | 22.874859 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 857 | 0 | NTclustered | gi|2432145256|ref|XM_053110808.1| | 110093 | g1958 | i0 | 82.104 | 83.1976377952756 | 1017 | 168 | 80 | 13 | 6 | 1015 | 709 | 1718 | Polychytrium aggregatum hsp71-like protein (BJ171DRAFT_502900), mRNA | blastn | 105661 | 857 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 16890756 | 16890756 | PRJNA1166865_P_NODE_74894_length_251_cov_1.297753_g74653_i0 | PRJNA1166865 | 74894 | 251 | 1.297753 | 3.25736003 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 121 | 6.149999999999999e-23 | NTclustered | gi|2432140698|ref|XM_053110328.1| | 110093 | g74653 | i0 | 82.143 | 5.26693227091633 | 140 | 25 | 56 | 0 | 106 | 245 | 65 | 204 | Polychytrium aggregatum 60S ribosomal protein L11 (BJ171DRAFT_498001), mRNA | blastn | 1322 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 18164904 | 18164904 | PRJNA1166865_P_NODE_57815_length_291_cov_0.917431_g57574_i0 | PRJNA1166865 | 57815 | 291 | 0.917431 | 2.66972421 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 235 | 2.4899999999999997e-57 | NTclustered | gi|2432132411|ref|XM_053109501.1| | 110093 | g57574 | i0 | 83.806 | 56.0137457044674 | 247 | 40 | 85 | 0 | 30 | 276 | 904 | 658 | Polychytrium aggregatum ribosomal protein L3-domain-containing protein (BJ171DRAFT_489537), mRNA | blastn | 16300 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 19438025 | 19438025 | PRJNA1166865_P_NODE_10756_length_648_cov_1.608696_g10525_i0 | PRJNA1166865 | 10756 | 648 | 1.608696 | 10.42435008 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 403 | 1.5399999999999993e-107 | NTclustered | gi|2432080769|ref|XM_053070516.1| | 1396493 | g10525 | i0 | 82.505 | 72.6358024691358 | 463 | 77 | 71 | 4 | 126 | 586 | 1106 | 646 | Fimicolochytrium jonesii mitochondrial carrier domain-containing protein (EV422DRAFT_532223), mRNA | blastn | 47068 | 403 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 21441575 | 21441575 | PRJNA1166865_P_NODE_6437_length_824_cov_2.585885_g6242_i0 | PRJNA1166865 | 6437 | 824 | 2.585885 | 21.3076924 | Eukaryota | 2759 | Fungi | Fungi | 424 | 1.52e-113 | NTclustered | gi|30088684|gb|AY238445.1| | 4757 | g6242 | i0 | 78.891 | 65.2657766990291 | 649 | 120 | 78 | 15 | 110 | 751 | 126 | 764 | Neocallimastix frontalis succinyl-CoA synthetase alpha subunit mRNA, complete cds | blastn | 53779 | 424 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix frontalis | |
| 23264948 | 23264948 | PRJNA1166865_P_NODE_37739_length_353_cov_3.696429_g37498_i0 | PRJNA1166865 | 37739 | 353 | 3.696429 | 13.04839437 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 202 | 3.129999999999999e-47 | NTclustered | gi|2432129762|ref|XM_053108984.1| | 110093 | g37498 | i0 | 80.741 | 2.26628895184136 | 270 | 42 | 75 | 9 | 9 | 273 | 70 | 334 | Polychytrium aggregatum 60S ribosomal protein L37 (BJ171DRAFT_484391), mRNA | blastn | 800 | 202 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 24538636 | 24538636 | PRJNA1166865_P_NODE_36240_length_360_cov_1.940767_g35999_i0 | PRJNA1166865 | 36240 | 360 | 1.940767 | 6.9867612 | Spizellomyces punctatus | 109760 | Fungi | Fungi | 174 | 6.98e-39 | NTclustered | gi|1026980085|ref|XM_016752373.1| | 645134 | g35999 | i0 | 82.5 | 2.98611111111111 | 200 | 34 | 56 | 1 | 160 | 359 | 181 | 379 | Spizellomyces punctatus DAOM BR117 40S ribosomal protein S15 (SPPG_04127), mRNA | blastn | 1075 | 174 | 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);;