contig_metadata
6 rows where analysis = "blastn", bioproject = "PRJNA1025141" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 162842 | 162842 | PRJNA1025141_P_NODE_8241_length_273_cov_1.155000_g8180_i0 | PRJNA1025141 | 8241 | 273 | 1.155 | 3.15315 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 139 | 1.87e-28 | NTclustered | gi|831768889|ref|XM_012897087.1| | 1410327 | g8180 | i0 | 77.459 | 49.1538461538462 | 244 | 47 | 88 | 6 | 15 | 254 | 764 | 525 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 13419 | 139 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 2279349 | 2279349 | PRJNA1025141_P_NODE_11802_length_244_cov_2.257310_g11741_i0 | PRJNA1025141 | 11802 | 244 | 2.25731 | 5.5078364 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 204 | 5.74e-48 | NTclustered | gi|2329703080|gb|MW239897.1| | 523813 | g11741 | i0 | 83.26 | 92.6844262295082 | 227 | 32 | 92 | 6 | 3 | 226 | 337 | 560 | Diderma floriforme strain MA-Fungi 81015 alpha tubulin (aTUB) gene, partial cds | blastn | 22615 | 204 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Diderma | Diderma floriforme | ||
| 9932238 | 9932238 | PRJNA1025141_P_NODE_9248_length_252_cov_1.932961_g9187_i0 | PRJNA1025141 | 9248 | 252 | 1.932961 | 4.87106172 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 246 | 9.77e-61 | NTclustered | gi|66820523|ref|XM_638773.1| | 352472 | g9187 | i0 | 87.678 | 51.8293650793651 | 211 | 26 | 84 | 0 | 1 | 211 | 220 | 10 | Dictyostelium discoideum AX4 hypothetical protein (act22) mRNA, complete cds | blastn | 13061 | 246 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 10365945 | 10365945 | PRJNA1025141_P_NODE_11369_length_246_cov_0.890173_g11308_i0 | PRJNA1025141 | 11369 | 246 | 0.890173 | 2.18982558 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 233 | 7.39e-57 | NTclustered | gi|330805886|ref|XM_003290860.1| | 5786 | g11308 | i0 | 83.806 | 162.134146341463 | 247 | 38 | 100 | 2 | 1 | 246 | 469 | 224 | Dictyostelium purpureum ubiquitin (DICPUDRAFT_57034), mRNA | blastn | 39885 | 233 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 16739753 | 16739753 | PRJNA1025141_P_NODE_4534_length_382_cov_0.864078_g4473_i0 | PRJNA1025141 | 4534 | 382 | 0.864078 | 3.30077796 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 165 | 4.48e-36 | NTclustered | gi|831788452|ref|XM_012903297.1| | 1410327 | g4473 | i0 | 75.74 | 11.196335078534 | 338 | 76 | 88 | 5 | 48 | 382 | 1907 | 1573 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 4277 | 165 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 23115055 | 23115055 | PRJNA1025141_P_NODE_3959_length_409_cov_0.907738_g3898_i0 | PRJNA1025141 | 3959 | 409 | 0.907738 | 3.71264842 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 518 | 3.22e-142 | NTclustered | gi|66821326|ref|XM_639065.1| | 352472 | g3898 | i0 | 89.487 | 97.8630806845966 | 409 | 43 | 100 | 0 | 1 | 409 | 1072 | 664 | Dictyostelium discoideum AX4 hypothetical protein (act13) mRNA, complete cds | blastn | 40026 | 518 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum |
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);;