contig_metadata
17 rows where analysis = "blastn", bioproject = "PRJNA543299" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2394115 | 2394115 | PRJNA543299_P_NODE_24902_length_162_cov_0.902655_g24745_i0 | PRJNA543299 | 24902 | 162 | 0.902655 | 1.4623011 | Tremellales | 5234 | Fungi | Fungi | 294 | 2.03e-75 | NTclustered | gi|1850780|dbj|D78327.1| | 57471 | g24745 | i0 | 99.383 | 99.9753086419753 | 162 | 1 | 100 | 0 | 1 | 162 | 760 | 921 | Bullera hannae gene for small subunit ribosomal RNA | blastn | 16196 | 294 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Bulleraceae | Bullera | Bullera hannae | |
| 4336453 | 4336453 | PRJNA543299_P_NODE_13864_length_201_cov_1.342105_g13707_i0 | PRJNA543299 | 13864 | 201 | 1.342105 | 2.69763105 | Cladosporium herbarum | 29918 | Fungi | Fungi | 372 | 1.18e-98 | NTclustered | gi|284158823|gb|GU214410.1| | 29918 | g13707 | i0 | 100 | 99.9502487562189 | 201 | 0 | 100 | 0 | 1 | 201 | 1897 | 2097 | Cladosporium herbarum strain CBS 723.79 28S large subunit ribosomal RNA gene, partial sequence | blastn | 20090 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium herbarum | |
| 4946800 | 4946800 | PRJNA543299_P_NODE_17044_length_182_cov_1.172932_g16887_i0 | PRJNA543299 | 17044 | 182 | 1.172932 | 2.13473624 | Opisthokonta | 33154 | Fungi | Fungi | 230 | 6.659999999999998e-56 | NTclustered | gi|2159204445|emb|OU942847.1| | 175245 | g16887 | i0 | 89.474 | 80.7032967032967 | 190 | 9 | 99 | 6 | 1 | 181 | 1420 | 1233 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus04141 | blastn | 14688 | 230 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 6222251 | 6222251 | PRJNA543299_P_NODE_14145_length_199_cov_2.040000_g13988_i0 | PRJNA543299 | 14145 | 199 | 2.04 | 4.0596 | Fungi | 4751 | Fungi | Fungi | 368 | 1.51e-97 | NTclustered | gi|658131632|emb|HF968958.1| | 4874 | g13988 | i0 | 100 | 147.316582914573 | 199 | 0 | 100 | 0 | 1 | 199 | 1994 | 2192 | Gigaspora margarita partial 28S rRNA gene, strain BEG34, isolate spore 4, clone BL2_6_26 | blastn | 29316 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Diversisporales | Gigasporaceae | Gigaspora | Gigaspora margarita | |
| 8162447 | 8162447 | PRJNA543299_P_NODE_24007_length_163_cov_0.894737_g23850_i0 | PRJNA543299 | 24007 | 163 | 0.894737 | 1.45842131 | uncultured fungus | 175245 | Fungi | Fungi | 156 | 1.01e-33 | NTclustered | gi|375156063|gb|JQ311412.1| | 175245 | g23850 | i0 | 85.806 | 78.9141104294479 | 155 | 13 | 94 | 5 | 1 | 154 | 297 | 151 | Uncultured soil fungus clone OTU97-624 28S ribosomal RNA gene, partial sequence | blastn | 12863 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 10047086 | 10047086 | PRJNA543299_P_NODE_19208_length_171_cov_1.852459_g19051_i0 | PRJNA543299 | 19208 | 171 | 1.852459 | 3.16770489 | Opisthokonta | 33154 | Fungi | Fungi | 316 | 4.6e-82 | NTclustered | gi|283827952|gb|EU019262.2| | 29917 | g19051 | i0 | 100 | 100 | 171 | 0 | 100 | 0 | 1 | 171 | 2380 | 2550 | Cladosporium cladosporioides strain CBS 109.21 28S large subunit ribosomal RNA gene, partial sequence | blastn | 17100 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium cladosporioides | |
| 13872503 | 13872503 | PRJNA543299_P_NODE_17971_length_177_cov_1.804688_g17814_i0 | PRJNA543299 | 17971 | 177 | 1.804688 | 3.19429776 | Ascomycota | 4890 | Fungi | Fungi | 327 | 2.2199999999999996e-85 | NTclustered | gi|1338684535|gb|MG889595.1| | 5061 | g17814 | i0 | 100 | 100 | 177 | 0 | 100 | 0 | 1 | 177 | 867 | 691 | Aspergillus niger isolate soil small subunit ribosomal RNA gene, partial sequence | blastn | 17700 | 327 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Aspergillus | Aspergillus niger | |
| 15812428 | 15812428 | PRJNA543299_P_NODE_23073_length_164_cov_0.886957_g22916_i0 | PRJNA543299 | 23073 | 164 | 0.886957 | 1.45460948 | Penicillium verrucosum | 60171 | Fungi | Fungi | 89.8 | 1.04e-13 | NTclustered | gi|2515965191|ref|XM_057219713.1| | 60171 | g22916 | i0 | 98.039 | 0.609756097560976 | 51 | 1 | 31 | 0 | 1 | 51 | 847 | 897 | Penicillium verrucosum uncharacterized protein (N7516_006993), partial mRNA | blastn | 100 | 89.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium verrucosum | |
| 17696593 | 17696593 | PRJNA543299_P_NODE_9134_length_246_cov_1.157360_g8977_i0 | PRJNA543299 | 9134 | 246 | 1.15736 | 2.8471056 | Ascomycota | 4890 | Fungi | Fungi | 438 | 1.4599999999999996e-118 | NTclustered | gi|2034480785|gb|MZ152208.1| | 61296 | g8977 | i0 | 99.177 | 99.2560975609756 | 243 | 2 | 99 | 0 | 4 | 246 | 116 | 358 | Aureobasidium sp. isolate UFMG-CM-Y6821 large subunit ribosomal RNA gene, partial sequence | blastn | 24417 | 438 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Dothideales | Saccotheciaceae | Aureobasidium | Aureobasidium sp. | |
| 18361238 | 18361238 | PRJNA543299_P_NODE_25515_length_161_cov_1.723214_g25358_i0 | PRJNA543299 | 25515 | 161 | 1.723214 | 2.77437454 | uncultured fungus | 175245 | Fungi | Fungi | 102 | 1.31e-17 | NTclustered | gi|2159203900|emb|OU942302.1| | 175245 | g25358 | i0 | 90.909 | 60.6521739130435 | 77 | 5 | 47 | 2 | 86 | 161 | 222 | 147 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus03597 | blastn | 9765 | 102 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 18970175 | 18970175 | PRJNA543299_P_NODE_17395_length_180_cov_1.366412_g17238_i0 | PRJNA543299 | 17395 | 180 | 1.366412 | 2.4595416 | Hormonema | 46635 | Fungi | Fungi | 316 | 4.899999999999999e-82 | NTclustered | gi|387156426|emb|HE806159.1| | 209475 | g17238 | i0 | 98.333 | 100 | 180 | 3 | 100 | 0 | 1 | 180 | 1420 | 1599 | Uncultured Dothideomycetes partial 26S rRNA gene, clone EopYyyyy | blastn | 18000 | 316 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | uncultured Dothideomycetes | ||||
| 20245102 | 20245102 | PRJNA543299_P_NODE_26536_length_158_cov_2.807339_g26379_i0 | PRJNA543299 | 26536 | 158 | 2.807339 | 4.43559562 | Nephroma | 48858 | Fungi | Fungi | 292 | 7.07e-75 | NTclustered | gi|1517971702|gb|MH887516.1| | 203384 | g26379 | i0 | 100 | 100 | 158 | 0 | 100 | 0 | 1 | 158 | 4490 | 4647 | Nephroma helveticum small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 15800 | 292 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Lecanoromycetes | Peltigerales | Nephromataceae | Nephroma | Nephroma helveticum | |
| 20911588 | 20911588 | PRJNA543299_P_NODE_17997_length_177_cov_1.593750_g17840_i0 | PRJNA543299 | 17997 | 177 | 1.59375 | 2.8209375 | uncultured fungus | 175245 | Fungi | Fungi | 276 | 8.15e-70 | NTclustered | gi|2159200414|emb|OU939045.1| | 175245 | g17840 | i0 | 94.915 | 95.3728813559322 | 177 | 8 | 100 | 1 | 1 | 177 | 1500 | 1325 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus00339 | blastn | 16881 | 276 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 20911798 | 20911798 | PRJNA543299_P_NODE_6977_length_279_cov_3.069565_g6820_i0 | PRJNA543299 | 6977 | 279 | 3.069565 | 8.56408635 | uncultured fungus | 175245 | Fungi | Fungi | 108 | 5.41e-19 | NTclustered | gi|1189489950|gb|KY687716.1| | 175245 | g6820 | i0 | 94.366 | 25.1003584229391 | 71 | 2 | 25 | 2 | 210 | 279 | 1407 | 1338 | Uncultured fungus clone GL19521_135_G2819 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 7003 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 21520692 | 21520692 | PRJNA543299_P_NODE_15097_length_193_cov_1.416667_g14940_i0 | PRJNA543299 | 15097 | 193 | 1.416667 | 2.73416731 | Metschnikowia | 27320 | Fungi | Fungi | 52.8 | 0.017 | NTclustered | gi|927912810|gb|KR815866.1| | 1715865 | g14940 | i0 | 100 | 0.870466321243523 | 28 | 0 | 15 | 0 | 9 | 36 | 186 | 159 | Metschnikowia sp. UFMG-CM-Y3404 26S large subunit ribosomal RNA gene, partial sequence | blastn | 168 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Serinales | Metschnikowiaceae | Metschnikowia | Metschnikowia sp. UFMG-CM-Y3404 | |
| 23461897 | 23461897 | PRJNA543299_P_NODE_22959_length_164_cov_0.886957_g22802_i0 | PRJNA543299 | 22959 | 164 | 0.886957 | 1.45460948 | Cladosporium halotolerans | 1052096 | Fungi | Fungi | 254 | 3.5e-63 | NTclustered | gi|2837720680|ref|XM_069368823.1| | 1052096 | g22802 | i0 | 94.512 | 1 | 164 | 9 | 100 | 0 | 1 | 164 | 1203 | 1366 | Cladosporium halotolerans uncharacterized protein (WHR41_00217), mRNA | blastn | 164 | 254 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Cladosporiales | Cladosporiaceae | Cladosporium | Cladosporium halotolerans | |
| 24070606 | 24070606 | PRJNA543299_P_NODE_13759_length_202_cov_1.189542_g13602_i0 | PRJNA543299 | 13759 | 202 | 1.189542 | 2.40287484 | Eukaryota | 2759 | Fungi | Fungi | 368 | 1.54e-97 | NTclustered | gi|38570335|gb|L76614.1|CCURGOAA | 5570 | g13602 | i0 | 99.505 | 100 | 202 | 1 | 100 | 0 | 1 | 202 | 1379 | 1580 | Cenococcum geophilum strain 349 small subunit ribosomal RNA gene, complete sequence | blastn | 20200 | 368 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Gloniales | Gloniaceae | Cenococcum | Cenococcum geophilum |
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);;