contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA928559" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 902336 | 902336 | PRJNA928559_P_NODE_130021_length_311_cov_2.626050_g128452_i0 | PRJNA928559 | 130021 | 311 | 2.62605 | 8.1670155 | Catenaria sp. | 2420186 | Fungi | Fungi | 545 | 1.0899999999999999e-150 | NTclustered | gi|1866582716|gb|MT730891.1| | 2420186 | g128452 | i0 | 98.397 | 82.7266881028939 | 312 | 2 | 100 | 3 | 1 | 311 | 2938 | 3247 | Catenaria sp. isolate JEL0913 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 | 25728 | 545 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria sp. | |
| 5081500 | 5081500 | PRJNA928559_P_NODE_70004_length_420_cov_3.348703_g68435_i0 | PRJNA928559 | 70004 | 420 | 3.348703 | 14.0645526 | Physoderma | 109874 | Fungi | Fungi | 161 | 6.44e-35 | NTclustered | gi|311235628|ref|NG_027645.1| | 276838 | g68435 | i0 | 94.286 | 36.9119047619048 | 105 | 6 | 25 | 0 | 316 | 420 | 1720 | 1616 | Physoderma maydis DUKE DUH0007932 28S rRNA gene, partial sequence; from reference material | blastn | 15503 | 161 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Physoderma | Physoderma maydis | |
| 6007585 | 6007585 | PRJNA928559_P_NODE_70325_length_419_cov_4.416185_g68756_i0 | PRJNA928559 | 70325 | 419 | 4.416185 | 18.50381515 | Blastocladiella sp. | 2169676 | Fungi | Fungi | 418 | 3.449999999999999e-112 | NTclustered | gi|1866582625|gb|MT730800.1| | 2169676 | g68756 | i0 | 84.706 | 65.6133651551313 | 425 | 57 | 100 | 8 | 1 | 419 | 4658 | 4236 | Blastocladiella sp. isolate JEL0735 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 | 27492 | 418 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella sp. | |
| 8905656 | 8905656 | PRJNA928559_P_NODE_176347_length_262_cov_1.867725_g174778_i0 | PRJNA928559 | 176347 | 262 | 1.867725 | 4.8934395 | Catenariaceae | 109872 | Fungi | Fungi | 372 | 1.62e-98 | NTclustered | gi|82398236|gb|DQ273780.1| | 945688 | g174778 | i0 | 93.902 | 16.8549618320611 | 246 | 15 | 94 | 0 | 1 | 246 | 1728 | 1973 | Catenophlyctis sp. JEL298 isolate AFTOL-ID 36 28S ribosomal RNA gene, partial sequence | blastn | 4416 | 372 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenophlyctis | Catenophlyctis variabilis | |
| 18755262 | 18755262 | PRJNA928559_P_NODE_225235_length_217_cov_13.701389_g223666_i0 | PRJNA928559 | 225235 | 217 | 13.701389 | 29.73201413 | Physoderma maydis | 276838 | Fungi | Fungi | 111 | 3.12e-20 | NTclustered | gi|626438334|ref|NR_119547.1| | 276838 | g223666 | i0 | 86.408 | 45.668202764977 | 103 | 13 | 47 | 1 | 61 | 163 | 296 | 195 | Physoderma maydis DUKE DUH0007932 ITS region; from reference material | blastn | 9910 | 111 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Physodermatomycetes | Physodermatales | Physodermataceae | Physoderma | Physoderma maydis | |
| 20029745 | 20029745 | PRJNA928559_P_NODE_189156_length_252_cov_2.374302_g187587_i0 | PRJNA928559 | 189156 | 252 | 2.374302 | 5.98324104 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 255 | 1.62e-63 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g187587 | i0 | 93.605 | 67.6349206349206 | 172 | 9 | 68 | 2 | 1 | 172 | 3207 | 3376 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 17044 | 255 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 25479666 | 25479666 | PRJNA928559_P_NODE_45800_length_501_cov_5.413551_g44238_i0 | PRJNA928559 | 45800 | 501 | 5.413551 | 27.12189051 | Catenariaceae | 109872 | Fungi | Fungi | 913 | 0 | NTclustered | gi|1866582779|gb|MT730954.1| | 2420186 | g44238 | i0 | 99.799 | 102.281437125748 | 498 | 0 | 99 | 1 | 1 | 498 | 4078 | 4574 | Catenaria sp. isolate PL171 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 | 51243 | 913 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria sp. |
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);;