contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA591000" and tax_kingdom = "Fungi"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 564959 | 564959 | PRJNA591000_P_NODE_11661_length_421_cov_4.469388_g5081_i1 | PRJNA591000 | 11661 | 421 | 4.469388 | 18.81612348 | Malassezia restricta | 76775 | Fungi | Fungi | 756 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g5081 | i1 | 99.518 | 98.0356294536817 | 415 | 2 | 99 | 0 | 7 | 421 | 1528 | 1942 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 41273 | 756 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 564966 | 564966 | PRJNA591000_P_NODE_1741_length_950_cov_12.136808_g1260_i0 | PRJNA591000 | 1741 | 950 | 12.136808 | 115.299676 | Malassezia globosa | 76773 | Fungi | Fungi | 1218 | 0 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g1260 | i0 | 96.735 | 65.7421052631579 | 735 | 16 | 88 | 5 | 219 | 950 | 2487 | 1758 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 62455 | 1218 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 5668670 | 5668670 | PRJNA591000_P_NODE_2545_length_839_cov_14.365432_g1260_i1 | PRJNA591000 | 2545 | 839 | 14.365432 | 120.52597448 | Malassezia globosa | 76773 | Fungi | Fungi | 1415 | 0 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g1260 | i1 | 97.15 | 74.150178784267 | 842 | 16 | 100 | 5 | 1 | 839 | 2487 | 1651 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 62212 | 1415 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 7516473 | 7516473 | PRJNA591000_P_NODE_13046_length_406_cov_0.899204_g11457_i0 | PRJNA591000 | 13046 | 406 | 0.899204 | 3.65076824 | Eurotiomycetes | 147545 | Fungi | Fungi | 182 | 4.76e-41 | NTclustered | gi|225134683|gb|FJ345355.1| | 5076 | g11457 | i0 | 98.077 | 28.1896551724138 | 104 | 2 | 26 | 0 | 293 | 396 | 3609 | 3712 | Penicillium chrysogenum strain ATCC 10108 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 | 11445 | 183 | 0.994535519125683 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium chrysogenum | |
| 9493345 | 9493345 | PRJNA591000_P_NODE_7648_length_504_cov_3.797895_g6166_i0 | PRJNA591000 | 7648 | 504 | 3.797895 | 19.1413908 | uncultured fungus | 175245 | Fungi | Fungi | 374 | 9.259999999999996e-99 | NTclustered | gi|2159200851|emb|OU939467.1| | 175245 | g6166 | i0 | 97.273 | 33.7539682539683 | 220 | 6 | 88 | 0 | 13 | 232 | 415 | 634 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus00760 | blastn | 17012 | 374 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 11341962 | 11341962 | PRJNA591000_P_NODE_12229_length_415_cov_1.217617_g10643_i0 | PRJNA591000 | 12229 | 415 | 1.217617 | 5.05311055 | Malassezia | 55193 | Fungi | Fungi | 198 | 4.84e-46 | NTclustered | gi|52631075|gb|AY745725.1| | 55194 | g10643 | i0 | 100 | 35.1759036144578 | 107 | 0 | 40 | 0 | 1 | 107 | 1060 | 954 | Malassezia furfur isolate AFTOL-ID 855 25S large subunit ribosomal RNA gene, partial sequence | blastn | 14598 | 198 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia furfur | |
| 13318904 | 13318904 | PRJNA591000_P_NODE_16431_length_163_cov_1.768657_g14825_i0 | PRJNA591000 | 16431 | 163 | 1.768657 | 2.88291091 | Malassezia globosa | 76773 | Fungi | Fungi | 302 | 1.22e-77 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g14825 | i0 | 100 | 52.9447852760736 | 163 | 0 | 100 | 0 | 1 | 163 | 544 | 706 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 8630 | 302 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 15166719 | 15166719 | PRJNA591000_P_NODE_2012_length_908_cov_2.277588_g1485_i0 | PRJNA591000 | 2012 | 908 | 2.277588 | 20.68049904 | Pleosporaceae | 28556 | Fungi | Fungi | 261 | 1.4e-64 | NTclustered | gi|745167088|gb|KP143686.1| | 91367 | g1485 | i0 | 98.649 | 39.8810572687225 | 148 | 0 | 47 | 2 | 400 | 546 | 695 | 549 | Curvularia coicis strain C4015B1PD1CC1123 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 36212 | 261 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Curvularia | Curvularia coicis | |
| 20265131 | 20265131 | PRJNA591000_P_NODE_1696_length_959_cov_2.927957_g1221_i0 | PRJNA591000 | 1696 | 959 | 2.927957 | 28.07910763 | Malassezia | 55193 | Fungi | Fungi | 845 | 0 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g1221 | i0 | 99.783 | 38.9134515119917 | 460 | 1 | 84 | 0 | 185 | 644 | 1391 | 932 | Malassezia restricta mitochondrion, complete genome | blastn | 37318 | 845 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 22815809 | 22815809 | PRJNA591000_P_NODE_2118_length_892_cov_3.446118_g1221_i1 | PRJNA591000 | 2118 | 892 | 3.446118 | 30.73937256 | Malassezia | 55193 | Fungi | Fungi | 845 | 0 | NTclustered | gi|1321659621|gb|KY911094.1| | 76775 | g1221 | i1 | 99.783 | 46.6412556053812 | 460 | 1 | 98 | 0 | 249 | 708 | 932 | 1391 | Malassezia restricta mitochondrion, complete genome | blastn | 41604 | 845 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 25364891 | 25364891 | PRJNA591000_P_NODE_13860_length_396_cov_2.378747_g12265_i0 | PRJNA591000 | 13860 | 396 | 2.378747 | 9.41983812 | root | 1 | Root_unresolved | Root_unresolved | 54.7 | 0.011 | NTclustered | gi|1919354724|ref|XM_036634783.1| | 690259 | g12265 | i0 | 100 | 0.578282828282828 | 29 | 0 | 7 | 0 | 27 | 55 | 436 | 408 | Colletotrichum siamense Sporulation protein kinase pit1 (pit1), partial mRNA | blastn | 229 | 54.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Glomerellales | Glomerellaceae | Colletotrichum | Colletotrichum siamense |
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);;