contig_metadata
13 rows where bioproject = "PRJNA1248424", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2327223 | 2327223 | PRJNA1248424_P_NODE_40162_length_372_cov_1.334448_g34102_i0 | PRJNA1248424 | 40162 | 372 | 1.334448 | 4.96414656 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 326 | 1.89e-84 | NTclustered | gi|7274|emb|X55973.1| | 44689 | g34102 | i0 | 84.226 | 87.3118279569892 | 336 | 51 | 90 | 2 | 5 | 339 | 478 | 812 | D. discoideum EF1-I gene for elongation factor 1 alpha | blastn | 32480 | 326 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 6730390 | 6730390 | PRJNA1248424_P_NODE_40506_length_369_cov_1.560811_g34445_i0 | PRJNA1248424 | 40506 | 369 | 1.560811 | 5.75939259 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 285 | 3.18e-72 | NTclustered | gi|330818907|ref|XM_003291484.1| | 5786 | g34445 | i0 | 80.811 | 10.3739837398374 | 370 | 65 | 99 | 5 | 2 | 368 | 10 | 376 | Dictyostelium purpureum ribosomal protein L10E (DICPUDRAFT_92700), mRNA | blastn | 3828 | 285 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 10557564 | 10557564 | PRJNA1248424_P_NODE_81949_length_211_cov_4.391304_g75879_i0 | PRJNA1248424 | 81949 | 211 | 4.391304 | 9.26565144 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 154 | 4.94e-33 | NTclustered | gi|66826022|ref|XM_641274.1| | 352472 | g75879 | i0 | 80.788 | 31.085308056872 | 203 | 33 | 95 | 5 | 6 | 205 | 200 | 1 | Dictyostelium discoideum AX4 S60 ribosomal protein L36a (rpl36a) mRNA, complete cds | blastn | 6559 | 154 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 11831286 | 11831286 | PRJNA1248424_P_NODE_44510_length_340_cov_1.441948_g38446_i0 | PRJNA1248424 | 44510 | 340 | 1.441948 | 4.9026232 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 175 | 2.6e-52 | NR | ABL84200.1 | 5791 | g38446 | i0 | 81.4 | 15.9441176470588 | 113 | 21 | 99.7 | 0 | 1 | 339 | 17 | 129 | ABL84200.1 14-3-3-like protein [Physarum polycephalum] | diamond | 5421 | 176 | 0.994318181818182 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 26661804 | 26661804 | PRJNA1248424_P_NODE_71561_length_249_cov_0.875000_g65492_i0 | PRJNA1248424 | 71561 | 249 | 0.875 | 2.17875 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 42.7 | 0.0424 | NR | XP_020436591.1 | 670386 | g65492 | i0 | 40 | 0.542168674698795 | 45 | 27 | 54.2 | 0 | 249 | 115 | 737 | 781 | XP_020436591.1 hypothetical protein PPL_02511 [Heterostelium album PN500] | diamond | 135 | 42.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 27642499 | 27642499 | PRJNA1248424_P_NODE_77164_length_244_cov_0.900585_g71095_i0 | PRJNA1248424 | 77164 | 244 | 0.900585 | 2.1974274 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 47.4 | 8.47e-4 | NR | XP_012753477.1 | 1410327 | g71095 | i0 | 40 | 0.614754098360656 | 50 | 30 | 61.5 | 0 | 151 | 2 | 232 | 281 | XP_012753477.1 hypothetical protein SAMD00019534_069110 [Acytostelium subglobosum LB1] | diamond | 150 | 47.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 28747383 | 28747383 | PRJNA1248424_P_NODE_70387_length_250_cov_0.870056_g64318_i0 | PRJNA1248424 | 70387 | 250 | 0.870056 | 2.17514 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 95.5 | 1.16e-20 | NR | KAH3744683.1 | 1580589 | g64318 | i0 | 53 | 4.968 | 83 | 39 | 99.6 | 0 | 250 | 2 | 1756 | 1838 | KAH3744683.1 hypothetical protein Pelo_13925 [Pelomyxa schiedti] | diamond | 1242 | 95.5 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 29902230 | 29902230 | PRJNA1248424_P_NODE_23391_length_709_cov_1.573899_g17558_i0 | PRJNA1248424 | 23391 | 709 | 1.573899 | 11.15894391 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 335 | 7.52e-113 | NR | XP_003287614.1 | 5786 | g17558 | i0 | 75 | 4.98448519040903 | 236 | 54 | 99.9 | 4 | 709 | 2 | 60 | 290 | XP_003287614.1 calcium-regulated actin-bundling protein [Dictyostelium purpureum] | diamond | 3534 | 335 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 30755249 | 30755249 | PRJNA1248424_P_NODE_55494_length_287_cov_1.294393_g49426_i0 | PRJNA1248424 | 55494 | 287 | 1.294393 | 3.71490791 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 95.5 | 5.44e-22 | NR | KAF2072988.1 | 133409 | g49426 | i0 | 59.3 | 4.19163763066202 | 81 | 33 | 84.7 | 0 | 2 | 244 | 17 | 97 | KAF2072988.1 hypothetical protein CYY_005700 [Polysphondylium violaceum] | diamond | 1203 | 95.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 30990036 | 30990036 | PRJNA1248424_P_NODE_53054_length_294_cov_2.484163_g46986_i0 | PRJNA1248424 | 53054 | 294 | 2.484163 | 7.30343922 | Entamoeba invadens IP1 | 370355 | Evosea | other_Eukaryota | 42.7 | 0.0241 | NR | XP_004261325.1 | 370355 | g46986 | i0 | 53.3 | 0.306122448979592 | 30 | 14 | 30.6 | 0 | 66 | 155 | 16 | 45 | XP_004261325.1 hypothetical protein EIN_010500 [Entamoeba invadens IP1] | diamond | 90 | 42.7 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 31084699 | 31084699 | PRJNA1248424_P_NODE_55415_length_287_cov_1.439252_g49347_i0 | PRJNA1248424 | 55415 | 287 | 1.439252 | 4.13065324 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 150 | 1.9899999999999992e-43 | NR | PRP80408.1 | 1890364 | g49347 | i0 | 74.7 | 32.7700348432056 | 95 | 24 | 99.3 | 0 | 2 | 286 | 60 | 154 | PRP80408.1 40S ribosomal protein S9 [Planoprotostelium fungivorum] | diamond | 9405 | 150 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31893316 | 31893316 | PRJNA1248424_P_NODE_74897_length_246_cov_0.890173_g68828_i0 | PRJNA1248424 | 74897 | 246 | 0.890173 | 2.18982558 | Acytosteliaceae | 2058183 | Evosea | other_Eukaryota | 105 | 1.37e-24 | NR | XP_020438084.1 | 670386 | g68828 | i0 | 55 | 1.95121951219512 | 80 | 36 | 97.6 | 0 | 3 | 242 | 272 | 351 | XP_020438084.1 carboxylic ester hydrolase [Heterostelium album PN500] | diamond | 480 | 106 | 0.990566037735849 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 32033500 | 32033500 | PRJNA1248424_P_NODE_46858_length_326_cov_0.818182_g40791_i0 | PRJNA1248424 | 46858 | 326 | 0.818182 | 2.66727332 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 110 | 1.44e-25 | NR | PRP74799.1 | 1890364 | g40791 | i0 | 53.7 | 1.98773006134969 | 108 | 47 | 99.4 | 1 | 3 | 326 | 409 | 513 | PRP74799.1 actin binding protein [Planoprotostelium fungivorum] | diamond | 648 | 110 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum |
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);;