contig_metadata
5 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3327970 | 3327970 | PRJNA792582_P_NODE_18243_length_403_cov_1.290909_g17429_i0 | PRJNA792582 | 18243 | 403 | 1.290909 | 5.20236327 | Polyschismium peyerimhoffii | 2911783 | Evosea | other_Eukaryota | 276 | 2.11e-69 | NTclustered | gi|2161226355|gb|MZ313553.1| | 2911783 | g17429 | i0 | 88.066 | 36.1712158808933 | 243 | 16 | 58 | 11 | 142 | 376 | 6800 | 6563 | Polyschismium peyerimhoffii 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 | 14577 | 276 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Polyschismium | Polyschismium peyerimhoffii | ||
| 9705127 | 9705127 | PRJNA792582_P_NODE_21348_length_373_cov_1.003333_g20534_i0 | PRJNA792582 | 21348 | 373 | 1.003333 | 3.74243209 | Telaepolella tubasferens | 1346289 | Evosea | other_Eukaryota | 431 | 3.9e-116 | NTclustered | gi|167859711|gb|EU273435.1| | 1346289 | g20534 | i0 | 88.219 | 99.4343163538874 | 365 | 38 | 98 | 5 | 1 | 365 | 360 | 1 | Telaepolella tubasferens clone 1 actin gene, partial cds | blastn | 37089 | 431 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Flamellidae | Telaepolella | Telaepolella tubasferens | |||
| 16079368 | 16079368 | PRJNA792582_P_NODE_27433_length_330_cov_1.186770_g26619_i0 | PRJNA792582 | 27433 | 330 | 1.18677 | 3.916341 | Arcyria sp. 'tenuissima' | 3129282 | Evosea | other_Eukaryota | 337 | 7.66e-88 | NTclustered | gi|2698738389|gb|PP491458.1| | 3129282 | g26619 | i0 | 85.196 | 38.4787878787879 | 331 | 46 | 100 | 2 | 1 | 330 | 703 | 1031 | Arcyria sp. 'tenuissima' voucher sc32644 internal transcribed spacer region, partial sequence | blastn | 12698 | 337 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Arcyria | Arcyria sp. 'tenuissima' | ||
| 22454145 | 22454145 | PRJNA792582_P_NODE_27398_length_330_cov_1.435798_g26584_i0 | PRJNA792582 | 27398 | 330 | 1.435798 | 4.7381334 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 67.6 | 1.11e-6 | NTclustered | gi|1160569142|ref|XM_020571968.1| | 670386 | g26584 | i0 | 97.436 | 1.65757575757576 | 39 | 1 | 12 | 0 | 114 | 152 | 42 | 80 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 547 | 67.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 23729696 | 23729696 | PRJNA792582_P_NODE_17759_length_409_cov_1.166667_g16945_i0 | PRJNA792582 | 17759 | 409 | 1.166667 | 4.77166803 | Didymium spongiosum | 289992 | Evosea | other_Eukaryota | 326 | 2.1e-84 | NTclustered | gi|2161226356|gb|MZ313554.1| | 289992 | g16945 | i0 | 83.607 | 6.60880195599022 | 366 | 41 | 86 | 16 | 42 | 394 | 7194 | 7553 | Mucilago crustacea 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 | 2703 | 326 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium spongiosum |
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);;