contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA556992" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3080724 | 3080724 | PRJNA556992_P_NODE_522603_length_265_cov_2.385417_g520414_i0 | PRJNA556992 | 522603 | 265 | 2.385417 | 6.32135505 | Blastocladiella sp. | 2169676 | Fungi | Fungi | 252 | 2.22e-62 | NTclustered | gi|1976519919|gb|MN873040.1| | 2169676 | g520414 | i0 | 85.306 | 25.1962264150943 | 245 | 35 | 92 | 1 | 3 | 246 | 29587 | 29831 | Blastocladiella sp. mitochondrion, complete genome | blastn | 6677 | 252 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella sp. | |
| 13278603 | 13278603 | PRJNA556992_P_NODE_152911_length_356_cov_2.469965_g150723_i0 | PRJNA556992 | 152911 | 356 | 2.469965 | 8.7930754 | Catenaria sp. | 2420186 | Fungi | Fungi | 632 | 9.46e-177 | NTclustered | gi|1866582684|gb|MT730859.1| | 2420186 | g150723 | i0 | 99.425 | 72.6657303370787 | 348 | 2 | 98 | 0 | 1 | 348 | 2839 | 2492 | Catenaria sp. isolate JEL0871 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 25869 | 632 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria sp. | |
| 14564637 | 14564637 | PRJNA556992_P_NODE_999072_length_230_cov_5.566879_g996882_i0 | PRJNA556992 | 999072 | 230 | 5.566879 | 12.8038217 | Blastocladiella sp. | 2169676 | Fungi | Fungi | 224 | 4.11e-54 | NTclustered | gi|1976519919|gb|MN873040.1| | 2169676 | g996882 | i0 | 84.513 | 0.982608695652174 | 226 | 35 | 98 | 0 | 1 | 226 | 6219 | 5994 | Blastocladiella sp. mitochondrion, complete genome | blastn | 226 | 224 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella sp. | |
| 23479870 | 23479870 | PRJNA556992_P_NODE_343359_length_283_cov_1.395238_g341170_i0 | PRJNA556992 | 343359 | 283 | 1.395238 | 3.94852354 | Allomyces macrogynus | 28583 | Fungi | Fungi | 80.5 | 1.2e-10 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g341170 | i0 | 78.74 | 0.448763250883392 | 127 | 22 | 44 | 5 | 159 | 283 | 40459 | 40336 | Allomyces macrogynus mitochondrion, complete genome | blastn | 127 | 80.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 24078837 | 24078837 | PRJNA556992_P_NODE_62559_length_472_cov_2.160401_g60387_i0 | PRJNA556992 | 62559 | 472 | 2.160401 | 10.19709272 | Catenariaceae | 109872 | Fungi | Fungi | 582 | 1.3199999999999999e-161 | NTclustered | gi|1866582512|gb|MT730687.1| | 109876 | g60387 | i0 | 99.074 | 59.7224576271186 | 324 | 3 | 69 | 0 | 149 | 472 | 4603 | 4280 | Catenaria anguillulae isolate JEL0194 small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 28189 | 582 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae |
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);;