contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA1218816" and tax_phylum = "Chytridiomycota"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4874394 | 4874394 | PRJNA1218816_P_NODE_52904_length_253_cov_2.522222_g52471_i0 | PRJNA1218816 | 52904 | 253 | 2.522222 | 6.38122166 | Nowakowskiella | 109880 | Fungi | Fungi | 180 | 1.01e-40 | NTclustered | gi|194241380|gb|EU828507.1| | 546781 | g52471 | i0 | 97.196 | 40.0553359683794 | 107 | 2 | 42 | 1 | 147 | 253 | 308 | 203 | Nowakowskiella sp. JH FR 28S large subunit ribosomal RNA gene, partial sequence | blastn | 10134 | 180 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Cladochytriales | Nowakowskiellaceae | Nowakowskiella | Nowakowskiella sp. JH FR | |
| 5436424 | 5436424 | PRJNA1218816_P_NODE_11725_length_728_cov_1.592366_g11320_i0 | PRJNA1218816 | 11725 | 728 | 1.592366 | 11.59242448 | Geranomyces variabilis | 109894 | Fungi | Fungi | 257 | 1.44e-63 | NTclustered | gi|1866582431|gb|MT730606.1| | 109894 | g11320 | i0 | 95.625 | 32.4876373626374 | 160 | 7 | 32 | 0 | 253 | 412 | 4623 | 4464 | Geranomyces variabilis isolate AF30 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 | 23651 | 257 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Geranomyces | Geranomyces variabilis | |
| 5436537 | 5436537 | PRJNA1218816_P_NODE_32565_length_349_cov_1.097826_g32132_i0 | PRJNA1218816 | 32565 | 349 | 1.097826 | 3.83141274 | Fimicolochytrium jonesii | 1396493 | Fungi | Fungi | 237 | 8.48e-58 | NTclustered | gi|2432064921|ref|XM_053069781.1| | 1396493 | g32132 | i0 | 82.482 | 34.1031518624642 | 274 | 44 | 78 | 4 | 13 | 284 | 525 | 254 | Fimicolochytrium jonesii tubulin, alpha, ubiquitous (EV422DRAFT_521958), mRNA | blastn | 11902 | 237 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Spizellomycetales | Powellomycetaceae | Fimicolochytrium | Fimicolochytrium jonesii | |
| 8699330 | 8699330 | PRJNA1218816_P_NODE_64347_length_207_cov_7.477612_g63914_i0 | PRJNA1218816 | 64347 | 207 | 7.477612 | 15.47865684 | Fungi | 4751 | Fungi | Fungi | 361 | 2.65e-95 | NTclustered | gi|6707218|gb|AF164335.1| | 109949 | g63914 | i0 | 98.068 | 100.004830917874 | 207 | 4 | 100 | 0 | 1 | 207 | 1398 | 1604 | Monoblepharella elongata strain BKCR91 18S ribosomal RNA gene, partial sequence | blastn | 20701 | 361 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Monoblepharidomycetes | Monoblepharidales | Monoblepharidaceae | Monoblepharella | Monoblepharella elongata | |
| 18184753 | 18184753 | PRJNA1218816_P_NODE_10835_length_773_cov_3.301429_g10437_i0 | PRJNA1218816 | 10835 | 773 | 3.301429 | 25.52004617 | Chytridiales sp. | 2011832 | Fungi | Fungi | 305 | 5.39e-78 | NTclustered | gi|2468791101|gb|OQ702943.1| | 2011832 | g10437 | i0 | 78.195 | 22.5316946959896 | 532 | 79 | 69 | 22 | 1 | 530 | 3945 | 4441 | Chytridiales sp. isolate PSC290 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 | 17417 | 305 | 1 | Eukaryota | Opisthokonta | Fungi | Chytridiomycota | Chytridiomycetes | Chytridiales | Chytridiales 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);;