contig_metadata
11 rows where bioproject = "PRJNA681822", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3723130 | 3723130 | PRJNA681822_S_NODE_1903_length_156_cov_5.370079_g1878_i0 | PRJNA681822 | 1903 | 156 | 5.370079 | 8.37732324 | Opisthokonta | 33154 | Fungi | Fungi | 87.9 | 3.52e-13 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g1878 | i0 | 96.226 | 34.6987179487179 | 53 | 2 | 34 | 0 | 104 | 156 | 2214 | 2162 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 5413 | 87.9 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 9585762 | 9585762 | PRJNA681822_P_NODE_87168_length_412_cov_1.227139_g85687_i0 | PRJNA681822 | 87168 | 412 | 1.227139 | 5.05581268 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 178 | 2.78e-53 | NR | KAI9135927.1 | 1500003 | g85687 | i0 | 69.5 | 1.90776699029126 | 131 | 40 | 95.4 | 0 | 2 | 394 | 119 | 249 | KAI9135927.1 40S ribosomal protein S1 [Paraphysoderma sedebokerense] | diamond | 786 | 178 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 19781949 | 19781949 | PRJNA681822_P_NODE_381696_length_251_cov_1.533708_g380207_i0 | PRJNA681822 | 381696 | 251 | 1.533708 | 3.84960708 | Catenaria sp. | 2420186 | Fungi | Fungi | 457 | 4.13e-124 | NTclustered | gi|1866582799|gb|MT730974.1| | 2420186 | g380207 | i0 | 100 | 65.9601593625498 | 247 | 0 | 98 | 0 | 5 | 251 | 2751 | 2505 | 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 | 16556 | 457 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria sp. | |
| 23606418 | 23606418 | PRJNA681822_P_NODE_255779_length_285_cov_1.448113_g254290_i0 | PRJNA681822 | 255779 | 285 | 1.448113 | 4.12712205 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 152 | 1.98e-40 | NR | KAI9144950.1 | 1500003 | g254290 | i0 | 74.7 | 1 | 95 | 24 | 100 | 0 | 1 | 285 | 1208 | 1302 | KAI9144950.1 clathrin heavy chain [Paraphysoderma sedebokerense] | diamond | 285 | 152 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 26618939 | 26618939 | PRJNA681822_P_NODE_482321_length_241_cov_0.916667_g480831_i0 | PRJNA681822 | 482321 | 241 | 0.916667 | 2.20916747 | Blastocladiella | 4807 | Fungi | Fungi | 121 | 1.89e-33 | NR | KAI9218514.1 | 64508 | g480831 | i0 | 67.1 | 1.96680497925311 | 79 | 26 | 98.3 | 0 | 5 | 241 | 2 | 80 | KAI9218514.1 Sedlin [Blastocladiella britannica] | diamond | 474 | 121 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella britannica | |
| 27903076 | 27903076 | PRJNA681822_P_NODE_438445_length_245_cov_1.790698_g436956_i0 | PRJNA681822 | 438445 | 245 | 1.790698 | 4.3872101 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 107 | 3.23e-28 | NR | ORZ41170.1 | 765915 | g436956 | i0 | 78.9 | 0.869387755102041 | 71 | 15 | 86.9 | 0 | 9 | 221 | 17 | 87 | ORZ41170.1 ubiquinol-cytochrome C reductase hinge protein-domain-containing protein [Catenaria anguillulae PL171] | diamond | 213 | 107 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 28471728 | 28471728 | PRJNA681822_P_NODE_406586_length_249_cov_0.875000_g405097_i0 | PRJNA681822 | 406586 | 249 | 0.875 | 2.17875 | Allomyces macrogynus ATCC 38327 | 578462 | Fungi | Fungi | 79.3 | 2.1e-16 | NR | KNE56744.1 | 578462 | g405097 | i0 | 58.8 | 3.06024096385542 | 68 | 28 | 81.9 | 0 | 206 | 3 | 1 | 68 | KNE56744.1 hypothetical protein AMAG_02524 [Allomyces macrogynus ATCC 38327] | diamond | 762 | 79.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 28976904 | 28976904 | PRJNA681822_P_NODE_252308_length_286_cov_1.286385_g250819_i0 | PRJNA681822 | 252308 | 286 | 1.286385 | 3.6790611 | Coelomomyces lativittatus | 945690 | Fungi | Fungi | 79 | 1.85e-15 | NR | KAJ1506285.1 | 945690 | g250819 | i0 | 59.4 | 0.671328671328671 | 64 | 20 | 60.8 | 1 | 284 | 111 | 126 | 189 | KAJ1506285.1 hypothetical protein HMI55_001242 [Coelomomyces lativittatus] | diamond | 192 | 79 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Coelomomycetaceae | Coelomomyces | Coelomomyces lativittatus | |
| 29987246 | 29987246 | PRJNA681822_P_NODE_284211_length_278_cov_1.502439_g282722_i0 | PRJNA681822 | 284211 | 278 | 1.502439 | 4.17678042 | Catenaria anguillulae PL171 | 765915 | Fungi | Fungi | 96.3 | 1.3e-22 | NR | ORZ41022.1 | 765915 | g282722 | i0 | 57.9 | 2.01798561151079 | 95 | 35 | 99.3 | 2 | 3 | 278 | 6 | 98 | ORZ41022.1 inorganic phosphate transporter Pho88 [Catenaria anguillulae PL171] | diamond | 561 | 96.3 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 32327036 | 32327036 | PRJNA681822_P_NODE_257239_length_285_cov_1.089623_g255750_i0 | PRJNA681822 | 257239 | 285 | 1.089623 | 3.10542555 | Paraphysoderma sedebokerense | 1500003 | Fungi | Fungi | 149 | 6.58e-40 | NR | KAI9143756.1 | 1500003 | g255750 | i0 | 74.7 | 1 | 95 | 23 | 100 | 1 | 285 | 1 | 412 | 505 | KAI9143756.1 hypothetical protein BKA69DRAFT_1058803 [Paraphysoderma sedebokerense] | diamond | 285 | 149 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Paraphysoderma | Paraphysoderma sedebokerense | |
| 32338641 | 32338641 | PRJNA681822_P_NODE_89299_length_408_cov_1.644776_g87817_i0 | PRJNA681822 | 89299 | 408 | 1.644776 | 6.71068608 | Blastocladiales | 4805 | Fungi | Fungi | 132 | 4.8e-34 | NR | ORZ31241.1 | 765915 | g87817 | i0 | 57.4 | 4.74264705882353 | 115 | 49 | 84.6 | 0 | 355 | 11 | 142 | 256 | ORZ31241.1 peptidase S8/S53 domain-containing protein [Catenaria anguillulae PL171] | diamond | 1935 | 132 | 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);;