contig_metadata
16 rows where bioproject = "PRJNA1057075" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1011332 | 1011332 | PRJNA1057075_S_NODE_1601_length_305_cov_5.835938_g1502_i0 | PRJNA1057075 | 1601 | 305 | 5.835938 | 17.7996109 | root | 1 | Root_unresolved | Root_unresolved | 52.8 | 0.028 | NTclustered | gi|2837842073|ref|XM_069420121.1| | 89139 | g1502 | i0 | 100 | 0.19672131147541 | 28 | 0 | 9 | 0 | 31 | 58 | 2292 | 2265 | Rasamsonia byssochlamydoides uncharacterized protein (VTN77DRAFT_41), partial mRNA | blastn | 60 | 52.8 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Trichocomaceae | Rasamsonia | Rasamsonia byssochlamydoides | |
| 2727086 | 2727086 | PRJNA1057075_S_NODE_2163_length_277_cov_1277.412281_g2064_i0 | PRJNA1057075 | 2163 | 277 | 1277.412281 | 3538.43201837 | uncultured fungus | 175245 | Fungi | Fungi | 329 | 1.05e-85 | NTclustered | gi|583832671|gb|KF566234.1| | 175245 | g2064 | i0 | 92.609 | 75.6714801444043 | 230 | 15 | 83 | 2 | 4 | 232 | 130 | 358 | Uncultured soil fungus clone NCD_LSU_otu1264 28S ribosomal RNA gene, partial sequence | blastn | 20961 | 329 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 3562016 | 3562016 | PRJNA1057075_S_NODE_863_length_367_cov_38221.251572_g764_i0 | PRJNA1057075 | 863 | 367 | 38221.251572 | 140271.99326924 | Ascomycota | 4890 | Fungi | Fungi | 542 | 1.6999999999999995e-149 | NTclustered | gi|1802567479|gb|MT000479.1| | 45277 | g764 | i0 | 97.771 | 85.558583106267 | 314 | 7 | 86 | 0 | 50 | 363 | 315 | 2 | Sarocladium kiliense strain LSU0027 large subunit ribosomal RNA gene, partial sequence | blastn | 31400 | 542 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium kiliense | |
| 4003063 | 4003063 | PRJNA1057075_S_NODE_904_length_364_cov_9.558730_g805_i0 | PRJNA1057075 | 904 | 364 | 9.55873 | 34.7937772 | uncultured fungus | 175245 | Fungi | Fungi | 366 | 1.09e-96 | NTclustered | gi|2159202025|emb|OU940232.1| | 175245 | g805 | i0 | 90.141 | 72.9615384615385 | 284 | 24 | 77 | 4 | 81 | 361 | 454 | 172 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01527 | blastn | 26558 | 366 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 11655159 | 11655159 | PRJNA1057075_S_NODE_7310_length_175_cov_1.571429_g7211_i0 | PRJNA1057075 | 7310 | 175 | 1.571429 | 2.75000075 | uncultured fungus | 175245 | Fungi | Fungi | 311 | 2.2e-80 | NTclustered | gi|375156277|gb|JQ311626.1| | 175245 | g7211 | i0 | 100 | 138.771428571429 | 168 | 0 | 96 | 0 | 1 | 168 | 283 | 450 | Uncultured soil fungus clone OTU97-82 28S ribosomal RNA gene, partial sequence | blastn | 24285 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 14205269 | 14205269 | PRJNA1057075_S_NODE_1692_length_299_cov_48.028000_g1593_i0 | PRJNA1057075 | 1692 | 299 | 48.028 | 143.60372 | uncultured fungus | 175245 | Fungi | Fungi | 385 | 2.41e-102 | NTclustered | gi|2159204433|emb|OU942835.1| | 175245 | g1593 | i0 | 90.066 | 29.1973244147157 | 302 | 22 | 100 | 6 | 1 | 299 | 1864 | 1568 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus04129 | blastn | 8730 | 385 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 16313748 | 16313748 | PRJNA1057075_S_NODE_873_length_366_cov_28363.782334_g774_i0 | PRJNA1057075 | 873 | 366 | 28363.782334 | 103811.44334244 | Ascomycota | 4890 | Fungi | Fungi | 542 | 1.69e-149 | NTclustered | gi|1473258532|gb|MH871476.1| | 5046 | g774 | i0 | 97.771 | 85.792349726776 | 314 | 7 | 86 | 0 | 49 | 362 | 364 | 51 | Sarocladium strictum culture CBS:376.70M strain CBS 376.70M large subunit ribosomal RNA gene, partial sequence | blastn | 31400 | 547 | 0.990859232175503 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 16753486 | 16753486 | PRJNA1057075_S_NODE_1094_length_343_cov_35609.074830_g995_i0 | PRJNA1057075 | 1094 | 343 | 35609.07483 | 122139.1266669 | uncultured fungus | 175245 | Fungi | Fungi | 475 | 1.62e-129 | NTclustered | gi|583833157|gb|KF566720.1| | 175245 | g995 | i0 | 95.918 | 111.880466472303 | 294 | 10 | 85 | 2 | 51 | 343 | 333 | 41 | Uncultured soil fungus clone NCD_LSU_otu1750 28S ribosomal RNA gene, partial sequence | blastn | 38375 | 475 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 18028390 | 18028390 | PRJNA1057075_S_NODE_215_length_519_cov_554.819149_g156_i0 | PRJNA1057075 | 215 | 519 | 554.819149 | 2879.51138331 | uncultured fungus | 175245 | Fungi | Fungi | 590 | 8.719999999999999e-164 | NTclustered | gi|583832972|gb|KF566535.1| | 175245 | g156 | i0 | 92.875 | 84.4065510597302 | 407 | 27 | 78 | 2 | 19 | 424 | 1 | 406 | Uncultured soil fungus clone NCD_LSU_otu1565 28S ribosomal RNA gene, partial sequence | blastn | 43807 | 590 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 19302307 | 19302307 | PRJNA1057075_S_NODE_2796_length_254_cov_51176.985366_g2697_i0 | PRJNA1057075 | 2796 | 254 | 51176.985366 | 129989.54282964 | Trichoderma atroviride | 63577 | Fungi | Fungi | 86.1 | 2.27e-12 | NTclustered | gi|2749703766|ref|XM_014090103.2| | 63577 | g2697 | i0 | 88 | 16.9173228346457 | 75 | 6 | 30 | 1 | 14 | 88 | 2269 | 2198 | Trichoderma atroviride uncharacterized protein (TrAtP1_012533), partial mRNA | blastn | 4297 | 86.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Hypocreaceae | Trichoderma | Trichoderma atroviride | |
| 20137730 | 20137730 | PRJNA1057075_S_NODE_1016_length_351_cov_339.536424_g917_i0 | PRJNA1057075 | 1016 | 351 | 339.536424 | 1191.77284824 | Ascomycota | 4890 | Fungi | Fungi | 529 | 1.2599999999999996e-145 | NTclustered | gi|1473258532|gb|MH871476.1| | 5046 | g917 | i0 | 98.026 | 86.6096866096866 | 304 | 6 | 87 | 0 | 5 | 308 | 51 | 354 | Sarocladium strictum culture CBS:376.70M strain CBS 376.70M large subunit ribosomal RNA gene, partial sequence | blastn | 30400 | 534 | 0.99063670411985 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Sordariomycetes | Hypocreales | Sarocladiaceae | Sarocladium | Sarocladium strictum | |
| 23128893 | 23128893 | PRJNA1057075_S_NODE_319_length_472_cov_28828.252955_g156_i1 | PRJNA1057075 | 319 | 472 | 28828.252955 | 136069.3539476 | uncultured fungus | 175245 | Fungi | Fungi | 584 | 3.659999999999999e-162 | NTclustered | gi|583832972|gb|KF566535.1| | 175245 | g156 | i1 | 92.629 | 92.7754237288136 | 407 | 28 | 86 | 2 | 49 | 454 | 406 | 1 | Uncultured soil fungus clone NCD_LSU_otu1565 28S ribosomal RNA gene, partial sequence | blastn | 43790 | 584 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 23128896 | 23128896 | PRJNA1057075_S_NODE_3739_length_230_cov_3.480663_g3640_i0 | PRJNA1057075 | 3739 | 230 | 3.480663 | 8.0055249 | uncultured fungus | 175245 | Fungi | Fungi | 340 | 3.91e-89 | NTclustered | gi|2159201316|emb|OU940146.1| | 175245 | g3640 | i0 | 93.886 | 92.4913043478261 | 229 | 9 | 98 | 5 | 5 | 230 | 957 | 1183 | uncultured fungus genomic DNA sequence contains 18S rRNA gene, ITS1, 5.8S rRNA gene, ITS2, 28S rRNA gene, isolate consensus01440 | blastn | 21273 | 340 | 1 | Eukaryota | Opisthokonta | Fungi | uncultured fungus | ||||||
| 23128904 | 23128904 | PRJNA1057075_S_NODE_5699_length_192_cov_4.860140_g5600_i0 | PRJNA1057075 | 5699 | 192 | 4.86014 | 9.3314688 | Wickerhamiella azyma | 5488 | Fungi | Fungi | 73.1 | 1.27e-8 | NTclustered | gi|1209454344|ref|NG_055326.1| | 5488 | g5600 | i0 | 80.412 | 8.90104166666667 | 97 | 17 | 50 | 2 | 74 | 169 | 3041 | 2946 | Wickerhamiella azyma NRRL Y-17067 28S rRNA, partial sequence; from TYPE material | blastn | 1709 | 73.1 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dipodascomycetes | Dipodascales | Trichomonascaceae | Wickerhamiella | Wickerhamiella azyma | |
| 26869200 | 26869200 | PRJNA1057075_S_NODE_7841_length_171_cov_1.122951_g7742_i0 | PRJNA1057075 | 7841 | 171 | 1.122951 | 1.92024621 | Teratosphaeriaceae | 668547 | Fungi | Fungi | 47 | 1.43e-4 | NR | WPH01937.1 | 150365 | g7742 | i0 | 88.5 | 3.19298245614035 | 26 | 3 | 45.6 | 0 | 3 | 80 | 106 | 131 | WPH01937.1 60S ribosomal protein L32 [Acrodontium crateriforme] | diamond | 546 | 47.4 | 0.991561181434599 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Mycosphaerellales | Teratosphaeriaceae | Acrodontium | Acrodontium crateriforme | |
| 28077528 | 28077528 | PRJNA1057075_S_NODE_8965_length_164_cov_1.313043_g8866_i0 | PRJNA1057075 | 8965 | 164 | 1.313043 | 2.15339052 | Rhizoclosmatium sp. JEL | 2012244 | Fungi | Fungi | 44.3 | 0.00264 | NR | KAJ3287761.1 | 2784343 | g8866 | i0 | 60 | 0.548780487804878 | 30 | 12 | 54.9 | 0 | 162 | 73 | 156 | 185 | KAJ3287761.1 hypothetical protein HDU79_005437 [Rhizoclosmatium sp. JEL0117] | diamond | 90 | 44.3 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytriomycetaceae | Rhizoclosmatium | Rhizoclosmatium sp. JEL0117 |
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);;