contig_metadata
13 rows where bioproject = "PRJEB6097" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3542811 | 3542811 | PRJEB6097_S_NODE_6083_length_170_cov_9.466667_g6029_i0 | PRJEB6097 | 6083 | 170 | 9.466667 | 16.0933339 | Agaricomycetes | 155619 | Fungi | Fungi | 99 | 1.8e-16 | NTclustered | gi|565619620|gb|KC603718.1| | 91677 | g6029 | i0 | 88.889 | 11.7647058823529 | 81 | 8 | 47 | 1 | 91 | 170 | 100 | 20 | Hebeloma radicosum voucher TNS Kasuya B791 large subunit ribosomal RNA gene, partial sequence | blastn | 2000 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Hymenogastraceae | Hebeloma | Hebeloma radicosum | |
| 7778083 | 7778083 | PRJEB6097_S_NODE_6087_length_170_cov_5.748148_g6033_i0 | PRJEB6097 | 6087 | 170 | 5.748148 | 9.7718516 | uncultured fungus | 175245 | Fungi | Fungi | 252 | 1.31e-62 | NTclustered | gi|400178660|gb|JX241713.1| | 175245 | g6033 | i0 | 93.491 | 6.22941176470588 | 169 | 11 | 99 | 0 | 1 | 169 | 269 | 101 | Uncultured fungus clone CheiFrLf2291 26S ribosomal RNA gene, partial sequence | blastn | 1059 | 252 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 7778086 | 7778086 | PRJEB6097_S_NODE_6287_length_164_cov_1.689922_g6233_i0 | PRJEB6097 | 6287 | 164 | 1.689922 | 2.77147208 | Ophiostoma torulosum | 96403 | Fungi | Fungi | 303 | 3.42e-78 | NTclustered | gi|325513885|gb|HQ343317.1| | 96403 | g6233 | i0 | 100 | 96.640243902439 | 164 | 0 | 100 | 0 | 1 | 164 | 3275 | 3112 | Ophiostoma torulosum strain CBS 730.71 small subunit ribosomal RNA gene, complete sequence; and reverse transcriptase and double motif LAGLIDADG homing endonuclease genes, complete cds; mitochondrial | blastn | 15849 | 303 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Ophiostomatales | Ophiostomataceae | Ophiostoma | Ophiostoma torulosum | |
| 9920474 | 9920474 | PRJEB6097_S_NODE_5848_length_181_cov_4.993151_g5794_i0 | PRJEB6097 | 5848 | 181 | 4.993151 | 9.03760331 | Saccharomyces | 4930 | Fungi | Fungi | 292 | 8.32e-75 | NTclustered | gi|2161760974|gb|OL763550.1| | 4932 | g5794 | i0 | 99.379 | 88.9005524861878 | 161 | 1 | 89 | 0 | 1 | 161 | 277 | 117 | Saccharomyces cerevisiae clone S5-19 large subunit ribosomal RNA gene, partial sequence | blastn | 16091 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 12471248 | 12471248 | PRJEB6097_S_NODE_110_length_573_cov_21970.540892_g56_i0 | PRJEB6097 | 110 | 573 | 21970.540892 | 125891.19931116 | Eukaryota | 2759 | Fungi | Fungi | 636 | 1.2299999999999998e-177 | NTclustered | gi|514829572|gb|KC771883.1| | 4929 | g56 | i0 | 100 | 56.1099476439791 | 344 | 0 | 60 | 0 | 230 | 573 | 368 | 25 | Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence | blastn | 32151 | 636 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii | |
| 12879215 | 12879215 | PRJEB6097_S_NODE_2831_length_275_cov_31.000000_g2777_i0 | PRJEB6097 | 2831 | 275 | 31 | 85.25 | uncultured fungus | 175245 | Fungi | Fungi | 448 | 2.7599999999999995e-121 | NTclustered | gi|2159201441|emb|OU940475.1| | 175245 | g2777 | i0 | 96 | 95.4872727272727 | 275 | 11 | 100 | 0 | 1 | 275 | 722 | 996 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01768 | blastn | 26259 | 448 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 16294941 | 16294941 | PRJEB6097_S_NODE_1333_length_338_cov_38955.623762_g1279_i0 | PRJEB6097 | 1333 | 338 | 38955.623762 | 131670.00831556 | Eukaryota | 2759 | Fungi | Fungi | 167 | 1.09e-36 | NTclustered | gi|658131895|emb|HF968949.1| | 4874 | g1279 | i0 | 96.078 | 45.1420118343195 | 102 | 4 | 30 | 0 | 237 | 338 | 1619 | 1518 | Gigaspora margarita partial 28S rRNA gene, strain BEG152, isolate spore 2, clone FL2_12_91 | blastn | 15258 | 167 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 16294944 | 16294944 | PRJEB6097_S_NODE_513_length_432_cov_29761.506297_g459_i0 | PRJEB6097 | 513 | 432 | 29761.506297 | 128569.70720304 | Opisthokonta | 33154 | Fungi | Fungi | 374 | 7.829999999999997e-99 | NTclustered | gi|66805490|gb|DQ008146.1| | 29917 | g459 | i0 | 99.512 | 47.4537037037037 | 205 | 1 | 47 | 0 | 1 | 205 | 193 | 397 | Cladosporium cladosporioides strain CBS 109501 28S large subunit ribosomal RNA gene, partial sequence | blastn | 20500 | 374 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 16702254 | 16702254 | PRJEB6097_S_NODE_2914_length_271_cov_22.855932_g2860_i0 | PRJEB6097 | 2914 | 271 | 22.855932 | 61.93957572 | uncultured fungus | 175245 | Fungi | Fungi | 315 | 2.87e-81 | NTclustered | gi|583831600|gb|KF565163.1| | 175245 | g2860 | i0 | 87.591 | 89.7675276752768 | 274 | 30 | 100 | 4 | 1 | 271 | 312 | 40 | Uncultured soil fungus clone NCD_LSU_otu193 28S ribosomal RNA gene, partial sequence | blastn | 24327 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 20526523 | 20526523 | PRJEB6097_S_NODE_5277_length_227_cov_4.234375_g5223_i0 | PRJEB6097 | 5277 | 227 | 4.234375 | 9.61203125 | Meyerozyma guilliermondii | 4929 | Fungi | Fungi | 217 | 6.78e-52 | NTclustered | gi|146421244|ref|XM_001486523.1| | 294746 | g5223 | i0 | 90.741 | 115.638766519824 | 162 | 15 | 71 | 0 | 1 | 162 | 1207 | 1368 | Meyerozyma guilliermondii ATCC 6260 ubiquitin (PGUG_02244), partial mRNA | blastn | 26250 | 217 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii | |
| 20526533 | 20526533 | PRJEB6097_S_NODE_97_length_599_cov_20504.757092_g44_i0 | PRJEB6097 | 97 | 599 | 20504.757092 | 122823.49498108 | uncultured fungus | 175245 | Fungi | Fungi | 394 | 8.55e-105 | NTclustered | gi|2159202025|emb|OU940232.1| | 175245 | g44 | i0 | 91.409 | 44.8597662771285 | 291 | 20 | 48 | 5 | 1 | 287 | 165 | 454 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01527 | blastn | 26871 | 394 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 23944600 | 23944600 | PRJEB6097_S_NODE_119_length_564_cov_21758.034026_g65_i0 | PRJEB6097 | 119 | 564 | 21758.034026 | 122715.31190664 | Eukaryota | 2759 | Fungi | Fungi | 617 | 4.37e-172 | NTclustered | gi|514829572|gb|KC771883.1| | 4929 | g65 | i0 | 100 | 54.6879432624113 | 334 | 0 | 59 | 0 | 1 | 334 | 25 | 358 | Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence | blastn | 30844 | 617 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii | |
| 27476026 | 27476026 | PRJEB6097_S_NODE_3823_length_256_cov_1.945701_g3769_i0 | PRJEB6097 | 3823 | 256 | 1.945701 | 4.98099456 | Jimgerdemannia flammicorona | 994334 | Fungi | Fungi | 46.2 | 7.6e-4 | NR | RUS34214.1 | 994334 | g3769 | i0 | 38.8 | 0.57421875 | 49 | 30 | 57.4 | 0 | 21 | 167 | 67 | 115 | RUS34214.1 hypothetical protein BC938DRAFT_481852 [Jimgerdemannia flammicorona] | diamond | 147 | 46.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Endogonomycetes | Endogonales | Endogonaceae | Jimgerdemannia | Jimgerdemannia flammicorona |
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);;