contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA841653" and tax_phylum = "Endomyxa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 830251 | 830251 | PRJNA841653_P_NODE_23021_length_339_cov_2.597744_g22347_i0 | PRJNA841653 | 23021 | 339 | 2.597744 | 8.80635216 | Polymyxa betae | 41456 | SAR_Eukaryotes | SAR_Eukaryotes | 569 | 7.149999999999998e-158 | NTclustered | gi|2127897050|ref|NC_059071.1| | 41456 | g22347 | i0 | 97.313 | 81.6017699115044 | 335 | 9 | 99 | 0 | 1 | 335 | 16002 | 15668 | Polymyxa betae isolate A26-41 genome assembly, organelle: mitochondrion | blastn | 27663 | 569 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa betae | ||
| 4658518 | 4658518 | PRJNA841653_P_NODE_16344_length_405_cov_12.737952_g15672_i0 | PRJNA841653 | 16344 | 405 | 12.737952 | 51.5887056 | Plasmodiophora brassicae | 37360 | SAR_Eukaryotes | SAR_Eukaryotes | 285 | 3.5199999999999995e-72 | NTclustered | gi|1031965310|gb|KX011115.1| | 37360 | g15672 | i0 | 95.109 | 40.5703703703704 | 184 | 4 | 45 | 3 | 2 | 185 | 7721 | 7899 | Plasmodiophora brassicae isolate AT 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 16431 | 285 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Plasmodiophora | Plasmodiophora brassicae | ||
| 21233064 | 21233064 | PRJNA841653_P_NODE_63137_length_236_cov_47.533742_g62463_i0 | PRJNA841653 | 63137 | 236 | 47.533742 | 112.17963112 | Woronina pythii | 1484336 | SAR_Eukaryotes | SAR_Eukaryotes | 239 | 1.5100000000000002e-58 | NTclustered | gi|1031965309|gb|KX011114.1| | 1484336 | g62463 | i0 | 85.593 | 55.1271186440678 | 236 | 25 | 98 | 7 | 5 | 236 | 4707 | 4937 | Woronina pythii isolate PD0236 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 13010 | 239 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Woronina | Woronina pythii | ||
| 23783327 | 23783327 | PRJNA841653_P_NODE_63979_length_226_cov_16.810458_g63305_i0 | PRJNA841653 | 63979 | 226 | 16.810458 | 37.99163508 | Spongospora sp. HH-2014 | 1483711 | SAR_Eukaryotes | SAR_Eukaryotes | 363 | 8.179999999999999e-96 | NTclustered | gi|605052146|gb|KJ150290.1| | 1483711 | g63305 | i0 | 96.38 | 129.057522123894 | 221 | 6 | 98 | 1 | 1 | 221 | 5222 | 5004 | Spongospora sp. HH-2014 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 | 29167 | 363 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Spongospora | Spongospora sp. HH-2014 | ||
| 25457216 | 25457216 | PRJNA841653_P_NODE_20920_length_356_cov_41.477032_g20246_i0 | PRJNA841653 | 20920 | 356 | 41.477032 | 147.65823392 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 584 | 2.689999999999999e-162 | NTclustered | gi|15088524|gb|AF310902.1|AF310902 | 41456 | g20246 | i0 | 96.866 | 76.8820224719101 | 351 | 8 | 98 | 2 | 8 | 356 | 41 | 390 | Polymyxa betae 18S small subunit ribosomal RNA gene, partial sequence | blastn | 27370 | 584 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa betae | ||
| 25457564 | 25457564 | PRJNA841653_P_NODE_64180_length_219_cov_24.541096_g63506_i0 | PRJNA841653 | 64180 | 219 | 24.541096 | 53.74500024 | Eukaryota | 2759 | SAR_Eukaryotes | SAR_Eukaryotes | 379 | 7.829999999999998e-101 | NTclustered | gi|15088524|gb|AF310902.1|AF310902 | 41456 | g63506 | i0 | 98.598 | 96.7305936073059 | 214 | 3 | 98 | 0 | 5 | 218 | 1466 | 1679 | Polymyxa betae 18S small subunit ribosomal RNA gene, partial sequence | blastn | 21184 | 379 | 1 | Eukaryota | Sar | Endomyxa | Phytomyxea | Plasmodiophorida | Plasmodiophoridae | Polymyxa | Polymyxa betae |
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);;