contig_metadata
11 rows where bioproject = "PRJNA657860", tax_clade = "Opisthokonta" and tax_phylum = "Ascomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1161363 | 1161363 | PRJNA657860_P_NODE_1241_length_297_cov_3.680769_g1185_i0 | PRJNA657860 | 1241 | 297 | 3.680769 | 10.93188393 | Ascomycota | 4890 | Fungi | Fungi | 544 | 3.7299999999999996e-150 | NTclustered | gi|59797378|gb|AY761150.1| | 36025 | g1185 | i0 | 99.663 | 97.5151515151515 | 297 | 1 | 100 | 0 | 1 | 297 | 5 | 301 | Pichia holstii large subunit ribosomal RNA gene, partial sequence | blastn | 28962 | 544 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Alaninales | Pachysolenaceae | Nakazawaea | Nakazawaea holstii | |
| 1901633 | 1901633 | PRJNA657860_P_NODE_3342_length_161_cov_1.443548_g3286_i0 | PRJNA657860 | 3342 | 161 | 1.443548 | 2.32411228 | Alternaria alternata | 5599 | Fungi | Fungi | 267 | 4.39e-67 | NTclustered | gi|2791117515|gb|PQ217832.1| | 5599 | g3286 | i0 | 96.855 | 85.111801242236 | 159 | 5 | 99 | 0 | 1 | 159 | 5457 | 5615 | Alternaria alternata isolate Karbala-1 small subunit ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and large subunit ribosomal RNA gene, complete sequence; and external transcribed spacer, partial sequence | blastn | 13703 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Dothideomycetes | Pleosporales | Pleosporaceae | Alternaria | Alternaria alternata | |
| 4989698 | 4989698 | PRJNA657860_P_NODE_544_length_475_cov_2.730594_g488_i0 | PRJNA657860 | 544 | 475 | 2.730594 | 12.9703215 | root | 1 | Root_unresolved | Root_unresolved | 828 | 0 | NTclustered | gi|1535924130|ref|NG_063104.1| | 4931 | g488 | i0 | 98.109 | 107.225263157895 | 476 | 7 | 100 | 2 | 1 | 475 | 1053 | 579 | Saccharomyces bayanus CBS 380 18S rRNA gene, partial sequence; from TYPE material | blastn | 50932 | 828 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces bayanus | |
| 8814369 | 8814369 | PRJNA657860_P_NODE_327_length_629_cov_8.873311_g275_i0 | PRJNA657860 | 327 | 629 | 8.873311 | 55.81312619 | Penicillium | 5073 | Fungi | Fungi | 1134 | 0 | NTclustered | gi|3169896|gb|AF034453.1|AF034453 | 5075 | g275 | i0 | 99.205 | 99.7615262321145 | 629 | 5 | 100 | 0 | 1 | 629 | 514 | 1142 | Penicillium camemberti internal transcribed spacer 1, 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 62750 | 1134 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium camemberti | |
| 12640581 | 12640581 | PRJNA657860_P_NODE_1730_length_239_cov_19.133663_g1674_i0 | PRJNA657860 | 1730 | 239 | 19.133663 | 45.72945457 | Penicillium | 5073 | Fungi | Fungi | 442 | 1.0899999999999994e-119 | NTclustered | gi|2255174501|gb|ON787851.1| | 5075 | g1674 | i0 | 100 | 100 | 239 | 0 | 100 | 0 | 1 | 239 | 82 | 320 | Penicillium camemberti strain KKP 3843 internal transcribed spacer 1, partial sequence; 5.8S ribosomal RNA gene and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 23900 | 442 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Eurotiales | Aspergillaceae | Penicillium | Penicillium camemberti | |
| 14654373 | 14654373 | PRJNA657860_P_NODE_1012_length_330_cov_3.081911_g956_i0 | PRJNA657860 | 1012 | 330 | 3.081911 | 10.1703063 | Exophiala xenobiotica | 348802 | Fungi | Fungi | 483 | 9.3e-132 | NTclustered | gi|915144019|ref|XR_001230708.1| | 348802 | g956 | i0 | 96.875 | 82.730303030303 | 288 | 9 | 87 | 0 | 1 | 288 | 4454 | 4741 | Exophiala xenobiotica 28S ribosomal RNA (PV05_12071), rRNA | blastn | 27301 | 483 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Eurotiomycetes | Chaetothyriales | Herpotrichiellaceae | Exophiala | Exophiala xenobiotica | |
| 15189935 | 15189935 | PRJNA657860_P_NODE_952_length_340_cov_4.141914_g896_i0 | PRJNA657860 | 952 | 340 | 4.141914 | 14.0825076 | root | 1 | Root_unresolved | Root_unresolved | 628 | 1.1699999999999999e-175 | NTclustered | gi|1028223492|dbj|LC094391.1| | 4932 | g896 | i0 | 100 | 107 | 340 | 0 | 100 | 0 | 1 | 340 | 243 | 582 | Saccharomyces cerevisiae gene for 28S rRNA, partial sequence, strain: SN116 | blastn | 36380 | 628 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 19012924 | 19012924 | PRJNA657860_P_NODE_1115_length_315_cov_2.748201_g1059_i0 | PRJNA657860 | 1115 | 315 | 2.748201 | 8.65683315 | Nakazawaea | 460521 | Fungi | Fungi | 582 | 8.459999999999998e-162 | NTclustered | gi|194578726|dbj|AB449811.1| | 36025 | g1059 | i0 | 100 | 99.6063492063492 | 315 | 0 | 100 | 0 | 1 | 315 | 1231 | 1545 | Nakazawaea holstii genes for SSU rRNA, ITS1, 5.8S rRNA, ITS2, LSU rRNA, partial and complete sequence, strain: IFM 56845 | blastn | 31376 | 582 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Pichiomycetes | Alaninales | Pachysolenaceae | Nakazawaea | Nakazawaea holstii | |
| 21563356 | 21563356 | PRJNA657860_P_NODE_1237_length_297_cov_8.134615_g1181_i0 | PRJNA657860 | 1237 | 297 | 8.134615 | 24.15980655 | root | 1 | Root_unresolved | Root_unresolved | 549 | 8.029999999999997e-152 | NTclustered | gi|1102645715|gb|KY109285.1| | 4932 | g1181 | i0 | 100 | 108 | 297 | 0 | 100 | 0 | 1 | 297 | 341 | 45 | Saccharomyces cerevisiae culture CBS:459 large subunit ribosomal RNA gene, partial sequence | blastn | 32076 | 549 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 22838801 | 22838801 | PRJNA657860_P_NODE_1198_length_302_cov_3.558491_g1142_i0 | PRJNA657860 | 1198 | 302 | 3.558491 | 10.74664282 | root | 1 | Root_unresolved | Root_unresolved | 501 | 2.32e-137 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g1142 | i0 | 99.278 | 104.394039735099 | 277 | 2 | 92 | 0 | 26 | 302 | 3881498 | 3881774 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 31527 | 501 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae | |
| 22838809 | 22838809 | PRJNA657860_P_NODE_818_length_365_cov_5.945122_g762_i0 | PRJNA657860 | 818 | 365 | 5.945122 | 21.6996953 | root | 1 | Root_unresolved | Root_unresolved | 675 | 0 | NTclustered | gi|1389182097|gb|CP029160.1| | 4932 | g762 | i0 | 100 | 116.495890410959 | 365 | 0 | 100 | 0 | 1 | 365 | 3880704 | 3880340 | Saccharomyces cerevisiae strain SY14 chromosome I, complete sequence | blastn | 42521 | 675 | 1 | Eukaryota | Opisthokonta | Fungi | Ascomycota | Saccharomycetes | Saccharomycetales | Saccharomycetaceae | Saccharomyces | Saccharomyces cerevisiae |
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);;