contig_metadata
17 rows where bioproject = "PRJNA806354" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1222394 | 1222394 | PRJNA806354_P_NODE_35301_length_251_cov_0.865169_g35192_i0 | PRJNA806354 | 35301 | 251 | 0.865169 | 2.17157419 | Aspergillus | 5052 | Fungi | Fungi | 462 | 8.869999999999999e-126 | NTclustered | gi|71002679|ref|XM_750928.1| | 330879 | g35192 | i0 | 100 | 7.95219123505976 | 250 | 0 | 99 | 0 | 2 | 251 | 1673 | 1424 | Aspergillus fumigatus Af293 SWI-SNF complex subunit (Snf5), putative (AFUA_2G16840), partial mRNA | blastn | 1996 | 462 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 1222402 | 1222402 | PRJNA806354_P_NODE_42801_length_220_cov_10.272109_g42692_i0 | PRJNA806354 | 42801 | 220 | 10.272109 | 22.5986398 | Trichophyton | 5550 | Fungi | Fungi | 399 | 6.039999999999999e-107 | NTclustered | gi|404321321|gb|JX431933.1| | 5551 | g42692 | i0 | 100 | 98.2 | 216 | 0 | 98 | 0 | 4 | 219 | 3870 | 4085 | Trichophyton rubrum strain CBS 118892 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 25S ribosomal RNA gene, complete sequence | blastn | 21604 | 399 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Trichophyton | Trichophyton rubrum | |
| 2497942 | 2497942 | PRJNA806354_P_NODE_33882_length_255_cov_3.335165_g33773_i0 | PRJNA806354 | 33882 | 255 | 3.335165 | 8.50467075 | Aspergillus | 5052 | Fungi | Fungi | 466 | 6.98e-127 | NTclustered | gi|4098984|gb|U81264.1|APU81264 | 41959 | g33773 | i0 | 99.608 | 99.8588235294118 | 255 | 1 | 100 | 0 | 1 | 255 | 216 | 470 | Aspergillus penicillioides 28S ribosomal RNA gene, partial sequence | blastn | 25464 | 466 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus penicillioides | |
| 7184365 | 7184365 | PRJNA806354_P_NODE_40166_length_243_cov_0.905882_g40057_i0 | PRJNA806354 | 40166 | 243 | 0.905882 | 2.20129326 | Penicillium ochrosalmoneum | 29840 | Fungi | Fungi | 412 | 8.72e-111 | NTclustered | gi|157168320|gb|EF626957.1| | 29840 | g40057 | i0 | 97.899 | 104.316872427984 | 238 | 5 | 98 | 0 | 3 | 240 | 1794 | 1557 | Eupenicillium ochrosalmoneum isolate NRRL 3323 28S ribosomal RNA gene, partial sequence | blastn | 25349 | 412 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium ochrosalmoneum | |
| 8459085 | 8459085 | PRJNA806354_P_NODE_4007_length_677_cov_10.211921_g3900_i0 | PRJNA806354 | 4007 | 677 | 10.211921 | 69.13470517 | Trichophyton rubrum | 5551 | Fungi | Fungi | 1245 | 0 | NTclustered | gi|404321321|gb|JX431933.1| | 5551 | g3900 | i0 | 100 | 106.001477104874 | 674 | 0 | 99 | 0 | 1 | 674 | 6968 | 6295 | Trichophyton rubrum strain CBS 118892 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 25S ribosomal RNA gene, complete sequence | blastn | 71763 | 1245 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Trichophyton | Trichophyton rubrum | |
| 9734090 | 9734090 | PRJNA806354_P_NODE_35608_length_250_cov_1.740113_g35499_i0 | PRJNA806354 | 35608 | 250 | 1.740113 | 4.3502825 | Ustilaginoidea virens | 1159556 | Fungi | Fungi | 460 | 3.17e-125 | NTclustered | gi|1828186227|dbj|LC474612.1| | 1159556 | g35499 | i0 | 100 | 99.644 | 249 | 0 | 99 | 0 | 2 | 250 | 899 | 651 | Ustilaginoidea virens MAFF 240994 genes for 18S rRNA, ITS1, 5.8S rRNA, ITS2, 28S rRNA, partial and complete sequence | blastn | 24911 | 460 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Clavicipitaceae | Ustilaginoidea | Ustilaginoidea virens | |
| 12285486 | 12285486 | PRJNA806354_P_NODE_38770_length_245_cov_0.895349_g38661_i0 | PRJNA806354 | 38770 | 245 | 0.895349 | 2.19360505 | Trichophyton rubrum | 5551 | Fungi | Fungi | 276 | 1.21e-69 | NTclustered | gi|327295427|ref|XM_003232361.1| | 559305 | g38661 | i0 | 100 | 1.82448979591837 | 149 | 0 | 61 | 0 | 1 | 149 | 149 | 1 | Trichophyton rubrum CBS 118892 uncharacterized protein (TERG_07257), partial mRNA | blastn | 447 | 276 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Trichophyton | Trichophyton rubrum | |
| 20348762 | 20348762 | PRJNA806354_P_NODE_26036_length_288_cov_9.586047_g25927_i0 | PRJNA806354 | 26036 | 288 | 9.586047 | 27.60781536 | Arthrodermataceae | 34384 | Fungi | Fungi | 532 | 7.8e-147 | NTclustered | gi|2721721065|gb|PP725255.1| | 5551 | g25927 | i0 | 100 | 99.5451388888889 | 288 | 0 | 100 | 0 | 1 | 288 | 41 | 328 | Trichophyton rubrum isolate DAA03 internal transcribed spacer region, partial sequence | blastn | 28669 | 532 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Trichophyton | Trichophyton rubrum | |
| 21208252 | 21208252 | PRJNA806354_P_NODE_24197_length_298_cov_8.915556_g24088_i0 | PRJNA806354 | 24197 | 298 | 8.915556 | 26.56835688 | Trichophyton rubrum | 5551 | Fungi | Fungi | 551 | 2.239999999999999e-152 | NTclustered | gi|404321321|gb|JX431933.1| | 5551 | g24088 | i0 | 100 | 104.593959731544 | 298 | 0 | 100 | 0 | 1 | 298 | 8517 | 8220 | Trichophyton rubrum strain CBS 118892 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 25S ribosomal RNA gene, complete sequence | blastn | 31169 | 551 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Trichophyton | Trichophyton rubrum | |
| 21624455 | 21624455 | PRJNA806354_P_NODE_40757_length_242_cov_0.911243_g40648_i0 | PRJNA806354 | 40757 | 242 | 0.911243 | 2.20520806 | Aspergillus | 5052 | Fungi | Fungi | 446 | 8.559999999999998e-121 | NTclustered | gi|146322657|ref|XM_001481682.1| | 330879 | g40648 | i0 | 100 | 8.94214876033058 | 241 | 0 | 99 | 0 | 1 | 241 | 197 | 437 | Aspergillus fumigatus Af293 D-arabinono-1,4-lactone oxidase (AFUA_1G14950), partial mRNA | blastn | 2164 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 22483021 | 22483021 | PRJNA806354_P_NODE_40758_length_242_cov_0.911243_g40649_i0 | PRJNA806354 | 40758 | 242 | 0.911243 | 2.20520806 | Aspergillus fumigatus | 746128 | Fungi | Fungi | 353 | 5.34e-93 | NTclustered | gi|2279896920|gb|CP097565.1| | 746128 | g40649 | i0 | 100 | 2.26859504132231 | 191 | 0 | 100 | 0 | 1 | 191 | 67010 | 67200 | Aspergillus fumigatus CEA10 chromosome 3 | blastn | 549 | 353 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus fumigatus | |
| 22899971 | 22899971 | PRJNA806354_P_NODE_17718_length_342_cov_10.914498_g17609_i0 | PRJNA806354 | 17718 | 342 | 10.914498 | 37.32758316 | root | 1 | Root_unresolved | Root_unresolved | 625 | 1.5199999999999998e-174 | NTclustered | gi|1473255798|gb|MH868742.1| | 5074 | g17609 | i0 | 99.707 | 99.7076023391813 | 341 | 1 | 99 | 0 | 2 | 342 | 382 | 42 | Penicillium brevicompactum culture CBS:287.53 strain CBS 287.53 large subunit ribosomal RNA gene, partial sequence | blastn | 34100 | 625 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium brevicompactum | |
| 24174027 | 24174027 | PRJNA806354_P_NODE_8519_length_479_cov_2.036946_g8410_i0 | PRJNA806354 | 8519 | 479 | 2.036946 | 9.75697134 | Opisthokonta | 33154 | Fungi | Fungi | 819 | 0 | NTclustered | gi|325484983|gb|HQ407432.1| | 5061 | g8410 | i0 | 99.121 | 94.9770354906054 | 455 | 4 | 95 | 0 | 25 | 479 | 675 | 221 | Aspergillus niger strain B1.Eg mitochondrial citrate synthase precursor, gene, partial cds; nuclear gene for mitochondrial product | blastn | 45494 | 819 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 25032510 | 25032510 | PRJNA806354_P_NODE_37080_length_248_cov_0.880000_g36971_i0 | PRJNA806354 | 37080 | 248 | 0.88 | 2.1824 | Trichophyton rubrum | 5551 | Fungi | Fungi | 446 | 8.81e-121 | NTclustered | gi|2225432057|ref|XM_003231762.2| | 559305 | g36971 | i0 | 100 | 2.27822580645161 | 241 | 0 | 97 | 0 | 1 | 241 | 3370 | 3610 | Trichophyton rubrum CBS 118892 uncharacterized protein (TERG_07429), mRNA | blastn | 565 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Trichophyton | Trichophyton rubrum | |
| 25032570 | 25032570 | PRJNA806354_P_NODE_5100_length_605_cov_17.112782_g4992_i0 | PRJNA806354 | 5100 | 605 | 17.112782 | 103.5323311 | Trichophyton rubrum | 5551 | Fungi | Fungi | 1114 | 0 | NTclustered | gi|404321321|gb|JX431933.1| | 5551 | g4992 | i0 | 100 | 94.5917355371901 | 603 | 0 | 99 | 0 | 3 | 605 | 4844 | 5446 | Trichophyton rubrum strain CBS 118892 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 25S ribosomal RNA gene, complete sequence | blastn | 57228 | 1114 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Onygenales | Arthrodermataceae | Trichophyton | Trichophyton rubrum | |
| 28736832 | 28736832 | PRJNA806354_P_NODE_37727_length_247_cov_0.885057_g37618_i0 | PRJNA806354 | 37727 | 247 | 0.885057 | 2.18609079 | Lasiosphaeria | 92901 | Fungi | Fungi | 92.8 | 9.07e-20 | NR | KAK3358447.1 | 92902 | g37618 | i0 | 52.4 | 3.97165991902834 | 82 | 37 | 97.2 | 1 | 7 | 246 | 347 | 428 | KAK3358447.1 quinon protein alcohol dehydrogenase-like superfamily [Lasiosphaeria ovina] | diamond | 981 | 93.2 | 0.995708154506438 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Sordariales | Lasiosphaeriaceae | Lasiosphaeria | Lasiosphaeria ovina | |
| 31602897 | 31602897 | PRJNA806354_P_NODE_33116_length_258_cov_2.378378_g33007_i0 | PRJNA806354 | 33116 | 258 | 2.378378 | 6.13621524 | Pleurostoma richardsiae | 41990 | Fungi | Fungi | 75.5 | 1.18e-13 | NR | KAJ9156173.1 | 41990 | g33007 | i0 | 49.4 | 0.988372093023256 | 85 | 42 | 98.8 | 1 | 1 | 255 | 257 | 340 | KAJ9156173.1 GPI-anchored cell wall organization protein ecm33 [Pleurostoma richardsiae] | diamond | 255 | 75.5 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Calosphaeriales | Pleurostomataceae | Pleurostoma | Pleurostoma richardsiae |
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);;