contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA493827" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1747593 | 1747593 | PRJNA493827_P_NODE_32242_length_656_cov_4.425386_g30124_i0 | PRJNA493827 | 32242 | 656 | 4.425386 | 29.03053216 | Catenaria anguillulae | 109876 | Fungi | Fungi | 1151 | 0 | NTclustered | gi|1866582512|gb|MT730687.1| | 109876 | g30124 | i0 | 98.328 | 87.844512195122 | 658 | 7 | 100 | 3 | 1 | 656 | 4751 | 4096 | 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 | 57626 | 1151 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 4297678 | 4297678 | PRJNA493827_P_NODE_16284_length_989_cov_6.629913_g14657_i0 | PRJNA493827 | 16284 | 989 | 6.629913 | 65.56983957 | Allomyces macrogynus | 28583 | Fungi | Fungi | 263 | 4.25e-65 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g14657 | i0 | 85.455 | 11.2436804853387 | 275 | 15 | 71 | 14 | 408 | 662 | 801 | 532 | Allomyces macrogynus mitochondrion, complete genome | blastn | 11120 | 263 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 8123604 | 8123604 | PRJNA493827_P_NODE_148787_length_280_cov_5.309179_g146589_i0 | PRJNA493827 | 148787 | 280 | 5.309179 | 14.8657012 | Catenophlyctis variabilis | 945688 | Fungi | Fungi | 508 | 1.27e-139 | NTclustered | gi|82398236|gb|DQ273780.1| | 945688 | g146589 | i0 | 99.291 | 74.7214285714286 | 282 | 0 | 100 | 1 | 1 | 280 | 2823 | 2542 | Catenophlyctis sp. JEL298 isolate AFTOL-ID 36 28S ribosomal RNA gene, partial sequence | blastn | 20922 | 508 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenophlyctis | Catenophlyctis variabilis | |
| 8758605 | 8758605 | PRJNA493827_P_NODE_35487_length_620_cov_3.946984_g33329_i0 | PRJNA493827 | 35487 | 620 | 3.946984 | 24.4713008 | Catenaria | 109875 | Fungi | Fungi | 1074 | 0 | NTclustered | gi|1866582512|gb|MT730687.1| | 109876 | g33329 | i0 | 98.065 | 68.9870967741935 | 620 | 6 | 100 | 6 | 1 | 620 | 2845 | 3458 | 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 | 42772 | 1074 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Catenariaceae | Catenaria | Catenaria anguillulae | |
| 11952481 | 11952481 | PRJNA493827_P_NODE_73970_length_402_cov_5.863222_g71772_i0 | PRJNA493827 | 73970 | 402 | 5.863222 | 23.57015244 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 267 | 1.26e-66 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g71772 | i0 | 94.286 | 45.181592039801 | 175 | 8 | 44 | 2 | 228 | 402 | 3376 | 3204 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 18163 | 267 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 15772748 | 15772748 | PRJNA493827_P_NODE_129033_length_301_cov_1.298246_g126835_i0 | PRJNA493827 | 129033 | 301 | 1.298246 | 3.90772046 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 298 | 3.26e-76 | NTclustered | gi|91242965|gb|DQ454114.1| | 4808 | g126835 | i0 | 84.95 | 103.65780730897 | 299 | 39 | 99 | 6 | 1 | 297 | 365 | 659 | Blastocladiella emersonii heat shock protein Hsp70-9 mRNA, complete cds | blastn | 31201 | 298 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 18324300 | 18324300 | PRJNA493827_P_NODE_31175_length_670_cov_1.031826_g29074_i0 | PRJNA493827 | 31175 | 670 | 1.031826 | 6.9132342 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 235 | 6.179999999999999e-57 | NTclustered | gi|209427640|ref|NC_011360.1| | 4808 | g29074 | i0 | 89.362 | 13.1835820895522 | 188 | 18 | 57 | 2 | 88 | 274 | 14738 | 14924 | Blastocladiella emersonii mitochondrion, complete genome | blastn | 8833 | 235 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 22150514 | 22150514 | PRJNA493827_P_NODE_81998_length_380_cov_1.547231_g79800_i0 | PRJNA493827 | 81998 | 380 | 1.547231 | 5.8794778 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 228 | 5.609999999999999e-55 | NTclustered | gi|684989|gb|L22497.1|BSIAHSP70X | 4808 | g79800 | i0 | 82.836 | 3.78421052631579 | 268 | 33 | 68 | 9 | 67 | 326 | 2890 | 2628 | Blastocladiella emersonii heat shock protein (hsp70) gene, complete cds | blastn | 1438 | 228 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii |
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);;