contig_metadata
12 rows where bioproject = "PRJNA168635", tax_kingdom = "Fungi" and tax_phylum = "Zoopagomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 364283 | 364283 | PRJNA168635_P_NODE_15001_length_207_cov_30.860759_g14585_i0 | PRJNA168635 | 15001 | 207 | 30.860759 | 63.88177113 | Spiromyces minutus | 61418 | Fungi | Fungi | 171 | 4.79e-38 | NTclustered | gi|913748582|ref|NG_042415.1| | 61418 | g14585 | i0 | 81.643 | 101 | 207 | 36 | 99 | 2 | 2 | 207 | 2972 | 2767 | Spiromyces minutus NRRL 3067 28S rRNA, partial sequence; from reference material | blastn | 20907 | 171 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Spiromyces | Spiromyces minutus | |
| 1639440 | 1639440 | PRJNA168635_P_NODE_3402_length_452_cov_12.647643_g3003_i0 | PRJNA168635 | 3402 | 452 | 12.647643 | 57.16734636 | Rhopalomyces elegans | 78913 | Fungi | Fungi | 206 | 3.18e-48 | NTclustered | gi|82398415|gb|DQ273795.1| | 78913 | g3003 | i0 | 93.478 | 49.4115044247788 | 138 | 9 | 52 | 0 | 94 | 231 | 2091 | 2228 | Rhopalomyces elegans isolate AFTOL-ID 142 28S ribosomal RNA gene, partial sequence | blastn | 22334 | 206 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Zoopagomycetes | Zoopagales | Helicocephalidaceae | Rhopalomyces | Rhopalomyces elegans | |
| 4882193 | 4882193 | PRJNA168635_P_NODE_20884_length_179_cov_3.515385_g20468_i0 | PRJNA168635 | 20884 | 179 | 3.515385 | 6.29253915 | Basidiobolus | 4859 | Fungi | Fungi | 254 | 3.87e-63 | NTclustered | gi|145307845|gb|EF392412.1| | 423456 | g20468 | i0 | 92.179 | 100.40782122905 | 179 | 14 | 100 | 0 | 1 | 179 | 907 | 729 | Basidiobolus sp. ARSEF 263 28S ribosomal RNA gene, partial sequence | blastn | 17973 | 255 | 0.996078431372549 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Basidiobolomycetes | Basidiobolales | Basidiobolaceae | Basidiobolus | Basidiobolus sp. ARSEF 263 | |
| 6156938 | 6156938 | PRJNA168635_P_NODE_16725_length_195_cov_5.383562_g16309_i0 | PRJNA168635 | 16725 | 195 | 5.383562 | 10.4979459 | Coemansia | 4863 | Fungi | Fungi | 80.5 | 7.73e-11 | NTclustered | gi|2675351037|gb|PP336511.1| | 2789316 | g16309 | i0 | 100 | 0.876923076923077 | 43 | 0 | 22 | 0 | 94 | 136 | 1051 | 1093 | Coemansia sp. RSA 1813 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 171 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Coemansia | Coemansia sp. RSA 1813 | |
| 6742002 | 6742002 | PRJNA168635_P_NODE_11806_length_238_cov_2.179894_g11390_i0 | PRJNA168635 | 11806 | 238 | 2.179894 | 5.18814772 | Dipsacomyces acuminosporus | 4866 | Fungi | Fungi | 110 | 1.25e-19 | NTclustered | gi|666440442|gb|KF848901.1| | 4866 | g11390 | i0 | 81.429 | 10.3403361344538 | 140 | 20 | 57 | 4 | 36 | 171 | 1564 | 1427 | Dipsacomyces acuminosporus strain NRRL-2925 28S ribosomal RNA gene, partial sequence | blastn | 2461 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Dipsacomyces | Dipsacomyces acuminosporus | |
| 8707078 | 8707078 | PRJNA168635_P_NODE_33547_length_157_cov_4.907407_g33131_i0 | PRJNA168635 | 33547 | 157 | 4.907407 | 7.70462899 | Opisthokonta | 33154 | Fungi | Fungi | 110 | 7.58e-20 | NTclustered | gi|2835551209|gb|PQ481824.1| | 34485 | g33131 | i0 | 89.655 | 52.7770700636943 | 87 | 8 | 55 | 1 | 71 | 157 | 1506 | 1421 | Entomophthora muscae isolate Twyford 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 8286 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 9982251 | 9982251 | PRJNA168635_P_NODE_15308_length_205_cov_2.467949_g14892_i0 | PRJNA168635 | 15308 | 205 | 2.467949 | 5.05929545 | Eukaryota | 2759 | Fungi | Fungi | 54.7 | 0.005 | NTclustered | gi|82398545|gb|DQ273809.1| | 61424 | g14892 | i0 | 100 | 1.01951219512195 | 29 | 0 | 14 | 0 | 6 | 34 | 1800 | 1772 | Furculomyces boomerangus isolate AFTOL-ID 303 28S ribosomal RNA gene, partial sequence | blastn | 209 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Harpellaceae | Furculomyces | Furculomyces boomerangus | |
| 14393445 | 14393445 | PRJNA168635_P_NODE_13612_length_219_cov_7.311765_g13196_i0 | PRJNA168635 | 13612 | 219 | 7.311765 | 16.01276535 | Entomophthora muscae | 34485 | Fungi | Fungi | 176 | 1.1e-39 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g13196 | i0 | 87.5 | 2.14155251141552 | 152 | 19 | 69 | 0 | 68 | 219 | 2658 | 2809 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 469 | 176 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 15667641 | 15667641 | PRJNA168635_P_NODE_9653_length_268_cov_3.465753_g9238_i0 | PRJNA168635 | 9653 | 268 | 3.465753 | 9.28821804 | Smittium mucronatum | 133383 | Fungi | Fungi | 95.3 | 4.02e-15 | NTclustered | gi|666440451|gb|KF848910.1| | 133383 | g9238 | i0 | 86.364 | 0.649253731343284 | 88 | 11 | 33 | 1 | 33 | 120 | 2062 | 2148 | Smittium mucronatum strain FRA-12-3 28S ribosomal RNA gene, partial sequence | blastn | 174 | 95.3 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Smittium | Smittium mucronatum | |
| 20180434 | 20180434 | PRJNA168635_P_NODE_6616_length_329_cov_6.439286_g6205_i0 | PRJNA168635 | 6616 | 329 | 6.439286 | 21.18525094 | Legeriomycetaceae | 4883 | Fungi | Fungi | 156 | 2.29e-33 | NTclustered | gi|89033444|gb|DQ367495.1| | 370260 | g6205 | i0 | 89.516 | 40.6838905775076 | 124 | 12 | 38 | 1 | 61 | 184 | 394 | 272 | Genistellospora homothallica clone 185-1H-9 28S ribosomal RNA gene, partial sequence | blastn | 13385 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Harpellomycetes | Harpellales | Legeriomycetaceae | Genistellospora | Genistellospora homothallica | |
| 22730968 | 22730968 | PRJNA168635_P_NODE_14698_length_210_cov_1.751553_g14282_i0 | PRJNA168635 | 14698 | 210 | 1.751553 | 3.6782613 | Fungi | 4751 | Fungi | Fungi | 134 | 6.4000000000000005e-27 | NTclustered | gi|82398173|gb|DQ273772.1| | 34485 | g14282 | i0 | 88.496 | 50.9333333333333 | 113 | 10 | 53 | 3 | 98 | 209 | 2166 | 2276 | Entomophthora muscae isolate AFTOL-ID 28 28S ribosomal RNA gene, partial sequence | blastn | 10696 | 134 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Entomophthoromycetes | Entomophthorales | Entomophthoraceae | Entomophthora | Entomophthora muscae | |
| 29379186 | 29379186 | PRJNA168635_P_NODE_26549_length_168_cov_0.873950_g26133_i0 | PRJNA168635 | 26549 | 168 | 0.87395 | 1.468236 | Mycoemilia scoparia | 417184 | Fungi | Fungi | 66.2 | 7.47e-12 | NR | KAJ1917871.1 | 417184 | g26133 | i0 | 58.5 | 0.946428571428571 | 53 | 22 | 94.6 | 0 | 159 | 1 | 14 | 66 | KAJ1917871.1 myosin II light chain [Mycoemilia scoparia] | diamond | 159 | 66.2 | 1 | Eukaryota | Opisthokonta | Fungi | Zoopagomycota | Kickxellomycetes | Kickxellales | Kickxellaceae | Mycoemilia | Mycoemilia scoparia |
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);;