contig_metadata
9 rows where analysis = "blastn", bioproject = "PRJNA1063685" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 6557544 | 6557544 | PRJNA1063685_S_NODE_38086_length_378_cov_7.963934_g37543_i0 | PRJNA1063685 | 38086 | 378 | 7.963934 | 30.10367052 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 390 | 6.72e-104 | NTclustered | gi|467633|emb|Z29969.1| | 5759 | g37543 | i0 | 85.526 | 47.8068783068783 | 380 | 48 | 100 | 7 | 1 | 378 | 2026 | 1652 | E.histolytica plasmid genes for ribosomal RNA and hemolysins HLY1, HLY5mc1 HLY5mc2 HLY4 | blastn | 18071 | 390 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 9106948 | 9106948 | PRJNA1063685_S_NODE_14228_length_571_cov_5.265060_g13703_i0 | PRJNA1063685 | 14228 | 571 | 5.26506 | 30.0634926 | Echinostelium arboreum | 318077 | Evosea | other_Eukaryota | 569 | 1.2599999999999999e-157 | NTclustered | gi|210062525|gb|AY842030.2| | 318077 | g13703 | i0 | 95.775 | 51.7600700525394 | 355 | 11 | 62 | 2 | 207 | 560 | 954 | 603 | Echinostelium arboreum strain ATCC 66095 18S ribosomal RNA gene, partial sequence | blastn | 29555 | 569 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Echinosteliales | Echinosteliidae | Echinostelium | Echinostelium arboreum | ||
| 9107232 | 9107232 | PRJNA1063685_S_NODE_4048_length_766_cov_12.924964_g3636_i0 | PRJNA1063685 | 4048 | 766 | 12.924964 | 99.00522424 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 556 | 1.34e-153 | NTclustered | gi|161213|gb|M98863.1|SLMALTA | 5791 | g3636 | i0 | 82.308 | 76.3446475195822 | 650 | 107 | 84 | 8 | 47 | 692 | 690 | 1335 | Physarum polycephalum alpha-tubulin (altA) mRNA, complete cds | blastn | 58480 | 556 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 14208610 | 14208610 | PRJNA1063685_S_NODE_79992_length_208_cov_5.096296_g79449_i0 | PRJNA1063685 | 79992 | 208 | 5.096296 | 10.60029568 | Phalansterium solitarium | 136499 | Evosea | other_Eukaryota | 209 | 1.02e-49 | NTclustered | gi|33339666|gb|AF280078.1| | 136499 | g79449 | i0 | 85.577 | 100.033653846154 | 208 | 21 | 100 | 6 | 1 | 208 | 1506 | 1704 | Phalansterium solitarium 18S ribosomal RNA gene, partial sequence | blastn | 20807 | 209 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 15482594 | 15482594 | PRJNA1063685_S_NODE_65213_length_263_cov_4.147368_g64670_i0 | PRJNA1063685 | 65213 | 263 | 4.147368 | 10.90757784 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 113 | 1.09e-20 | NTclustered | gi|415339|emb|X65163.1| | 5759 | g64670 | i0 | 78.723 | 2.03422053231939 | 188 | 26 | 70 | 7 | 18 | 200 | 5975 | 6153 | E.histolytica rRNA | blastn | 535 | 113 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 16756414 | 16756414 | PRJNA1063685_S_NODE_28094_length_443_cov_3.013514_g27553_i0 | PRJNA1063685 | 28094 | 443 | 3.013514 | 13.34986702 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 315 | 4.95e-81 | NTclustered | gi|415339|emb|X65163.1| | 5759 | g27553 | i0 | 80.493 | 13.7042889390519 | 446 | 58 | 98 | 22 | 12 | 443 | 5392 | 5822 | E.histolytica rRNA | blastn | 6071 | 315 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 16756603 | 16756603 | PRJNA1063685_S_NODE_4774_length_740_cov_4.035982_g4348_i0 | PRJNA1063685 | 4774 | 740 | 4.035982 | 29.8662668 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 510 | 1.02e-139 | NTclustered | gi|330791897|ref|XM_003283980.1| | 5786 | g4348 | i0 | 80.851 | 46.9716216216216 | 658 | 119 | 89 | 5 | 22 | 677 | 846 | 1498 | Dictyostelium purpureum 26S proteasome ATPase 2 subunit (DICPUDRAFT_96551), mRNA | blastn | 34759 | 510 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 19305145 | 19305145 | PRJNA1063685_S_NODE_22296_length_488_cov_6.927711_g21756_i0 | PRJNA1063685 | 22296 | 488 | 6.927711 | 33.80722968 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 147 | 2.12e-30 | NTclustered | gi|1865795|emb|Y11271.1| | 5759 | g21756 | i0 | 90.909 | 8.67418032786885 | 110 | 8 | 36 | 2 | 356 | 464 | 1093 | 985 | E.histolytica ss1 gene | blastn | 4233 | 147 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 19305561 | 19305561 | PRJNA1063685_S_NODE_78776_length_221_cov_7.141892_g78233_i0 | PRJNA1063685 | 78776 | 221 | 7.141892 | 15.78358132 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 62.1 | 3.25e-5 | NTclustered | gi|831755157|ref|XM_012892876.1| | 1410327 | g78233 | i0 | 91.304 | 0.208144796380091 | 46 | 2 | 20 | 2 | 59 | 103 | 8 | 52 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 46 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum |
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);;