contig_metadata
15 rows where analysis = "diamond", bioproject = "PRJNA385073" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 9334158 | 9334158 | PRJNA385073_P_NODE_40988_length_251_cov_2.887640_g40826_i0 | PRJNA385073 | 40988 | 251 | 2.88764 | 7.2479764 | Basidiomycota | 5204 | Fungi | Fungi | 165 | 7.75e-48 | NR | KAG0654531.1 | 5537 | g40826 | i0 | 95.2 | 14.8804780876494 | 83 | 4 | 99.2 | 0 | 251 | 3 | 233 | 315 | KAG0654531.1 NAD-dependent isocitrate dehydrogenase [Rhodotorula mucilaginosa] | diamond | 3735 | 166 | 0.993975903614458 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 11885238 | 11885238 | PRJNA385073_P_NODE_62630_length_227_cov_2.558442_g62468_i0 | PRJNA385073 | 62630 | 227 | 2.558442 | 5.80766334 | Rhodotorula mucilaginosa | 5537 | Fungi | Fungi | 172 | 8.46e-51 | NR | KAG0656993.1 | 5537 | g62468 | i0 | 100 | 4.95594713656388 | 75 | 0 | 99.1 | 0 | 227 | 3 | 94 | 168 | KAG0656993.1 glutamate--ammonia ligase [Rhodotorula mucilaginosa] | diamond | 1125 | 172 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula mucilaginosa | |
| 27137953 | 27137953 | PRJNA385073_P_NODE_47182_length_248_cov_0.880000_g47020_i0 | PRJNA385073 | 47182 | 248 | 0.88 | 2.1824 | Filobasidium floriforme | 5210 | Fungi | Fungi | 131 | 2.12e-35 | NR | XP_046039545.1 | 5210 | g47020 | i0 | 78 | 0.991935483870968 | 82 | 18 | 99.2 | 0 | 3 | 248 | 91 | 172 | XP_046039545.1 vacuole protein [Filobasidium floriforme] | diamond | 246 | 131 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 27644108 | 27644108 | PRJNA385073_P_NODE_61804_length_230_cov_3.420382_g61642_i0 | PRJNA385073 | 61804 | 230 | 3.420382 | 7.8668786 | Filobasidium floriforme | 5210 | Fungi | Fungi | 42.7 | 0.0325 | NR | XP_046033875.1 | 5210 | g61642 | i0 | 33.3 | 0.939130434782609 | 72 | 42 | 93.9 | 2 | 7 | 222 | 1091 | 1156 | XP_046033875.1 uncharacterized protein HD553DRAFT_120427 [Filobasidium floriforme] | diamond | 216 | 42.7 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Filobasidium | Filobasidium floriforme | |
| 28211948 | 28211948 | PRJNA385073_P_NODE_43326_length_250_cov_0.870056_g43164_i0 | PRJNA385073 | 43326 | 250 | 0.870056 | 2.17514 | Lentinula edodes | 5353 | Fungi | Fungi | 132 | 2.4999999999999996e-38 | NR | GAW07242.1 | 5353 | g43164 | i0 | 100 | 0.756 | 63 | 0 | 75.6 | 0 | 250 | 62 | 6 | 68 | GAW07242.1 hypothetical protein LENED_009219 [Lentinula edodes] | diamond | 189 | 132 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 28370001 | 28370001 | PRJNA385073_P_NODE_36426_length_262_cov_1.613757_g36264_i0 | PRJNA385073 | 36426 | 262 | 1.613757 | 4.22804334 | Meira miltonrushii | 1280837 | Fungi | Fungi | 133 | 7.83e-34 | NR | XP_025353178.1 | 1280837 | g36264 | i0 | 87.5 | 0.916030534351145 | 80 | 10 | 91.6 | 0 | 1 | 240 | 1153 | 1232 | XP_025353178.1 P-loop containing nucleoside triphosphate hydrolase protein [Meira miltonrushii] | diamond | 240 | 133 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Exobasidiomycetes | Exobasidiales | Brachybasidiaceae | Meira | Meira miltonrushii | |
| 28622822 | 28622822 | PRJNA385073_P_NODE_55087_length_243_cov_0.905882_g54925_i0 | PRJNA385073 | 55087 | 243 | 0.905882 | 2.20129326 | Rhodotorula pacifica | 1495444 | Fungi | Fungi | 43.9 | 0.0149 | NR | GAA5986475.1 | 1495444 | g54925 | i0 | 50 | 0.518518518518518 | 42 | 21 | 51.9 | 0 | 167 | 42 | 682 | 723 | GAA5986475.1 hypothetical protein JCM10908_003767 [Rhodotorula pacifica] | diamond | 126 | 43.9 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Microbotryomycetes | Sporidiobolales | Sporidiobolaceae | Rhodotorula | Rhodotorula pacifica | |
| 28843524 | 28843524 | PRJNA385073_P_NODE_62308_length_228_cov_3.200000_g62146_i0 | PRJNA385073 | 62308 | 228 | 3.2 | 7.296 | Lentinula lateritia | 40482 | Fungi | Fungi | 90.1 | 8.63e-22 | NR | KAJ4501826.1 | 40482 | g62146 | i0 | 92.5 | 0.697368421052632 | 53 | 2 | 67.1 | 1 | 76 | 228 | 1 | 53 | KAJ4501826.1 hypothetical protein C8R41DRAFT_805992 [Lentinula lateritia] | diamond | 159 | 90.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula lateritia | |
| 29822259 | 29822259 | PRJNA385073_P_NODE_65091_length_201_cov_4.718750_g64929_i0 | PRJNA385073 | 65091 | 201 | 4.71875 | 9.4846875 | Malassezia restricta | 76775 | Fungi | Fungi | 70.1 | 4.61e-12 | NR | XP_027486068.1 | 76775 | g64929 | i0 | 85.4 | 0.611940298507463 | 41 | 5 | 59.7 | 1 | 124 | 5 | 1 | 41 | XP_027486068.1 splicing factor U2AF 65 kDa subunit [Malassezia restricta] | diamond | 123 | 70.1 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia restricta | |
| 30770456 | 30770456 | PRJNA385073_P_NODE_54654_length_243_cov_1.664706_g54492_i0 | PRJNA385073 | 54654 | 243 | 1.664706 | 4.04523558 | Naganishia liquefaciens | 104408 | Fungi | Fungi | 63.2 | 2.36e-9 | NR | GHJ84498.1 | 104408 | g54492 | i0 | 92.1 | 0.469135802469136 | 38 | 3 | 46.9 | 0 | 2 | 115 | 1017 | 1054 | GHJ84498.1 hypothetical protein NliqN6_0900 [Naganishia liquefaciens] | diamond | 114 | 63.2 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Tremellomycetes | Filobasidiales | Filobasidiaceae | Naganishia | Naganishia liquefaciens | |
| 31008365 | 31008365 | PRJNA385073_P_NODE_48394_length_247_cov_0.885057_g48232_i0 | PRJNA385073 | 48394 | 247 | 0.885057 | 2.18609079 | Puccinia | 5296 | Fungi | Fungi | 133 | 1.48e-34 | NR | KAA1088390.1 | 56615 | g48232 | i0 | 81.7 | 3.98380566801619 | 82 | 14 | 98.4 | 1 | 1 | 243 | 162 | 243 | KAA1088390.1 hypothetical protein PGTUg99_023177 [Puccinia graminis f. sp. tritici] | diamond | 984 | 134 | 0.992537313432836 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia graminis | |
| 31197497 | 31197497 | PRJNA385073_P_NODE_43875_length_250_cov_0.870056_g43713_i0 | PRJNA385073 | 43875 | 250 | 0.870056 | 2.17514 | Puccinia | 5296 | Fungi | Fungi | 110 | 1.93e-27 | NR | KNZ45394.1 | 27349 | g43713 | i0 | 67.5 | 3 | 80 | 24 | 93.6 | 1 | 1 | 234 | 10 | 89 | KNZ45394.1 hypothetical protein VP01_816g3 [Puccinia sorghi] | diamond | 750 | 110 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Pucciniomycetes | Pucciniales | Pucciniaceae | Puccinia | Puccinia sorghi | |
| 31244201 | 31244201 | PRJNA385073_P_NODE_39195_length_255_cov_3.582418_g39033_i0 | PRJNA385073 | 39195 | 255 | 3.582418 | 9.1351659 | Lentinula edodes | 5353 | Fungi | Fungi | 166 | 1.04e-45 | NR | KAF8825429.1 | 5353 | g39033 | i0 | 100 | 1.97647058823529 | 84 | 0 | 98.8 | 0 | 4 | 255 | 18 | 101 | KAF8825429.1 hypothetical protein HHX47_DHR7000179 [Lentinula edodes] | diamond | 504 | 166 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Omphalotaceae | Lentinula | Lentinula edodes | |
| 32698758 | 32698758 | PRJNA385073_P_NODE_32260_length_272_cov_3.929648_g32098_i0 | PRJNA385073 | 32260 | 272 | 3.929648 | 10.68864256 | Cyclocybe aegerita | 1973307 | Fungi | Fungi | 62.4 | 6.51e-9 | NR | CAA7260534.1 | 1973307 | g32098 | i0 | 35.6 | 4.67647058823529 | 90 | 58 | 99.3 | 0 | 271 | 2 | 607 | 696 | CAA7260534.1 unnamed protein product [Cyclocybe aegerita] | diamond | 1272 | 62.4 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Agaricomycetes | Agaricales | Bolbitiaceae | Cyclocybe | Cyclocybe aegerita | |
| 32856239 | 32856239 | PRJNA385073_P_NODE_61820_length_230_cov_3.273885_g61658_i0 | PRJNA385073 | 61820 | 230 | 3.273885 | 7.5299355 | Malassezia cuniculi | 948313 | Fungi | Fungi | 116 | 4.28e-28 | NR | WFD35275.1 | 948313 | g61658 | i0 | 80.3 | 0.991304347826087 | 76 | 15 | 99.1 | 0 | 229 | 2 | 279 | 354 | WFD35275.1 [NU+] prion formation protein 1 [Malassezia cuniculi] | diamond | 228 | 116 | 1 | Eukaryota | Opisthokonta | Fungi | Basidiomycota | Malasseziomycetes | Malasseziales | Malasseziaceae | Malassezia | Malassezia cuniculi |
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);;