contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJEB81327" and tax_phylum = "Mucoromycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 139493 | 139493 | PRJEB81327_P_NODE_10701_length_417_cov_0.979651_g10093_i0 | PRJEB81327 | 10701 | 417 | 0.979651 | 4.08514467 | Gilbertella persicaria | 101096 | Fungi | Fungi | 187 | 1.0499999999999999e-42 | NTclustered | gi|2323717654|ref|XM_051576335.1| | 101096 | g10093 | i0 | 88.05 | 41.0935251798561 | 159 | 17 | 38 | 2 | 234 | 391 | 660 | 503 | Gilbertella persicaria 60S ribosomal protein L2 (B0P05DRAFT_525634), partial mRNA | blastn | 17136 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Choanephoraceae | Gilbertella | Gilbertella persicaria | |
| 1414702 | 1414702 | PRJEB81327_P_NODE_5742_length_602_cov_1.625709_g5160_i0 | PRJEB81327 | 5742 | 602 | 1.625709 | 9.78676818 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 257 | 1.18e-63 | NTclustered | gi|1069961705|ref|XM_018434095.1| | 763407 | g5160 | i0 | 77.934 | 14.0398671096346 | 426 | 85 | 70 | 9 | 10 | 431 | 10 | 430 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein mRNA | blastn | 8452 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 3965770 | 3965770 | PRJEB81327_P_NODE_20064_length_310_cov_1.299578_g19456_i0 | PRJEB81327 | 20064 | 310 | 1.299578 | 4.0286918 | Rhizopus microsporus | 58291 | Fungi | Fungi | 182 | 3.5399999999999987e-41 | NTclustered | gi|1331188077|ref|XM_023606091.1| | 1340429 | g19456 | i0 | 80.672 | 2.65483870967742 | 238 | 42 | 76 | 4 | 68 | 303 | 34 | 269 | Rhizopus microsporus ATCC 52813 putative 60S ribosomal protein L30 (RHIMIDRAFT_196053), partial mRNA | blastn | 823 | 182 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Rhizopodaceae | Rhizopus | Rhizopus microsporus | |
| 7791822 | 7791822 | PRJEB81327_P_NODE_14307_length_356_cov_2.360424_g13699_i0 | PRJEB81327 | 14307 | 356 | 2.360424 | 8.40310944 | Phycomyces blakesleeanus | 4837 | Fungi | Fungi | 128 | 5.44e-25 | NTclustered | gi|1069954644|ref|XM_018439372.1| | 763407 | g13699 | i0 | 83.453 | 3.01966292134831 | 139 | 21 | 39 | 2 | 219 | 356 | 334 | 197 | Phycomyces blakesleeanus NRRL 1555(-) hypothetical protein partial mRNA | blastn | 1075 | 128 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Phycomycetaceae | Phycomyces | Phycomyces blakesleeanus | |
| 7791905 | 7791905 | PRJEB81327_P_NODE_20227_length_309_cov_1.305085_g19619_i0 | PRJEB81327 | 20227 | 309 | 1.305085 | 4.03271265 | Umbelopsis ramanniana | 41833 | Fungi | Fungi | 156 | 2.14e-33 | NTclustered | gi|2323687723|ref|XM_051588795.1| | 1314678 | g19619 | i0 | 80.184 | 2.37540453074434 | 217 | 35 | 69 | 6 | 59 | 271 | 278 | 66 | Umbelopsis ramanniana AG uncharacterized protein (K450DRAFT_239639), mRNA | blastn | 734 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Umbelopsidomycetes | Umbelopsidales | Umbelopsidaceae | Umbelopsis | Umbelopsis ramanniana | |
| 11200198 | 11200198 | PRJEB81327_P_NODE_29909_length_278_cov_2.204878_g29301_i0 | PRJEB81327 | 29909 | 278 | 2.204878 | 6.12956084 | Fungi | 4751 | Fungi | Fungi | 514 | 2.7199999999999996e-141 | NTclustered | gi|1359918610|gb|MH057235.1| | 260090 | g29301 | i0 | 100 | 100.028776978417 | 278 | 0 | 100 | 0 | 1 | 278 | 49 | 326 | Uncultured glomeraceous AM fungus isolate 992 small subunit ribosomal RNA gene, partial sequence | blastn | 27808 | 514 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | uncultured glomeraceous AM fungus | ||
| 12475940 | 12475940 | PRJEB81327_P_NODE_40270_length_261_cov_1.244681_g39662_i0 | PRJEB81327 | 40270 | 261 | 1.244681 | 3.24861741 | Syncephalastrum | 13705 | Fungi | Fungi | 483 | 7.12e-132 | NTclustered | gi|612507360|gb|KJ417523.1| | 13706 | g39662 | i0 | 100 | 97.9195402298851 | 261 | 0 | 100 | 0 | 1 | 261 | 268 | 8 | Syncephalastrum racemosum isolate VPCI 209/P/10 28S ribosomal RNA gene, partial sequence | blastn | 25557 | 483 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Syncephalastraceae | Syncephalastrum | Syncephalastrum racemosum | |
| 15442177 | 15442177 | PRJEB81327_P_NODE_22973_length_292_cov_1.214612_g22365_i0 | PRJEB81327 | 22973 | 292 | 1.214612 | 3.54666704 | Rhizophagus irregularis | 588596 | Fungi | Fungi | 60.2 | 1.62e-4 | NTclustered | gi|1409872934|ref|XM_025326476.1| | 588596 | g22365 | i0 | 94.737 | 0.5 | 38 | 2 | 13 | 0 | 28 | 65 | 554 | 517 | Rhizophagus irregularis uncharacterized protein (OCT59_005792), partial mRNA | blastn | 146 | 60.2 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Glomeromycetes | Glomerales | Glomeraceae | Rhizophagus | Rhizophagus irregularis | |
| 20540741 | 20540741 | PRJEB81327_P_NODE_33637_length_272_cov_1.276382_g33029_i0 | PRJEB81327 | 33637 | 272 | 1.276382 | 3.47175904 | Cokeromyces recurvatus | 90255 | Fungi | Fungi | 231 | 2.99e-56 | NTclustered | gi|2324087489|ref|XM_051530053.1| | 90255 | g33029 | i0 | 84.322 | 41.0330882352941 | 236 | 37 | 87 | 0 | 11 | 246 | 339 | 574 | Cokeromyces recurvatus rab11 protein (BX663DRAFT_527546), mRNA | blastn | 11161 | 231 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Mucoraceae | Cokeromyces | Cokeromyces recurvatus | |
| 22673911 | 22673911 | PRJEB81327_P_NODE_40838_length_260_cov_1.235294_g40230_i0 | PRJEB81327 | 40838 | 260 | 1.235294 | 3.2117644 | Syncephalastrum | 13705 | Fungi | Fungi | 479 | 9.17e-131 | NTclustered | gi|1145589461|gb|KY047156.1| | 101128 | g40230 | i0 | 100 | 94.7923076923077 | 259 | 0 | 99 | 0 | 1 | 259 | 678 | 936 | Syncephalastrum monosporum strain EML-BT5-2 18S ribosomal RNA gene, partial sequence | blastn | 24646 | 479 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Mucoromycetes | Mucorales | Syncephalastraceae | Syncephalastrum | Syncephalastrum monosporum | |
| 24365353 | 24365353 | PRJEB81327_P_NODE_14380_length_355_cov_2.187943_g13772_i0 | PRJEB81327 | 14380 | 355 | 2.187943 | 7.76719765 | Calcarisporiella thermophila | 911321 | Fungi | Fungi | 255 | 2.39e-63 | NTclustered | gi|2837848970|ref|XM_069391389.1| | 911321 | g13772 | i0 | 81.04 | 74.4197183098591 | 327 | 56 | 91 | 6 | 11 | 334 | 139 | 462 | Calcarisporiella thermophila 40S ribosomal protein uS13 (VTP21DRAFT_1315), partial mRNA | blastn | 26419 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Mucoromycota | Calcarisporiellales | Calcarisporiellaceae | Calcarisporiella | Calcarisporiella thermophila |
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);;