contig_metadata
8 rows where bioproject = "PRJNA193544" and tax_phylum = "Basidiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1055265 | 1055265 | PRJNA193544_S_NODE_2581_length_172_cov_2.888112_g2566_i0 | PRJNA193544 | 2581 | 172 | 2.888112 | 4.96755264 | Mrakiaceae | 1851551 | Fungi | Fungi | 309 | 7.75e-80 | NTclustered | gi|506949109|dbj|AB727278.1| | 82525 | g2566 | i0 | 100 | 96.3255813953488 | 167 | 0 | 97 | 0 | 6 | 172 | 532 | 366 | Guehomyces pullulans gene for large subunit ribosomal RNA, partial sequence, strain: RSM26-12 | blastn | 16568 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Cystofilobasidiales | Mrakiaceae | Tausonia | Tausonia pullulans | |
| 2330518 | 2330518 | PRJNA193544_S_NODE_2202_length_183_cov_24870.863636_g2187_i0 | PRJNA193544 | 2202 | 183 | 24870.863636 | 45513.68045388 | Amanita | 41955 | Fungi | Fungi | 122 | 1.1699999999999997e-23 | NTclustered | gi|329131584|gb|HQ539780.1| | 87326 | g2187 | i0 | 81.25 | 19.103825136612 | 160 | 22 | 84 | 7 | 1 | 154 | 672 | 829 | Amanita brunnescens voucher BW_HP12 18S ribosomal RNA gene, partial sequence | blastn | 3496 | 122 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Amanitaceae | Amanita | Amanita brunnescens | |
| 5469259 | 5469259 | PRJNA193544_S_NODE_985_length_252_cov_13.233184_g970_i0 | PRJNA193544 | 985 | 252 | 13.233184 | 33.34762368 | Lactarius leonis | 194901 | Fungi | Fungi | 106 | 1.73e-18 | NTclustered | gi|30840872|gb|AF506411.1| | 194901 | g970 | i0 | 79.739 | 2.46428571428571 | 153 | 26 | 60 | 5 | 22 | 172 | 1656 | 1507 | Lactarius leonis strain SJ91016 5.8S ribosomal RNA gene, partial sequence; internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 621 | 106 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Lactarius | Lactarius leonis | |
| 6743578 | 6743578 | PRJNA193544_S_NODE_3186_length_156_cov_15.480315_g3171_i0 | PRJNA193544 | 3186 | 156 | 15.480315 | 24.1492914 | Cryptococcus neoformans | 5207 | Fungi | Fungi | 93.5 | 7.57e-15 | NTclustered | gi|1031987672|gb|KU310555.1| | 5207 | g3171 | i0 | 93.548 | 0.83974358974359 | 62 | 4 | 40 | 0 | 90 | 151 | 10 | 71 | Cryptococcus neoformans isolate Cgu 1106 28S ribosomal RNA gene, partial sequence | blastn | 131 | 93.5 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Cryptococcaceae | Cryptococcus | Cryptococcus neoformans | |
| 15668701 | 15668701 | PRJNA193544_S_NODE_3273_length_154_cov_14.816000_g3258_i0 | PRJNA193544 | 3273 | 154 | 14.816 | 22.81664 | Peniophora piceae | 55352 | Fungi | Fungi | 113 | 5.72e-21 | NTclustered | gi|480326996|gb|JX507719.1| | 55352 | g3258 | i0 | 80.892 | 53.7467532467532 | 157 | 19 | 99 | 11 | 3 | 154 | 1989 | 1839 | Peniophora piceae isolate 209 large subunit ribosomal RNA gene, partial sequence | blastn | 8277 | 113 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Peniophoraceae | Peniophora | Peniophora piceae | |
| 17632867 | 17632867 | PRJNA193544_S_NODE_2034_length_190_cov_11.124224_g2019_i0 | PRJNA193544 | 2034 | 190 | 11.124224 | 21.1360256 | Puccinia | 5296 | Fungi | Fungi | 62.1 | 2.71e-5 | NTclustered | gi|1804583978|gb|MN746374.1| | 168172 | g2019 | i0 | 82.051 | 1.49473684210526 | 78 | 8 | 38 | 6 | 5 | 77 | 34681 | 34605 | Puccinia striiformis f. sp. tritici strain DK0911 mitochondrion, complete genome | blastn | 284 | 62.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia striiformis | |
| 20767437 | 20767437 | PRJNA193544_S_NODE_357_length_345_cov_14.914557_g342_i0 | PRJNA193544 | 357 | 345 | 14.914557 | 51.45522165 | uncultured Boletaceae | 335445 | Fungi | Fungi | 143 | 1.88e-29 | NTclustered | gi|134021986|gb|EF023336.1| | 335445 | g342 | i0 | 81.977 | 46.8260869565217 | 172 | 27 | 49 | 3 | 174 | 342 | 171 | 1 | Uncultured Boletaceae clone Amb_18S_657 18S ribosomal RNA gene, partial sequence | blastn | 16155 | 143 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Boletales | Boletaceae | uncultured Boletaceae | ||
| 26662126 | 26662126 | PRJNA193544_S_NODE_1141_length_239_cov_5.390476_g1126_i0 | PRJNA193544 | 1141 | 239 | 5.390476 | 12.88323764 | Tremella mesenterica DSM 1558 | 578456 | Fungi | Fungi | 50.4 | 2.5e-5 | NR | EIW67481.1 | 578456 | g1126 | i0 | 63.9 | 0.451882845188285 | 36 | 13 | 45.2 | 0 | 122 | 229 | 125 | 160 | EIW67481.1 hypothetical protein TREMEDRAFT_33574 [Tremella mesenterica DSM 1558] | diamond | 108 | 50.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Tremellales | Tremellaceae | Tremella | Tremella mesenterica |
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);;