contig_metadata
11 rows where bioproject = "PRJNA1073005", tax_phylum = "Basidiomycota" and tax_superkingdom = "Eukaryota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6564956 | 6564956 | PRJNA1073005_P_NODE_9826_length_245_cov_0.895349_g9707_i0 | PRJNA1073005 | 9826 | 245 | 0.895349 | 2.19360505 | Malassezia restricta | 76775 | Fungi | Fungi | 409 | 1.1399999999999998e-109 | NTclustered | gi|1546637127|ref|XM_027630206.1| | 76775 | g9707 | i0 | 96.735 | 1 | 245 | 8 | 100 | 0 | 1 | 245 | 5365 | 5121 | Malassezia restricta negative regulation of cAMP metabolic process (MRET_3579), partial mRNA | blastn | 245 | 409 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 8669186 | 8669186 | PRJNA1073005_P_NODE_6947_length_326_cov_1.217391_g6828_i0 | PRJNA1073005 | 6947 | 326 | 1.217391 | 3.96869466 | Flammulina | 38944 | Fungi | Fungi | 603 | 6.749999999999998e-168 | NTclustered | gi|1487130313|gb|MH468771.1| | 38945 | g6828 | i0 | 100 | 100.01226993865 | 326 | 0 | 100 | 0 | 1 | 326 | 2836 | 3161 | Flammulina velutipes strain strain NJ6-3 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, 28S ribosomal RNA gene, intergenic spacer 1, 5S ribosomal RNA gene, and intergenic spacer 2, complete sequence | blastn | 32604 | 603 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Physalacriaceae | Flammulina | Flammulina velutipes | |
| 10390281 | 10390281 | PRJNA1073005_P_NODE_8869_length_253_cov_1.255556_g8750_i0 | PRJNA1073005 | 8869 | 253 | 1.255556 | 3.17655668 | Agaricomycetes | 155619 | Fungi | Fungi | 131 | 1.35e-36 | NR | KAI0313781.1 | 55340 | g8750 | i0 | 85.7 | 3.98418972332016 | 84 | 10 | 99.6 | 1 | 253 | 2 | 46 | 127 | KAI0313781.1 histone-fold-containing protein [Amylostereum chailletii] | diamond | 1008 | 132 | 0.992424242424242 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Russulales | Stereaceae | Amylostereum | Amylostereum chailletii | |
| 13769338 | 13769338 | PRJNA1073005_P_NODE_8531_length_264_cov_2.136126_g8412_i0 | PRJNA1073005 | 8531 | 264 | 2.136126 | 5.63937264 | Ustilaginaceae | 5268 | Fungi | Fungi | 483 | 7.219999999999998e-132 | NTclustered | gi|1358186638|gb|MH047195.1| | 5270 | g8412 | i0 | 99.621 | 24.6742424242424 | 264 | 1 | 100 | 0 | 1 | 264 | 4740 | 4477 | Mycosarcoma maydis 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 6514 | 483 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Ustilaginomycetes | Ustilaginales | Ustilaginaceae | Mycosarcoma | Mycosarcoma maydis | |
| 16763892 | 16763892 | PRJNA1073005_P_NODE_4514_length_462_cov_1.434447_g4395_i0 | PRJNA1073005 | 4514 | 462 | 1.434447 | 6.62714514 | Leucosporidium scottii | 5278 | Fungi | Fungi | 793 | 0 | NTclustered | gi|1358186634|gb|MH047191.1| | 5278 | g4395 | i0 | 97.619 | 104.813852813853 | 462 | 11 | 100 | 0 | 1 | 462 | 4240 | 3779 | Leucosporidium scottii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 48424 | 793 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Leucosporidiales | Leucosporidiaceae | Leucosporidium | Leucosporidium scottii | |
| 19312666 | 19312666 | PRJNA1073005_P_NODE_8336_length_271_cov_1.555556_g8217_i0 | PRJNA1073005 | 8336 | 271 | 1.555556 | 4.21555676 | Malassezia restricta | 76775 | Fungi | Fungi | 501 | 2.05e-137 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g8217 | i0 | 100 | 76.7047970479705 | 271 | 0 | 100 | 0 | 1 | 271 | 3007 | 3277 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 20787 | 501 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 21863832 | 21863832 | PRJNA1073005_P_NODE_5918_length_375_cov_0.950331_g5799_i0 | PRJNA1073005 | 5918 | 375 | 0.950331 | 3.56374125 | Malassezia restricta | 76775 | Fungi | Fungi | 688 | 0 | NTclustered | gi|1546635598|ref|XR_003525370.1| | 76775 | g5799 | i0 | 99.733 | 99.6586666666667 | 375 | 1 | 100 | 0 | 1 | 375 | 1554 | 1928 | Malassezia restricta 28S ribosomal RNA (MRET_r0004), rRNA | blastn | 37372 | 688 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30785590 | 30785590 | PRJNA1073005_P_NODE_6414_length_351_cov_1.107914_g6295_i0 | PRJNA1073005 | 6414 | 351 | 1.107914 | 3.88877814 | Tulasnella | 5240 | Fungi | Fungi | 191 | 2.13e-59 | NR | KAG8864261.1 | 2600220 | g6295 | i0 | 77.8 | 9.98290598290598 | 117 | 26 | 100 | 0 | 1 | 351 | 28 | 144 | KAG8864261.1 60S ribosomal protein L15 [Tulasnella sp. 330] | diamond | 3504 | 192 | 0.994791666666667 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Tulasnellaceae | Tulasnella | Tulasnella sp. 330 | |
| 31900685 | 31900685 | PRJNA1073005_P_NODE_7937_length_285_cov_1.287736_g7818_i0 | PRJNA1073005 | 7937 | 285 | 1.287736 | 3.6700476 | Thelephora terrestris | 56493 | Fungi | Fungi | 49.7 | 2.23e-4 | NR | KAF9785898.1 | 56493 | g7818 | i0 | 59.4 | 0.631578947368421 | 32 | 13 | 33.7 | 0 | 281 | 186 | 627 | 658 | KAF9785898.1 Metallo-peptidase family M12-domain-containing protein [Thelephora terrestris] | diamond | 180 | 49.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Thelephorales | Thelephoraceae | Thelephora | Thelephora terrestris | |
| 31986982 | 31986982 | PRJNA1073005_P_NODE_7938_length_285_cov_1.283019_g7819_i0 | PRJNA1073005 | 7938 | 285 | 1.283019 | 3.65660415 | Mycenaceae | 2024004 | Fungi | Fungi | 79.3 | 1.62e-15 | NR | GAT51362.1 | 658473 | g7819 | i0 | 40.5 | 6.18947368421053 | 84 | 50 | 88.4 | 0 | 5 | 256 | 100 | 183 | GAT51362.1 tubulin beta chain [Mycena chlorophos] | diamond | 1764 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Mycenaceae | Mycena | Mycena chlorophos | |
| 32714075 | 32714075 | PRJNA1073005_P_NODE_9180_length_249_cov_1.721591_g9061_i0 | PRJNA1073005 | 9180 | 249 | 1.721591 | 4.28676159 | Ceratobasidiaceae | 5250 | Fungi | Fungi | 115 | 2.08e-28 | NR | ELU41693.1 | 983506 | g9061 | i0 | 66.3 | 9 | 83 | 28 | 100 | 0 | 249 | 1 | 86 | 168 | ELU41693.1 60S ribosomal protein L3 [Rhizoctonia solani AG-1 IA] | diamond | 2241 | 115 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Cantharellales | Ceratobasidiaceae | Rhizoctonia | Rhizoctonia solani |
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);;