contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA896758" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2148156 | 2148156 | PRJNA896758_P_NODE_19882_length_260_cov_1.834225_g19492_i0 | PRJNA896758 | 19882 | 260 | 1.834225 | 4.768985 | Allomyces arbusculus | 64504 | Fungi | Fungi | 252 | 2.18e-62 | NTclustered | gi|196052856|emb|FM200840.4| | 64504 | g19492 | i0 | 85.02 | 1.90769230769231 | 247 | 37 | 95 | 0 | 14 | 260 | 1400 | 1154 | Allomyces arbuscula mca II gene for calcium-dependent metacaspase CDP II, strain Burma 1Db | blastn | 496 | 252 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 2148242 | 2148242 | PRJNA896758_P_NODE_462_length_1612_cov_4.494477_g304_i0 | PRJNA896758 | 462 | 1612 | 4.494477 | 72.45096924 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 1938 | 0 | NTclustered | gi|117422539|gb|EF064246.1| | 4808 | g304 | i0 | 91.613 | 71.863523573201 | 1407 | 110 | 87 | 8 | 184 | 1586 | 1474 | 72 | Blastocladiella emersonii elongation factor alpha-like protein mRNA, complete cds | blastn | 115844 | 1938 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 2148267 | 2148267 | PRJNA896758_P_NODE_7402_length_416_cov_9.358601_g7012_i0 | PRJNA896758 | 7402 | 416 | 9.358601 | 38.93178016 | Allomyces arbusculus | 64504 | Fungi | Fungi | 726 | 0 | NTclustered | gi|1405239019|ref|NG_027623.1| | 64504 | g7012 | i0 | 98.086 | 106.944711538462 | 418 | 6 | 100 | 2 | 1 | 416 | 2465 | 2882 | Allomyces arbusculus UCBMG Brasil 2 28S rRNA gene, partial sequence; from reference material | blastn | 44489 | 726 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces arbusculus | |
| 7250891 | 7250891 | PRJNA896758_P_NODE_12346_length_327_cov_2.251969_g11956_i0 | PRJNA896758 | 12346 | 327 | 2.251969 | 7.36393863 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 169 | 2.93e-37 | NTclustered | gi|111054102|gb|DQ787196.1| | 4808 | g11956 | i0 | 80.804 | 2.62996941896024 | 224 | 36 | 69 | 5 | 102 | 325 | 3299 | 3083 | Blastocladiella emersonii heat shock protein 90 kDa (hsp90) gene, complete cds | blastn | 860 | 169 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 12351882 | 12351882 | PRJNA896758_P_NODE_9730_length_365_cov_2.955479_g9340_i0 | PRJNA896758 | 9730 | 365 | 2.955479 | 10.78749835 | Allomyces moniliformis | 64506 | Fungi | Fungi | 505 | 2.209999999999999e-138 | NTclustered | gi|321173707|gb|HQ888688.1| | 64506 | g9340 | i0 | 91.644 | 58.4520547945205 | 371 | 21 | 100 | 8 | 1 | 365 | 1674 | 1308 | Allomyces moniliformis strain India 3 18S ribosomal RNA gene, partial sequence | blastn | 21335 | 505 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces moniliformis | |
| 13997881 | 13997881 | PRJNA896758_P_NODE_8931_length_381_cov_1.340909_g8541_i0 | PRJNA896758 | 8931 | 381 | 1.340909 | 5.10886329 | Allomyces | 28581 | Fungi | Fungi | 699 | 0 | NTclustered | gi|321173707|gb|HQ888688.1| | 64506 | g8541 | i0 | 99.738 | 77.257217847769 | 381 | 1 | 100 | 0 | 1 | 381 | 962 | 582 | Allomyces moniliformis strain India 3 18S ribosomal RNA gene, partial sequence | blastn | 29435 | 699 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces moniliformis | |
| 16175588 | 16175588 | PRJNA896758_P_NODE_22373_length_249_cov_0.875000_g21983_i0 | PRJNA896758 | 22373 | 249 | 0.875 | 2.17875 | Allomyces macrogynus | 28583 | Fungi | Fungi | 309 | 1.21e-79 | NTclustered | gi|11467573|ref|NC_001715.1| | 28583 | g21983 | i0 | 89.02 | 1.44176706827309 | 255 | 20 | 100 | 6 | 1 | 249 | 1400 | 1652 | Allomyces macrogynus mitochondrion, complete genome | blastn | 359 | 309 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces macrogynus | |
| 18724393 | 18724393 | PRJNA896758_P_NODE_9775_length_364_cov_7.329897_g9385_i0 | PRJNA896758 | 9775 | 364 | 7.329897 | 26.68082508 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 270 | 8.76e-68 | NTclustered | gi|2440036|emb|X90411.1| | 4808 | g9385 | i0 | 93.478 | 47.0467032967033 | 184 | 9 | 50 | 3 | 183 | 364 | 3381 | 3199 | B.emersonii DNA for 28S ribosomal RNA gene | blastn | 17125 | 270 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Blastocladiella | Blastocladiella emersonii | |
| 22549696 | 22549696 | PRJNA896758_P_NODE_2458_length_734_cov_9.419062_g2099_i0 | PRJNA896758 | 2458 | 734 | 9.419062 | 69.13591508 | Allomyces moniliformis | 64506 | Fungi | Fungi | 1205 | 0 | NTclustered | gi|321173763|gb|HQ888744.1| | 64506 | g2099 | i0 | 98.248 | 68.3950953678474 | 685 | 11 | 93 | 1 | 50 | 734 | 1 | 684 | Allomyces moniliformis strain India 3 28S ribosomal RNA gene, partial sequence | blastn | 50202 | 1205 | 1 | Eukaryota | Opisthokonta | Fungi | Blastocladiomycota | Blastocladiomycetes | Blastocladiales | Blastocladiaceae | Allomyces | Allomyces moniliformis | |
| 23825010 | 23825010 | PRJNA896758_P_NODE_2199_length_776_cov_1.314367_g1848_i0 | PRJNA896758 | 2199 | 776 | 1.314367 | 10.19948792 | Blastocladiella emersonii | 4808 | Fungi | Fungi | 667 | 0 | NTclustered | gi|240254697|gb|FJ765531.1| | 4808 | g1848 | i0 | 83.243 | 2.30541237113402 | 734 | 115 | 94 | 7 | 1 | 730 | 711 | 1440 | Blastocladiella emersonii cGMP phosphodiesterase mRNA, complete cds | blastn | 1789 | 667 | 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);;