contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA379145" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1675489 | 1675489 | PRJNA379145_P_NODE_32442_length_383_cov_1.588571_g30306_i0 | PRJNA379145 | 32442 | 383 | 1.588571 | 6.08422693 | Neocallimastix frontalis | 4757 | Fungi | Fungi | 254 | 9.33e-63 | NTclustered | gi|387233102|gb|JN033861.1| | 4757 | g30306 | i0 | 81.231 | 45.5039164490862 | 325 | 51 | 84 | 10 | 12 | 331 | 184 | 503 | Neocallimastix frontalis strain PMA02 aconitate hydratase (AH2) mRNA, partial cds | blastn | 17428 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Neocallimastigomycetes | Neocallimastigales | Neocallimastigaceae | Neocallimastix | Neocallimastix frontalis | |
| 4228295 | 4228295 | PRJNA379145_P_NODE_64664_length_173_cov_3.000000_g62510_i0 | PRJNA379145 | 64664 | 173 | 3 | 5.19 | Gromochytrium mamkaevae | 1486924 | Fungi | Fungi | 80.5 | 6.67e-11 | NTclustered | gi|612507318|gb|KF586842.1| | 1486924 | g62510 | i0 | 88.235 | 8.5028901734104 | 68 | 7 | 39 | 1 | 1 | 67 | 6179 | 6112 | Gromochytrium mamkaevae strain CALU x-51 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 1471 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Gromochytriales | Gromochytriaceae | Gromochytrium | Gromochytrium mamkaevae | |
| 8726756 | 8726756 | PRJNA379145_P_NODE_65067_length_172_cov_2.129496_g62913_i0 | PRJNA379145 | 65067 | 172 | 2.129496 | 3.66273312 | Opisthokonta | 33154 | Fungi | Fungi | 318 | 1.2899999999999999e-82 | NTclustered | gi|19386988|gb|AF450112.1| | 109953 | g62913 | i0 | 100 | 91.1046511627907 | 172 | 0 | 100 | 0 | 1 | 172 | 378 | 549 | Monoblepharis insignis translation elongation factor 1-alpha gene, partial cds | blastn | 15670 | 318 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Monoblepharidaceae | Monoblepharis | Monoblepharis insignis | |
| 11879459 | 11879459 | PRJNA379145_P_NODE_27050_length_460_cov_3.683841_g24981_i0 | PRJNA379145 | 27050 | 460 | 3.683841 | 16.9456686 | Polychytrium aggregatum | 110093 | Fungi | Fungi | 287 | 1.12e-72 | NTclustered | gi|2432131102|ref|XM_053109247.1| | 110093 | g24981 | i0 | 82.371 | 65.2521739130435 | 329 | 58 | 72 | 0 | 113 | 441 | 481 | 153 | Polychytrium aggregatum putative ubiquitin/ribosomal protein S27a fusion protein (BJ171DRAFT_487026), mRNA | blastn | 30016 | 287 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Polychytriales | Polychytrium | Polychytrium aggregatum | ||
| 14429593 | 14429593 | PRJNA379145_P_NODE_36632_length_334_cov_4.259136_g34484_i0 | PRJNA379145 | 36632 | 334 | 4.259136 | 14.22551424 | Batrachochytrium dendrobatidis | 109871 | Fungi | Fungi | 115 | 3.96e-21 | NTclustered | gi|575480991|ref|XM_006679727.1| | 684364 | g34484 | i0 | 80.392 | 0.592814371257485 | 153 | 28 | 46 | 2 | 58 | 209 | 25 | 176 | Batrachochytrium dendrobatidis JAM81 uncharacterized protein (BATDEDRAFT_12294), partial mRNA | blastn | 198 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Batrachochytrium | Batrachochytrium dendrobatidis | ||
| 16977937 | 16977937 | PRJNA379145_P_NODE_14674_length_746_cov_347.336606_g11797_i1 | PRJNA379145 | 14674 | 746 | 347.336606 | 2591.13108076 | Synchytrium microbalum | 1806994 | Fungi | Fungi | 466 | 2.2499999999999998e-126 | NTclustered | gi|1759154564|ref|XM_031169821.1| | 1806994 | g11797 | i1 | 85.845 | 58.6528150134048 | 438 | 62 | 59 | 0 | 102 | 539 | 444 | 7 | Synchytrium microbalum uncharacterized protein (SmJEL517_g03893), partial mRNA | blastn | 43755 | 466 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Synchytriales | Synchytriaceae | Synchytrium | Synchytrium microbalum | |
| 20801971 | 20801971 | PRJNA379145_P_NODE_11137_length_895_cov_2.845708_g9869_i0 | PRJNA379145 | 11137 | 895 | 2.845708 | 25.4690866 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 614 | 9.189999999999999e-171 | NTclustered | gi|2432080769|ref|XM_053070516.1| | 1396493 | g9869 | i0 | 80.31 | 92.8256983240223 | 838 | 142 | 93 | 10 | 1 | 832 | 1034 | 214 | Fimicolochytrium jonesii mitochondrial carrier domain-containing protein (EV422DRAFT_532223), mRNA | blastn | 83079 | 614 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 24627420 | 24627420 | PRJNA379145_P_NODE_68020_length_164_cov_2.328244_g65866_i0 | PRJNA379145 | 68020 | 164 | 2.328244 | 3.81832016 | Rhizophydium sp. JEL138 | 139068 | Fungi | Fungi | 165 | 1.69e-36 | NTclustered | gi|30088585|gb|AY138801.1| | 139068 | g65866 | i0 | 85.714 | 15.9939024390244 | 161 | 17 | 96 | 5 | 6 | 163 | 1232 | 1075 | Rhizophydium sp. JEL138 beta-tubulin (btub1) gene, partial cds | blastn | 2623 | 165 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Rhizophydiales | Rhizophydiaceae | Rhizophydium | Rhizophydium sp. JEL138 |
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);;