contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA846110" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 833089 | 833089 | PRJNA846110_P_NODE_23861_length_249_cov_1.556818_g23616_i0 | PRJNA846110 | 23861 | 249 | 1.556818 | 3.87647682 | Malassezia globosa | 76773 | Fungi | Fungi | 427 | 3.2e-115 | NTclustered | gi|164658040|ref|XM_001730094.1| | 425265 | g23616 | i0 | 97.59 | 1 | 249 | 6 | 100 | 0 | 1 | 249 | 462 | 710 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_2528), partial mRNA | blastn | 249 | 427 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 833110 | 833110 | PRJNA846110_P_NODE_25801_length_247_cov_0.885057_g25556_i0 | PRJNA846110 | 25801 | 247 | 0.885057 | 2.18609079 | Malassezia globosa | 76773 | Fungi | Fungi | 457 | 4.05e-124 | NTclustered | gi|1805972860|gb|CP046440.1| | 76773 | g25556 | i0 | 100 | 8.06477732793522 | 247 | 0 | 100 | 0 | 1 | 247 | 19560 | 19314 | Malassezia globosa strain CBS7966 mitochondrion, complete genome | blastn | 1992 | 457 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 5936310 | 5936310 | PRJNA846110_P_NODE_29425_length_242_cov_0.911243_g29180_i0 | PRJNA846110 | 29425 | 242 | 0.911243 | 2.20520806 | Russula emetica | 152958 | Fungi | Fungi | 139 | 1.63e-28 | NTclustered | gi|2732054597|ref|NC_088766.1| | 152958 | g29180 | i0 | 86.047 | 19.404958677686 | 129 | 18 | 53 | 0 | 1 | 129 | 16682 | 16810 | Russula emetica strain 2018DUKE113 mitochondrion, complete genome | blastn | 4696 | 139 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Russulaceae | Russula | Russula emetica | |
| 9760986 | 9760986 | PRJNA846110_P_NODE_12388_length_310_cov_2.286920_g12143_i0 | PRJNA846110 | 12388 | 310 | 2.28692 | 7.089452 | Malassezia restricta | 76775 | Fungi | Fungi | 573 | 4.999999999999998e-159 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g12143 | i0 | 100 | 76.941935483871 | 310 | 0 | 100 | 0 | 1 | 310 | 2978 | 3287 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 23852 | 573 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 9761165 | 9761165 | PRJNA846110_P_NODE_28608_length_243_cov_0.905882_g28363_i0 | PRJNA846110 | 28608 | 243 | 0.905882 | 2.20129326 | Malassezia restricta | 76775 | Fungi | Fungi | 449 | 6.65e-122 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g28363 | i0 | 100 | 101.041152263374 | 243 | 0 | 100 | 0 | 1 | 243 | 1673 | 1915 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 24553 | 449 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 14861055 | 14861055 | PRJNA846110_P_NODE_29552_length_242_cov_0.911243_g29307_i0 | PRJNA846110 | 29552 | 242 | 0.911243 | 2.20520806 | Malassezia globosa | 76773 | Fungi | Fungi | 414 | 2.41e-111 | NTclustered | gi|164655424|ref|XM_001728790.1| | 425265 | g29307 | i0 | 97.521 | 1 | 242 | 6 | 100 | 0 | 1 | 242 | 664 | 423 | Malassezia globosa CBS 7966 uncharacterized protein (MGL_4009), partial mRNA | blastn | 242 | 414 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia globosa | |
| 16135843 | 16135843 | PRJNA846110_P_NODE_30253_length_241_cov_0.916667_g30008_i0 | PRJNA846110 | 30253 | 241 | 0.916667 | 2.20916747 | Malassezia restricta | 76775 | Fungi | Fungi | 446 | 8.519999999999999e-121 | NTclustered | gi|1546638707|ref|XM_027630995.1| | 76775 | g30008 | i0 | 100 | 1 | 241 | 0 | 100 | 0 | 1 | 241 | 1350 | 1590 | Malassezia restricta kinetochore protein NDC80 (MRET_4368), partial mRNA | blastn | 241 | 446 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 18684424 | 18684424 | PRJNA846110_P_NODE_30115_length_241_cov_0.916667_g29870_i0 | PRJNA846110 | 30115 | 241 | 0.916667 | 2.20916747 | Malassezia restricta | 76775 | Fungi | Fungi | 444 | 3.06e-120 | NTclustered | gi|1546634486|ref|XM_027628903.1| | 76775 | g29870 | i0 | 100 | 0.995850622406639 | 240 | 0 | 99 | 0 | 1 | 240 | 1224 | 985 | Malassezia restricta viral A-type inclusion protein repeat protein (MRET_2276), partial mRNA | blastn | 240 | 444 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 23785357 | 23785357 | PRJNA846110_P_NODE_23619_length_250_cov_0.870056_g23374_i0 | PRJNA846110 | 23619 | 250 | 0.870056 | 2.17514 | Sterigmatomyces sp. | 1972484 | Fungi | Fungi | 219 | 2.11e-52 | NTclustered | gi|1894457345|gb|MT755636.1| | 1972484 | g23374 | i0 | 83.682 | 0.956 | 239 | 32 | 94 | 5 | 16 | 250 | 15190 | 15425 | Sterigmatomyces sp. mitochondrion, complete genome | blastn | 239 | 219 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricostilbomycetes | Agaricostilbales | Agaricostilbaceae | Sterigmatomyces | Sterigmatomyces sp. | |
| 24182971 | 24182971 | PRJNA846110_P_NODE_7119_length_392_cov_2.504702_g6875_i0 | PRJNA846110 | 7119 | 392 | 2.504702 | 9.81843184 | Opisthokonta | 33154 | Fungi | Fungi | 713 | 0 | NTclustered | gi|126508724|gb|EF397600.1| | 81056 | g6875 | i0 | 99.49 | 106.93112244898 | 392 | 2 | 100 | 0 | 1 | 392 | 1524 | 1915 | Poria cocos strain KANP No. 7233 28S ribosomal RNA gene, partial sequence | blastn | 41917 | 719 | 0.991655076495132 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Polyporales | Phaeolaceae | Wolfiporia | Wolfiporia cocos |
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);;