contig_metadata
11 rows where analysis = "blastn", bioproject = "PRJNA670521" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3189094 | 3189094 | PRJNA670521_P_NODE_57503_length_278_cov_1.931707_g56758_i0 | PRJNA670521 | 57503 | 278 | 1.931707 | 5.37014546 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 62.1 | 4.25e-5 | NTclustered | gi|66805988|ref|XM_631624.1| | 352472 | g56758 | i0 | 97.222 | 0.262589928057554 | 36 | 1 | 13 | 0 | 138 | 173 | 1174 | 1139 | Dictyostelium discoideum AX4 hypothetical protein (gxcH) mRNA, complete cds | blastn | 73 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 4466188 | 4466188 | PRJNA670521_P_NODE_63484_length_265_cov_1.333333_g62739_i0 | PRJNA670521 | 63484 | 265 | 1.333333 | 3.53333245 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 58.4 | 5.21e-4 | NTclustered | gi|831761496|ref|XM_012894817.1| | 1410327 | g62739 | i0 | 88.235 | 0.192452830188679 | 51 | 3 | 18 | 2 | 26 | 73 | 261 | 211 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 51 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 5741681 | 5741681 | PRJNA670521_P_NODE_57305_length_279_cov_1.169903_g56560_i0 | PRJNA670521 | 57305 | 279 | 1.169903 | 3.26402937 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 209 | 1.44e-49 | NTclustered | gi|831768659|ref|XM_012897017.1| | 1410327 | g56560 | i0 | 84.018 | 2.0179211469534 | 219 | 33 | 78 | 2 | 3 | 220 | 643 | 860 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 563 | 209 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 5742000 | 5742000 | PRJNA670521_P_NODE_9265_length_587_cov_1.299611_g8533_i0 | PRJNA670521 | 9265 | 587 | 1.299611 | 7.62871657 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 431 | 6.379999999999998e-116 | NTclustered | gi|167395203|ref|XM_001741218.1| | 370354 | g8533 | i0 | 80.824 | 83.4599659284497 | 558 | 99 | 94 | 4 | 9 | 559 | 520 | 1076 | Entamoeba dispar SAW760 vacuolar ATP synthase subunit B, putative (EDI_202200), partial mRNA | blastn | 48991 | 431 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 7016806 | 7016806 | PRJNA670521_P_NODE_65806_length_260_cov_1.235294_g65061_i0 | PRJNA670521 | 65806 | 260 | 1.235294 | 3.2117644 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.007 | NTclustered | gi|66826366|ref|XM_641446.1| | 352472 | g65061 | i0 | 100 | 0.111538461538462 | 29 | 0 | 11 | 0 | 221 | 249 | 839 | 811 | Dictyostelium discoideum AX4 ZZ-type zinc finger-containing protein (DDB_G0270098) mRNA, complete cds | blastn | 29 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 8291421 | 8291421 | PRJNA670521_P_NODE_54067_length_286_cov_1.441315_g53322_i0 | PRJNA670521 | 54067 | 286 | 1.441315 | 4.1221609 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 75 | 5.64e-9 | NTclustered | gi|470241794|ref|XM_004352548.1| | 261658 | g53322 | i0 | 87.143 | 0.34965034965035 | 70 | 4 | 24 | 4 | 216 | 284 | 925 | 990 | Cavenderia fasciculata uncharacterized protein (DFA_09172), partial mRNA | blastn | 100 | 75 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 9566660 | 9566660 | PRJNA670521_P_NODE_31728_length_353_cov_1.100000_g30983_i0 | PRJNA670521 | 31728 | 353 | 1.1 | 3.883 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 187 | 8.77e-43 | NTclustered | gi|330798956|ref|XM_003287467.1| | 5786 | g30983 | i0 | 79.693 | 7.87818696883853 | 261 | 51 | 74 | 2 | 3 | 262 | 383 | 124 | Dictyostelium purpureum vacuolar H+-ATPase A subunit (DICPUDRAFT_47400), mRNA | blastn | 2781 | 187 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 12117359 | 12117359 | PRJNA670521_P_NODE_35130_length_340_cov_1.153558_g34385_i0 | PRJNA670521 | 35130 | 340 | 1.153558 | 3.9220972 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 180 | 1.4099999999999999e-40 | NTclustered | gi|66810084|ref|XM_633674.1| | 352472 | g34385 | i0 | 77.46 | 14.0352941176471 | 315 | 61 | 91 | 10 | 32 | 340 | 358 | 668 | Dictyostelium discoideum AX4 hypothetical protein (phbB) mRNA, complete cds | blastn | 4772 | 180 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 16467818 | 16467818 | PRJNA670521_P_NODE_19013_length_430_cov_3.680672_g18271_i0 | PRJNA670521 | 19013 | 430 | 3.680672 | 15.8268896 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 405 | 2.76e-108 | NTclustered | gi|511084914|dbj|AK419690.1| | 5759 | g18271 | i0 | 86.523 | 86.2279069767442 | 371 | 46 | 86 | 4 | 7 | 375 | 401 | 33 | Entamoeba histolytica cDNA clone: Xeh-005H14, actin, putative, complete cds, strain: HM-1:IMSS | blastn | 37078 | 405 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 17216133 | 17216133 | PRJNA670521_P_NODE_4414_length_835_cov_2.809711_g3777_i0 | PRJNA670521 | 4414 | 835 | 2.809711 | 23.46108685 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 128 | 1.36e-24 | NTclustered | gi|1540352513|gb|MK002477.1| | 5786 | g3777 | i0 | 94.118 | 9.71137724550898 | 85 | 4 | 10 | 1 | 685 | 769 | 1861 | 1778 | Dictyostelium purpureum strain TNS-C-7 18S ribosomal RNA gene, internal transcribed spacer 1, 5.8S ribosomal RNA gene, internal transcribed spacer 2, and 28S ribosomal RNA gene, region | blastn | 8109 | 128 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 23590992 | 23590992 | PRJNA670521_P_NODE_40459_length_322_cov_1.236948_g39714_i0 | PRJNA670521 | 40459 | 322 | 1.236948 | 3.98297256 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 239 | 2.1600000000000003e-58 | NTclustered | gi|183235763|ref|XM_001914269.1| | 294381 | g39714 | i0 | 85.652 | 37.5124223602485 | 230 | 30 | 71 | 3 | 1 | 228 | 101 | 329 | Entamoeba histolytica HM-1:IMSS chaperone clpB, putative (EHI_155060), partial mRNA | blastn | 12079 | 239 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica |
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);;