contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1000943" and tax_phylum = "Microsporidia"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2695378 | 2695378 | PRJNA1000943_P_NODE_5903_length_331_cov_1.891473_g5765_i0 | PRJNA1000943 | 5903 | 331 | 1.891473 | 6.26077563 | Vavraia culicis | 103449 | Fungi | Fungi | 248 | 3.7e-61 | NTclustered | gi|667631888|ref|XM_008075036.1| | 948595 | g5765 | i0 | 81.457 | 2.70392749244713 | 302 | 56 | 91 | 0 | 16 | 317 | 278 | 579 | Vavraia culicis subsp. floridensis actin-1 (VCUG_00207), mRNA | blastn | 895 | 248 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Vavraia | Vavraia culicis | |||
| 3971508 | 3971508 | PRJNA1000943_P_NODE_8884_length_279_cov_1.184466_g8746_i0 | PRJNA1000943 | 8884 | 279 | 1.184466 | 3.30466014 | Pleistophora mulleri | 249366 | Fungi | Fungi | 420 | 6.11e-113 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g8746 | i0 | 93.594 | 32.84229390681 | 281 | 16 | 100 | 2 | 1 | 279 | 3520 | 3240 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 9163 | 420 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 6523498 | 6523498 | PRJNA1000943_P_NODE_4366_length_377_cov_2.315789_g4229_i0 | PRJNA1000943 | 4366 | 377 | 2.315789 | 8.73052453 | Pleistophora mulleri | 249366 | Fungi | Fungi | 250 | 1.19e-61 | NTclustered | gi|134147422|gb|EF119339.1| | 249366 | g4229 | i0 | 83.835 | 0.705570291777188 | 266 | 39 | 70 | 3 | 1 | 264 | 2367 | 2630 | Pleistophora mulleri 16S ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence | blastn | 266 | 250 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Pleistophora | Pleistophora mulleri | |||
| 9072630 | 9072630 | PRJNA1000943_P_NODE_4968_length_357_cov_1.098592_g4831_i0 | PRJNA1000943 | 4968 | 357 | 1.098592 | 3.92197344 | Fusasporis stethaprioni | 2777717 | Fungi | Fungi | 573 | 5.829999999999998e-159 | NTclustered | gi|1914073495|gb|MW077214.1| | 2777717 | g4831 | i0 | 95.81 | 99.8515406162465 | 358 | 10 | 100 | 4 | 1 | 357 | 867 | 1220 | Fusasporis stethaprioni strain 2018 small subunit ribosomal RNA gene, partial sequence | blastn | 35647 | 573 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Fusasporis | Fusasporis stethaprioni | |||
| 9927268 | 9927268 | PRJNA1000943_P_NODE_9488_length_270_cov_3.167513_g9350_i0 | PRJNA1000943 | 9488 | 270 | 3.167513 | 8.5522851 | Heterosporis | 157917 | Fungi | Fungi | 381 | 2.779999999999999e-101 | NTclustered | gi|448278452|gb|KC137548.1| | 1289055 | g9350 | i0 | 92.509 | 11.7703703703704 | 267 | 18 | 99 | 2 | 3 | 268 | 1885 | 2150 | Heterosporis sp. NBDP-2013a isolate MN/WAE small subunit ribosomal RNA gene, partial sequence; internal transcribed spacer, complete sequence; and large subunit ribosomal RNA gene, partial sequence | blastn | 3178 | 381 | 1 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Pleistophoridae | Heterosporis | Heterosporis sp. NBDP-2013a | |||
| 17577113 | 17577113 | PRJNA1000943_P_NODE_3554_length_413_cov_1.726471_g3417_i0 | PRJNA1000943 | 3554 | 413 | 1.726471 | 7.13032523 | Eukaryota | 2759 | Fungi | Fungi | 394 | 5.73e-105 | NTclustered | gi|16605491|emb|AJ295325.1| | 144522 | g3417 | i0 | 84.123 | 101.411622276029 | 422 | 52 | 100 | 8 | 1 | 413 | 961 | 1376 | Glugea sp. GS1 partial 16S rRNA gene, ITS and partial 23S rRNA gene | blastn | 41883 | 396 | 0.994949494949495 | Eukaryota | Opisthokonta | Fungi | Microsporidia | Glugeidae | Glugea | Glugea sp. GS1 |
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);;