contig_metadata
15 rows where bioproject = "PRJNA1126198", tax_clade = "Opisthokonta" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 281941 | 281941 | PRJNA1126198_P_NODE_8921_length_618_cov_2.478899_g8259_i0 | PRJNA1126198 | 8921 | 618 | 2.478899 | 15.31959582 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 459 | 3.0899999999999996e-124 | NTclustered | gi|117422539|gb|EF064246.1| | 4808 | g8259 | i0 | 85.845 | 14.6812297734628 | 438 | 54 | 70 | 7 | 164 | 597 | 1478 | 1045 | Blastocladiella emersonii elongation factor alpha-like protein mRNA, complete cds | blastn | 9073 | 459 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 18133255 | 18133255 | PRJNA1126198_P_NODE_374275_length_251_cov_1.455056_g373554_i0 | PRJNA1126198 | 374275 | 251 | 1.455056 | 3.65219056 | Catenaria spinosa | 945686 | Fungi | Fungi | 359 | 1.2e-94 | NTclustered | gi|321173721|gb|HQ888702.1| | 945686 | g373554 | i0 | 92.248 | 99.1553784860558 | 258 | 12 | 100 | 7 | 1 | 251 | 1658 | 1402 | Catenaria spinosa strain WM100 18S ribosomal RNA gene, partial sequence | blastn | 24888 | 359 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria spinosa | |
| 26690409 | 26690409 | PRJNA1126198_P_NODE_422901_length_246_cov_1.676301_g422180_i0 | PRJNA1126198 | 422901 | 246 | 1.676301 | 4.12370046 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 136 | 5.21e-37 | NR | ORZ40604.1 | 765915 | g422180 | i0 | 100 | 0.926829268292683 | 76 | 0 | 92.7 | 0 | 229 | 2 | 1 | 76 | ORZ40604.1 ZIP zinc transporter-domain-containing protein [Catenaria anguillulae PL171] | diamond | 228 | 136 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 27006840 | 27006840 | PRJNA1126198_P_NODE_124282_length_327_cov_0.964567_g123563_i0 | PRJNA1126198 | 124282 | 327 | 0.964567 | 3.15413409 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 211 | 2.94e-63 | NR | ORZ41007.1 | 765915 | g123563 | i0 | 98.2 | 1 | 109 | 2 | 100 | 0 | 327 | 1 | 44 | 152 | ORZ41007.1 2-isopropylmalate synthase [Catenaria anguillulae PL171] | diamond | 327 | 211 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 27006854 | 27006854 | PRJNA1126198_P_NODE_315462_length_262_cov_1.629630_g314741_i0 | PRJNA1126198 | 315462 | 262 | 1.62963 | 4.2696306 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 156 | 9.6e-46 | NR | ORZ37501.1 | 765915 | g314741 | i0 | 97.4 | 0.881679389312977 | 77 | 2 | 88.2 | 0 | 261 | 31 | 92 | 168 | ORZ37501.1 hypothetical protein BCR44DRAFT_1483975 [Catenaria anguillulae PL171] | diamond | 231 | 156 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 27259987 | 27259987 | PRJNA1126198_P_NODE_142903_length_317_cov_0.868852_g142184_i0 | PRJNA1126198 | 142903 | 317 | 0.868852 | 2.75426084 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 95.5 | 1.49e-20 | NR | ORZ32383.1 | 765915 | g142184 | i0 | 80.4 | 0.870662460567823 | 92 | 17 | 87.1 | 1 | 36 | 311 | 1 | 91 | ORZ32383.1 hypothetical protein BCR44DRAFT_1502065 [Catenaria anguillulae PL171] | diamond | 276 | 95.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 27544269 | 27544269 | PRJNA1126198_P_NODE_344224_length_256_cov_1.448087_g343503_i0 | PRJNA1126198 | 344224 | 256 | 1.448087 | 3.70710272 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 70.5 | 7.57e-12 | NR | ORZ38742.1 | 765915 | g343503 | i0 | 97 | 0.38671875 | 33 | 1 | 38.7 | 0 | 157 | 255 | 479 | 511 | ORZ38742.1 hypothetical protein BCR44DRAFT_60665 [Catenaria anguillulae PL171] | diamond | 99 | 70.5 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 27639127 | 27639127 | PRJNA1126198_P_NODE_231824_length_283_cov_1.428571_g231103_i0 | PRJNA1126198 | 231824 | 283 | 1.428571 | 4.04285593 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 194 | 7.09e-57 | NR | ORZ35835.1 | 765915 | g231103 | i0 | 100 | 0.985865724381625 | 93 | 0 | 98.6 | 0 | 280 | 2 | 421 | 513 | ORZ35835.1 hypothetical protein BCR44DRAFT_61089 [Catenaria anguillulae PL171] | diamond | 279 | 194 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 28617881 | 28617881 | PRJNA1126198_P_NODE_150527_length_313_cov_1.254167_g149808_i0 | PRJNA1126198 | 150527 | 313 | 1.254167 | 3.92554271 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 213 | 1.76e-65 | NR | ORZ36835.1 | 765915 | g149808 | i0 | 100 | 0.977635782747604 | 102 | 0 | 97.8 | 0 | 307 | 2 | 1 | 102 | ORZ36835.1 hypothetical protein BCR44DRAFT_49605 [Catenaria anguillulae PL171] | diamond | 306 | 213 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 28681063 | 28681063 | PRJNA1126198_P_NODE_395607_length_249_cov_0.886364_g394886_i0 | PRJNA1126198 | 395607 | 249 | 0.886364 | 2.20704636 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 99.4 | 1.0399999999999997e-23 | NR | ORZ30699.1 | 765915 | g394886 | i0 | 100 | 0.566265060240964 | 47 | 0 | 56.6 | 0 | 3 | 143 | 93 | 139 | ORZ30699.1 hypothetical protein BCR44DRAFT_35154 [Catenaria anguillulae PL171] | diamond | 141 | 99.4 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 29564908 | 29564908 | PRJNA1126198_P_NODE_283830_length_269_cov_2.326531_g283109_i0 | PRJNA1126198 | 283830 | 269 | 2.326531 | 6.25836839 | Blastocladiella emersonii ATCC 22665 | 1313167 | Fungi | Fungi | 127 | 8.87e-32 | NR | KAI9175604.1 | 1313167 | g283109 | i0 | 71.4 | 1.88475836431227 | 84 | 24 | 93.7 | 0 | 18 | 269 | 562 | 645 | KAI9175604.1 hypothetical protein H9P43_006967 [Blastocladiella emersonii ATCC 22665] | diamond | 507 | 127 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 31681942 | 31681942 | PRJNA1126198_P_NODE_330437_length_259_cov_1.258065_g329716_i0 | PRJNA1126198 | 330437 | 259 | 1.258065 | 3.25838835 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 117 | 2.17e-30 | NR | KAI9142183.1 | 1500003 | g329716 | i0 | 66.3 | 9.96138996138996 | 86 | 29 | 99.6 | 0 | 258 | 1 | 118 | 203 | KAI9142183.1 hypothetical protein BKA69DRAFT_1109383 [Paraphysoderma sedebokerense] | diamond | 2580 | 117 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 31998516 | 31998516 | PRJNA1126198_P_NODE_297238_length_266_cov_1.616580_g296517_i0 | PRJNA1126198 | 297238 | 266 | 1.61658 | 4.3001028 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 192 | 9.219999999999996e-55 | NR | ORZ29688.1 | 765915 | g296517 | i0 | 98.9 | 0.992481203007519 | 88 | 1 | 99.2 | 0 | 265 | 2 | 607 | 694 | ORZ29688.1 hypothetical protein BCR44DRAFT_1448203 [Catenaria anguillulae PL171] | diamond | 264 | 192 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 31998534 | 31998534 | PRJNA1126198_P_NODE_417118_length_247_cov_0.896552_g416397_i0 | PRJNA1126198 | 417118 | 247 | 0.896552 | 2.21448344 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 70.9 | 3.09e-12 | NR | ORZ39042.1 | 765915 | g416397 | i0 | 97.1 | 0.412955465587045 | 34 | 1 | 41.3 | 0 | 247 | 146 | 278 | 311 | ORZ39042.1 hypothetical protein BCR44DRAFT_46798 [Catenaria anguillulae PL171] | diamond | 102 | 70.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32188444 | 32188444 | PRJNA1126198_P_NODE_364358_length_252_cov_1.731844_g363637_i0 | PRJNA1126198 | 364358 | 252 | 1.731844 | 4.36424688 | Blastocladiella britannica | 64508 | Fungi | Fungi | 145 | 3.43e-38 | NR | KAI9224877.1 | 64508 | g363637 | i0 | 84.3 | 0.988095238095238 | 83 | 13 | 98.8 | 0 | 250 | 2 | 472 | 554 | KAI9224877.1 hypothetical protein BC828DRAFT_372287 [Blastocladiella britannica] | diamond | 249 | 145 | 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);;