contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA493828" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 474458 | 474458 | PRJNA493828_P_NODE_10601_length_352_cov_1.956989_g10182_i0 | PRJNA493828 | 10601 | 352 | 1.956989 | 6.88860128 | Blastocladiella sp. | 2169676 | Fungi | Fungi | 150 | 1.15e-31 | NTclustered | gi|1976519919|gb|MN873040.1| | 2169676 | g10182 | i0 | 94.845 | 0.826704545454545 | 97 | 3 | 28 | 2 | 208 | 304 | 22832 | 22738 | Blastocladiella sp. mitochondrion, complete genome | blastn | 291 | 150 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella sp. | |
| 474954 | 474954 | PRJNA493828_P_NODE_42681_length_231_cov_2.291139_g42262_i0 | PRJNA493828 | 42681 | 231 | 2.291139 | 5.29253109 | Catenophlyctis variabilis | 945688 | Fungi | Fungi | 427 | 2.9399999999999998e-115 | NTclustered | gi|82398236|gb|DQ273780.1| | 945688 | g42262 | i0 | 100 | 70.9134199134199 | 231 | 0 | 100 | 0 | 1 | 231 | 2778 | 2548 | Catenophlyctis sp. JEL298 isolate AFTOL-ID 36 28S ribosomal RNA gene, partial sequence | blastn | 16381 | 427 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenophlyctis | Catenophlyctis variabilis | |
| 3025430 | 3025430 | PRJNA493828_P_NODE_18443_length_294_cov_1.199095_g18024_i0 | PRJNA493828 | 18443 | 294 | 1.199095 | 3.5253393 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 211 | 4.25e-50 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g18024 | i0 | 82.079 | 30.078231292517 | 279 | 20 | 86 | 18 | 37 | 290 | 32220 | 32493 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 8843 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 3025968 | 3025968 | PRJNA493828_P_NODE_8743_length_381_cov_3.353896_g8327_i0 | PRJNA493828 | 8743 | 381 | 3.353896 | 12.77834376 | Allomyces macrogynus | 28583 | Fungi | Fungi | 272 | 2.56e-68 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g8327 | i0 | 85.766 | 16.6561679790026 | 274 | 20 | 67 | 7 | 5 | 259 | 39555 | 39828 | Allomyces macrogynus mitochondrion, complete genome | blastn | 6346 | 272 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 3025985 | 3025985 | PRJNA493828_P_NODE_9823_length_363_cov_3.334483_g9405_i0 | PRJNA493828 | 9823 | 363 | 3.334483 | 12.10417329 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 209 | 1.93e-49 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g9405 | i0 | 95.455 | 34.3939393939394 | 132 | 5 | 36 | 1 | 233 | 363 | 14516 | 14385 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 12485 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 4301532 | 4301532 | PRJNA493828_P_NODE_244_length_1864_cov_101.222222_g149_i0 | PRJNA493828 | 244 | 1864 | 101.222222 | 1886.78221808 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 226 | 1.0699999999999999e-53 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g149 | i0 | 77.665 | 9.17221030042919 | 394 | 72 | 21 | 14 | 1481 | 1864 | 2090 | 2477 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 17097 | 226 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 5578368 | 5578368 | PRJNA493828_P_NODE_34845_length_247_cov_1.655172_g34426_i0 | PRJNA493828 | 34845 | 247 | 1.655172 | 4.08827484 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 311 | 3.34e-80 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g34426 | i0 | 89.516 | 83.4534412955466 | 248 | 23 | 100 | 3 | 1 | 247 | 901 | 1146 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 20613 | 311 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 7484686 | 7484686 | PRJNA493828_P_NODE_3886_length_548_cov_63.094737_g3508_i0 | PRJNA493828 | 3886 | 548 | 63.094737 | 345.75915876 | Allomyces | 28581 | Fungi | Fungi | 156 | 3.99e-33 | NTclustered | gi|399207613|gb|JX094785.1| | 28583 | g3508 | i0 | 98.851 | 21.9124087591241 | 87 | 1 | 16 | 0 | 1 | 87 | 287 | 373 | Allomyces macrogynus strain ATCC 38327 28S ribosomal RNA gene, partial sequence | blastn | 12008 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 7484799 | 7484799 | PRJNA493828_P_NODE_6026_length_449_cov_122.515957_g5633_i0 | PRJNA493828 | 6026 | 449 | 122.515957 | 550.09664693 | Fungi | 4751 | Fungi | Fungi | 187 | 1.1399999999999997e-42 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g5633 | i0 | 86.034 | 43.1291759465479 | 179 | 19 | 40 | 2 | 271 | 449 | 3370 | 3198 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 19365 | 187 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 8759677 | 8759677 | PRJNA493828_P_NODE_46687_length_206_cov_7.917293_g46268_i0 | PRJNA493828 | 46687 | 206 | 7.917293 | 16.30962358 | Catenariaceae | 109872 | Fungi | Fungi | 355 | 1.23e-93 | NTclustered | gi|1866582799|gb|MT730974.1| | 2420186 | g46268 | i0 | 100 | 75.8349514563107 | 192 | 0 | 93 | 0 | 12 | 203 | 4381 | 4190 | Catenaria sp. isolate UM1556 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 | 15622 | 355 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria sp. | |
| 13228351 | 13228351 | PRJNA493828_P_NODE_1771_length_802_cov_3.024691_g1459_i0 | PRJNA493828 | 1771 | 802 | 3.024691 | 24.25802182 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 455 | 5.2500000000000005e-123 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g1459 | i0 | 92 | 58.3990024937656 | 325 | 24 | 45 | 2 | 364 | 687 | 34694 | 34371 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 46836 | 455 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 15134867 | 15134867 | PRJNA493828_P_NODE_9132_length_374_cov_130.495017_g8716_i0 | PRJNA493828 | 9132 | 374 | 130.495017 | 488.05136358 | Allomyces | 28581 | Fungi | Fungi | 351 | 3.13e-92 | NTclustered | gi|321173707|gb|HQ888688.1| | 64506 | g8716 | i0 | 84.8 | 98.9946524064171 | 375 | 29 | 100 | 17 | 1 | 374 | 387 | 40 | Allomyces moniliformis strain India 3 18S ribosomal RNA gene, partial sequence | blastn | 37024 | 351 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces moniliformis | |
| 21508378 | 21508378 | PRJNA493828_P_NODE_16857_length_305_cov_1.732759_g16438_i0 | PRJNA493828 | 16857 | 305 | 1.732759 | 5.28491495 | Catenariaceae | 109872 | Fungi | Fungi | 529 | 1.0799999999999996e-145 | NTclustered | gi|225691134|gb|FJ804154.1| | 109876 | g16438 | i0 | 99.655 | 79.7836065573771 | 290 | 0 | 95 | 1 | 14 | 302 | 612 | 323 | Catenaria anguillulae 28S ribosomal RNA gene, partial sequence | blastn | 24334 | 534 | 0.99063670411985 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 22150995 | 22150995 | PRJNA493828_P_NODE_12538_length_328_cov_4.211765_g12119_i0 | PRJNA493828 | 12538 | 328 | 4.211765 | 13.8145892 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 154 | 8.22e-33 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g12119 | i0 | 91.892 | 13.0518292682927 | 111 | 7 | 47 | 2 | 90 | 200 | 33944 | 33836 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 4281 | 154 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 24700505 | 24700505 | PRJNA493828_P_NODE_19320_length_290_cov_1.520737_g18901_i0 | PRJNA493828 | 19320 | 290 | 1.520737 | 4.4101373 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 209 | 1.51e-49 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g18901 | i0 | 99.138 | 28.1724137931034 | 116 | 1 | 60 | 0 | 150 | 265 | 32699 | 32814 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 8170 | 209 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 25333094 | 25333094 | PRJNA493828_P_NODE_7820_length_401_cov_4.420732_g7405_i0 | PRJNA493828 | 7820 | 401 | 4.420732 | 17.72713532 | Catenariaceae | 109872 | Fungi | Fungi | 701 | 0 | NTclustered | gi|1866582512|gb|MT730687.1| | 109876 | g7405 | i0 | 99.481 | 71.4389027431422 | 385 | 2 | 96 | 0 | 4 | 388 | 2501 | 2885 | 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 | 28647 | 706 | 0.992917847025496 | 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);;