contig_metadata
6 rows where bioproject = "PRJNA670521", tax_kingdom = "Fungi" and tax_phylum = "Blastocladiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 7016771 | 7016771 | PRJNA670521_P_NODE_55266_length_283_cov_2.000000_g54521_i0 | PRJNA670521 | 55266 | 283 | 2 | 5.66 | Opisthokonta | 33154 | Fungi | Fungi | 140 | 1.83e-39 | NR | KAJ3366916.1 | 64504 | g54521 | i0 | 76.1 | 15.3922261484099 | 92 | 22 | 97.5 | 0 | 2 | 277 | 71 | 162 | KAJ3366916.1 40S ribosomal protein S6 [Allomyces arbusculus] | diamond | 4356 | 140 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 18490492 | 18490492 | PRJNA670521_P_NODE_18675_length_434_cov_0.756233_g17933_i0 | PRJNA670521 | 18675 | 434 | 0.756233 | 3.28205122 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 107 | 6.62e-24 | NR | KAI9139440.1 | 1500003 | g17933 | i0 | 40 | 1.7073732718894 | 140 | 77 | 93.3 | 2 | 20 | 424 | 18 | 155 | KAI9139440.1 cytochrome P450 [Paraphysoderma sedebokerense] | diamond | 741 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 25391429 | 25391429 | PRJNA670521_P_NODE_90740_length_242_cov_0.911243_g89995_i0 | PRJNA670521 | 90740 | 242 | 0.911243 | 2.20520806 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 121 | 8.900000000000001e-30 | NR | KAJ1506947.1 | 945690 | g89995 | i0 | 73.4 | 62.9876033057851 | 79 | 21 | 97.9 | 0 | 240 | 4 | 337 | 415 | KAJ1506947.1 2-oxoglutarate dehydrogenase E1 component [Coelomomyces lativittatus] | diamond | 15243 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 26808928 | 26808928 | PRJNA670521_P_NODE_23641_length_394_cov_1.635514_g22897_i0 | PRJNA670521 | 23641 | 394 | 1.635514 | 6.44392516 | Blastocladiomycota | 451459 | Fungi | Fungi | 108 | 6.440000000000001e-27 | NR | ORZ34595.1 | 765915 | g22897 | i0 | 51.7 | 5.25380710659898 | 116 | 50 | 84.5 | 2 | 337 | 5 | 15 | 129 | ORZ34595.1 F1 complex, delta/epsilon subunit of ATPase [Catenaria anguillulae PL171] | diamond | 2070 | 108 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 31516060 | 31516060 | PRJNA670521_P_NODE_51516_length_292_cov_1.406393_g50771_i0 | PRJNA670521 | 51516 | 292 | 1.406393 | 4.10666756 | Fungi | 4751 | Fungi | Fungi | 57.8 | 3.48e-7 | NR | KNE62614.1 | 578462 | g50771 | i0 | 29.8 | 10.1815068493151 | 104 | 64 | 97.6 | 2 | 287 | 3 | 1003 | 1106 | KNE62614.1 hypothetical protein AMAG_07816 [Allomyces macrogynus ATCC 38327] | diamond | 2973 | 58.2 | 0.993127147766323 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 32295098 | 32295098 | PRJNA670521_P_NODE_78939_length_247_cov_0.885057_g78194_i0 | PRJNA670521 | 78939 | 247 | 0.885057 | 2.18609079 | Blastocladiella britannica | 64508 | Fungi | Fungi | 47 | 0.00127 | NR | KAI9219220.1 | 64508 | g78194 | i0 | 36.1 | 1.0080971659919 | 83 | 51 | 99.6 | 2 | 247 | 2 | 373 | 454 | KAI9219220.1 hypothetical protein BC828DRAFT_368486 [Blastocladiella britannica] | diamond | 249 | 47 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica |
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);;