contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJEB1404" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 21116 | 21116 | PRJEB1404_S_NODE_501_length_342_cov_16.605863_g481_i0 | PRJEB1404 | 501 | 342 | 16.605863 | 56.79205146 | uncultured fungus | 175245 | Fungi | Fungi | 566 | 9.339999999999999e-157 | NTclustered | gi|375156220|gb|JQ311569.1| | 175245 | g481 | i0 | 96.491 | 101.014619883041 | 342 | 12 | 100 | 0 | 1 | 342 | 17 | 358 | Uncultured soil fungus clone OTU97-769 28S ribosomal RNA gene, partial sequence | blastn | 34547 | 566 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 2261002 | 2261002 | PRJEB1404_S_NODE_4702_length_151_cov_1.724138_g4682_i0 | PRJEB1404 | 4702 | 151 | 1.724138 | 2.60344838 | Pucciniales | 5258 | Fungi | Fungi | 52.8 | 0.012 | NTclustered | gi|1714236393|ref|NC_044121.1| | 181123 | g4682 | i0 | 100 | 0.370860927152318 | 28 | 0 | 19 | 0 | 124 | 151 | 43867 | 43840 | Austropuccinia psidii isolate MF-1 mitochondrion, complete genome | blastn | 56 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Sphaerophragmiaceae | Austropuccinia | Austropuccinia psidii | |
| 3536320 | 3536320 | PRJEB1404_S_NODE_2463_length_205_cov_3.976471_g2443_i0 | PRJEB1404 | 2463 | 205 | 3.976471 | 8.15176555 | Ascomycota | 4890 | Fungi | Fungi | 379 | 7.229999999999999e-101 | NTclustered | gi|767813157|gb|KP114602.1| | 29917 | g2443 | i0 | 100 | 100 | 205 | 0 | 100 | 0 | 1 | 205 | 111 | 315 | Cladosporium cladosporioides strain PF3 large subunit ribosomal RNA gene, partial sequence | blastn | 20500 | 379 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 6399235 | 6399235 | PRJEB1404_S_NODE_1506_length_248_cov_1.835681_g1486_i0 | PRJEB1404 | 1506 | 248 | 1.835681 | 4.55248888 | uncultured fungus | 175245 | Fungi | Fungi | 126 | 1.2999999999999998e-24 | NTclustered | gi|2159203900|emb|OU942302.1| | 175245 | g1486 | i0 | 93.976 | 2.52822580645161 | 83 | 5 | 33 | 0 | 1 | 83 | 832 | 750 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus03597 | blastn | 627 | 126 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 7673303 | 7673303 | PRJEB1404_S_NODE_487_length_345_cov_6139.296774_g467_i0 | PRJEB1404 | 487 | 345 | 6139.296774 | 21180.5738703 | uncultured fungus | 175245 | Fungi | Fungi | 315 | 3.77e-81 | NTclustered | gi|2159204291|emb|OU942693.1| | 175245 | g467 | i0 | 91.379 | 56.7942028985507 | 232 | 17 | 67 | 3 | 115 | 345 | 864 | 635 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus03987 | blastn | 19594 | 315 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 10223849 | 10223849 | PRJEB1404_S_NODE_3029_length_185_cov_2.973333_g3009_i0 | PRJEB1404 | 3029 | 185 | 2.973333 | 5.50066605 | Allomyces macrogynus | 28583 | Fungi | Fungi | 307 | 3.05e-79 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g3009 | i0 | 98.295 | 2.6 | 176 | 2 | 95 | 1 | 11 | 185 | 1748 | 1573 | Allomyces macrogynus mitochondrion, complete genome | blastn | 481 | 307 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 11499120 | 11499120 | PRJEB1404_P_NODE_1650_length_268_cov_1.299578_g1624_i0 | PRJEB1404 | 1650 | 268 | 1.299578 | 3.48286904 | Hannaella oryzae | 4979 | Fungi | Fungi | 99 | 3.11e-16 | NTclustered | gi|388597977|gb|JQ754107.1| | 4979 | g1624 | i0 | 89.61 | 49.0037313432836 | 77 | 8 | 29 | 0 | 3 | 79 | 1 | 77 | Hannaella oryzae strain CMT22 large subunit ribosomal RNA gene, partial sequence | blastn | 13133 | 99 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleribasidiaceae | Hannaella | Hannaella oryzae | |
| 11499122 | 11499122 | PRJEB1404_P_NODE_3170_length_200_cov_17.349112_g3144_i0 | PRJEB1404 | 3170 | 200 | 17.349112 | 34.698224 | uncultured fungus | 175245 | Fungi | Fungi | 267 | 5.699999999999999e-67 | NTclustered | gi|2159202804|emb|OU941232.1| | 175245 | g3144 | i0 | 91.795 | 83.785 | 195 | 11 | 97 | 4 | 8 | 200 | 903 | 712 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus02526 | blastn | 16757 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 15013558 | 15013558 | PRJEB1404_P_NODE_2752_length_214_cov_3.830601_g2726_i0 | PRJEB1404 | 2752 | 214 | 3.830601 | 8.19748614 | Eukaryota | 2759 | Fungi | Fungi | 361 | 2.7599999999999993e-95 | NTclustered | gi|583831563|gb|KF565126.1| | 175245 | g2726 | i0 | 97.183 | 99.0794392523364 | 213 | 6 | 99 | 0 | 1 | 213 | 110 | 322 | Uncultured soil fungus clone NCD_LSU_otu156 28S ribosomal RNA gene, partial sequence | blastn | 21203 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 15013559 | 15013559 | PRJEB1404_P_NODE_312_length_448_cov_5.460432_g293_i0 | PRJEB1404 | 312 | 448 | 5.460432 | 24.46273536 | Dothideales | 5014 | Fungi | Fungi | 689 | 0 | NTclustered | gi|28200380|gb|AY185811.1| | 5580 | g293 | i0 | 93.778 | 89.109375 | 450 | 25 | 100 | 3 | 1 | 448 | 944 | 496 | Aureobasidium pullulans isolate 044.4 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 26S ribosomal RNA gene, partial sequence | blastn | 39921 | 689 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium pullulans | |
| 17563561 | 17563561 | PRJEB1404_S_NODE_1194_length_265_cov_15.921739_g1174_i0 | PRJEB1404 | 1194 | 265 | 15.921739 | 42.19260835 | Eukaryota | 2759 | Fungi | Fungi | 488 | 1.5599999999999996e-133 | NTclustered | gi|514829572|gb|KC771883.1| | 4929 | g1174 | i0 | 100 | 82.9396226415094 | 264 | 0 | 99 | 0 | 1 | 264 | 299 | 36 | Meyerozyma guilliermondii strain SNP3S 26S ribosomal RNA gene, partial sequence | blastn | 21979 | 488 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Debaryomycetaceae | Meyerozyma | Meyerozyma guilliermondii | |
| 20112291 | 20112291 | PRJEB1404_S_NODE_3656_length_169_cov_3.761194_g3636_i0 | PRJEB1404 | 3656 | 169 | 3.761194 | 6.35641786 | Eukaryota | 2759 | Fungi | Fungi | 159 | 8.08e-35 | NTclustered | gi|583832639|gb|KF566202.1| | 175245 | g3636 | i0 | 100 | 50.9289940828402 | 86 | 0 | 51 | 0 | 84 | 169 | 419 | 334 | Uncultured soil fungus clone NCD_LSU_otu1232 28S ribosomal RNA gene, partial sequence | blastn | 8607 | 159 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 20421771 | 20421771 | PRJEB1404_S_NODE_2017_length_224_cov_5.613757_g1997_i0 | PRJEB1404 | 2017 | 224 | 5.613757 | 12.57481568 | Hanseniaspora uvarum | 29833 | Fungi | Fungi | 75 | 4.25e-9 | NTclustered | gi|974144812|gb|KT922772.1| | 29833 | g1997 | i0 | 86.567 | 0.299107142857143 | 67 | 9 | 30 | 0 | 158 | 224 | 262 | 328 | Hanseniaspora uvarum strain NS-O-49 26S ribosomal RNA gene, partial sequence | blastn | 67 | 75 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycodales | Saccharomycodaceae | Hanseniaspora | Hanseniaspora uvarum | |
| 21697809 | 21697809 | PRJEB1404_P_NODE_338_length_438_cov_5.687961_g318_i0 | PRJEB1404 | 338 | 438 | 5.687961 | 24.91326918 | uncultured fungus | 175245 | Fungi | Fungi | 553 | 9.519999999999996e-153 | NTclustered | gi|583833451|gb|KF567014.1| | 175245 | g318 | i0 | 92.308 | 62.5045662100457 | 390 | 28 | 89 | 2 | 25 | 413 | 389 | 1 | Uncultured soil fungus clone NCD_LSU_otu2044 28S ribosomal RNA gene, partial sequence | blastn | 27377 | 553 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 23938074 | 23938074 | PRJEB1404_S_NODE_919_length_286_cov_4.494024_g899_i0 | PRJEB1404 | 919 | 286 | 4.494024 | 12.85290864 | Eukaryota | 2759 | Fungi | Fungi | 507 | 4.69e-139 | NTclustered | gi|401670345|gb|JX408364.1| | 341458 | g899 | i0 | 98.601 | 105 | 286 | 4 | 100 | 0 | 1 | 286 | 21 | 306 | Uncultured Saccharomyces clone MEC_1919 26S ribosomal RNA gene, partial sequence | blastn | 30030 | 507 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | uncultured Saccharomyces | ||
| 24246911 | 24246911 | PRJEB1404_P_NODE_4040_length_174_cov_1.860140_g4014_i0 | PRJEB1404 | 4040 | 174 | 1.86014 | 3.2366436 | uncultured fungus | 175245 | Fungi | Fungi | 244 | 2.25e-60 | NTclustered | gi|2159204433|emb|OU942835.1| | 175245 | g4014 | i0 | 93.865 | 36.9080459770115 | 163 | 9 | 94 | 1 | 9 | 171 | 1682 | 1843 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus04129 | blastn | 6422 | 244 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus |
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);;