contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA1263632" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1638517 | 1638517 | PRJNA1263632_P_NODE_3782_length_319_cov_0.939024_g3764_i0 | PRJNA1263632 | 3782 | 319 | 0.939024 | 2.99548656 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 200 | 1.0099999999999999e-46 | NTclustered | gi|1069947120|ref|XM_018433359.1| | 763407 | g3764 | i0 | 83.721 | 65.6332288401254 | 215 | 31 | 67 | 2 | 97 | 311 | 108 | 318 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein partial mRNA | blastn | 20937 | 200 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 5467029 | 5467029 | PRJNA1263632_P_NODE_3885_length_315_cov_0.950413_g3867_i0 | PRJNA1263632 | 3885 | 315 | 0.950413 | 2.99380095 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 195 | 4.63e-45 | NTclustered | gi|1069938230|ref|XM_018429293.1| | 763407 | g3867 | i0 | 80.228 | 34.0666666666667 | 263 | 48 | 83 | 4 | 7 | 267 | 3331 | 3071 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 10731 | 195 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 6741435 | 6741435 | PRJNA1263632_P_NODE_2966_length_355_cov_1.581560_g2948_i0 | PRJNA1263632 | 2966 | 355 | 1.58156 | 5.614538 | Saccharomyces paradoxus | 27291 | Fungi | Fungi | 191 | 6.82e-44 | NTclustered | gi|2087953814|gb|CP081976.1| | 27291 | g2948 | i0 | 81.048 | 50.0676056338028 | 248 | 39 | 69 | 8 | 1 | 244 | 58341 | 58098 | Mutant Saccharomyces paradoxus strain 337 chromosome X genomic sequence | blastn | 17774 | 191 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces paradoxus | |
| 9291758 | 9291758 | PRJNA1263632_P_NODE_1188_length_550_cov_2.350105_g1170_i0 | PRJNA1263632 | 1188 | 550 | 2.350105 | 12.9255775 | uncultured fungus | 175245 | Fungi | Fungi | 475 | 2.7099999999999994e-129 | NTclustered | gi|2159202804|emb|OU941232.1| | 175245 | g1170 | i0 | 82.554 | 44.44 | 556 | 82 | 99 | 15 | 1 | 549 | 762 | 1309 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus02526 | blastn | 24442 | 475 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 9291914 | 9291914 | PRJNA1263632_P_NODE_6128_length_255_cov_4.043956_g6110_i0 | PRJNA1263632 | 6128 | 255 | 4.043956 | 10.3120878 | Candida jiufengensis | 497108 | Fungi | Fungi | 213 | 1e-50 | NTclustered | gi|2325096801|ref|XM_051763683.1| | 497108 | g6110 | i0 | 82.917 | 80.8039215686274 | 240 | 38 | 93 | 3 | 6 | 243 | 143 | 381 | Candida jiufengensis translation elongation factor EF-1 alpha (KGF54_003128), partial mRNA | blastn | 20605 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida jiufengensis | |
| 10567728 | 10567728 | PRJNA1263632_P_NODE_1449_length_496_cov_1.366430_g1431_i0 | PRJNA1263632 | 1449 | 496 | 1.36643 | 6.7774928 | Cryptococcus depauperatus | 5208 | Fungi | Fungi | 60.2 | 2.89e-4 | NTclustered | gi|2753010347|ref|XM_066215550.1| | 1295531 | g1431 | i0 | 100 | 0.0645161290322581 | 32 | 0 | 6 | 0 | 97 | 128 | 179 | 148 | Cryptococcus depauperatus CBS 7841 uncharacterized protein (L203_106192), partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus depauperatus | |
| 11842296 | 11842296 | PRJNA1263632_P_NODE_1870_length_442_cov_1.791328_g1852_i0 | PRJNA1263632 | 1870 | 442 | 1.791328 | 7.91766976 | uncultured fungus | 175245 | Fungi | Fungi | 710 | 0 | NTclustered | gi|583834395|gb|KF567961.1| | 175245 | g1852 | i0 | 95.74 | 133.79185520362 | 446 | 10 | 99 | 7 | 2 | 442 | 108 | 549 | Uncultured soil fungus clone NCD_LSU_otu2991 28S ribosomal RNA gene, partial sequence | blastn | 59136 | 710 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 20180091 | 20180091 | PRJNA1263632_P_NODE_4196_length_303_cov_2.873913_g4178_i0 | PRJNA1263632 | 4196 | 303 | 2.873913 | 8.70795639 | Opisthokonta | 33154 | Fungi | Fungi | 58.4 | 6.07e-4 | NTclustered | gi|2491074381|gb|CP122417.1| | 5207 | g4178 | i0 | 90.698 | 1.5016501650165 | 43 | 4 | 14 | 0 | 100 | 142 | 737519 | 737561 | Cryptococcus neoformans isolate Bt63 | blastn | 455 | 58.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus neoformans | |
| 23315969 | 23315969 | PRJNA1263632_P_NODE_8059_length_243_cov_0.905882_g8041_i0 | PRJNA1263632 | 8059 | 243 | 0.905882 | 2.20129326 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 78.7 | 3.61e-10 | NTclustered | gi|2837739333|ref|XM_069371983.1| | 1052096 | g8041 | i0 | 94.118 | 15.8847736625514 | 51 | 3 | 21 | 0 | 193 | 243 | 379 | 429 | Cladosporium halotolerans Ras-related protein Rab-6B (Rab6b), mRNA | blastn | 3860 | 78.7 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 24590087 | 24590087 | PRJNA1263632_P_NODE_7200_length_247_cov_0.885057_g7182_i0 | PRJNA1263632 | 7200 | 247 | 0.885057 | 2.18609079 | Olpidium brassicae | 70189 | Fungi | Fungi | 152 | 2.1399999999999998e-32 | NTclustered | gi|358030887|dbj|AB609177.1| | 70189 | g7182 | i0 | 79.73 | 63.2591093117409 | 222 | 35 | 89 | 6 | 11 | 230 | 1235 | 1448 | Olpidium brassicae EF2 mRNA for translation elongation factor 2, partial cds, specimen_voucher: UBC:UBC F19784, clone: 2 | blastn | 15625 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Olpidiomycota | Olpidiomycetes | Olpidiales | Olpidiaceae | Olpidium | Olpidium brassicae | |
| 25280103 | 25280103 | PRJNA1263632_P_NODE_2980_length_354_cov_3.572954_g2962_i0 | PRJNA1263632 | 2980 | 354 | 3.572954 | 12.64825716 | Debaryomycetaceae | 766764 | Fungi | Fungi | 235 | 3.1e-57 | NTclustered | gi|68484887|ref|XM_708572.1| | 237561 | g2962 | i0 | 81.754 | 79.593220338983 | 285 | 48 | 80 | 4 | 1 | 283 | 352 | 70 | Candida albicans SC5314 Hht21p (HHT21), partial mRNA | blastn | 28176 | 237 | 0.991561181434599 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Candida | Candida albicans |
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);;