contig_metadata
11 rows where bioproject = "PRJNA478247" and tax_phylum = "Tubulinea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 447830 | 447830 | PRJNA478247_P_NODE_281_length_931_cov_19.780488_g124_i2 | PRJNA478247 | 281 | 931 | 19.780488 | 184.15634328 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 737 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g124 | i2 | 81.579 | 7.17615467239527 | 912 | 151 | 97 | 15 | 4 | 902 | 908 | 1 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 6681 | 737 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 4274750 | 4274750 | PRJNA478247_P_NODE_424_length_714_cov_15.537226_g190_i3 | PRJNA478247 | 424 | 714 | 15.537226 | 110.93579364 | Hartmannella cantabrigiensis | 239731 | Tubulinea | other_Eukaryota | 843 | 0 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g190 | i3 | 88.352 | 95.1232492997199 | 704 | 78 | 98 | 4 | 13 | 714 | 1149 | 448 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 67918 | 843 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 5551422 | 5551422 | PRJNA478247_P_NODE_685_length_514_cov_9.577320_g580_i0 | PRJNA478247 | 685 | 514 | 9.57732 | 49.2274248 | Amoeba leningradensis | 160820 | Tubulinea | other_Eukaryota | 580 | 5.19e-161 | NTclustered | gi|17897590|emb|AJ314605.1| | 160820 | g580 | i0 | 87.072 | 59.0622568093385 | 526 | 52 | 100 | 13 | 1 | 514 | 1779 | 1258 | Amoeba leningradensis partial 16S rRNA gene, strain CCAP 1503/6 | blastn | 30358 | 580 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba leningradensis | ||
| 9375579 | 9375579 | PRJNA478247_P_NODE_168_length_1158_cov_18.891940_g124_i0 | PRJNA478247 | 168 | 1158 | 18.89194 | 218.7686652 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 909 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g124 | i0 | 81.868 | 2.44905008635579 | 1103 | 179 | 94 | 16 | 71 | 1158 | 1385 | 289 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2836 | 909 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 9375581 | 9375581 | PRJNA478247_P_NODE_248_length_993_cov_13.726141_g190_i0 | PRJNA478247 | 248 | 993 | 13.726141 | 136.30058013 | Hartmannella cantabrigiensis | 239731 | Tubulinea | other_Eukaryota | 848 | 0 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g190 | i0 | 88.494 | 78.2839879154078 | 704 | 77 | 97 | 4 | 1 | 702 | 448 | 1149 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 77736 | 848 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 13201396 | 13201396 | PRJNA478247_P_NODE_291_length_899_cov_19.770115_g124_i3 | PRJNA478247 | 291 | 899 | 19.770115 | 177.73333385 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 710 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g124 | i3 | 81.078 | 3.29477196885428 | 909 | 155 | 99 | 15 | 4 | 899 | 908 | 4 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2962 | 710 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 18299343 | 18299343 | PRJNA478247_P_NODE_175_length_1144_cov_18.513004_g124_i1 | PRJNA478247 | 175 | 1144 | 18.513004 | 211.78876576 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 887 | 0 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g124 | i1 | 81.545 | 2.45979020979021 | 1100 | 182 | 95 | 19 | 60 | 1144 | 1382 | 289 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 2814 | 887 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 24673870 | 24673870 | PRJNA478247_P_NODE_600_length_569_cov_2.479630_g497_i0 | PRJNA478247 | 600 | 569 | 2.47963 | 14.1090947 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 296 | 4.15e-100 | NR | AAW58116.1 | 5775 | g497 | i0 | 80.2 | 0.880492091388401 | 167 | 33 | 88 | 0 | 502 | 2 | 1 | 167 | AAW58116.1 peroxiredoxin, partial [Amoeba proteus] | diamond | 501 | 296 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 27613518 | 27613518 | PRJNA478247_P_NODE_1604_length_290_cov_2.172414_g1498_i0 | PRJNA478247 | 1604 | 290 | 2.172414 | 6.3000006 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 155 | 3.77e-43 | NR | AAD37351.1 | 5775 | g1498 | i0 | 75.3 | 0.962068965517241 | 93 | 23 | 96.2 | 0 | 10 | 288 | 90 | 182 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 279 | 155 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 27960668 | 27960668 | PRJNA478247_P_NODE_825_length_459_cov_2.586047_g720_i0 | PRJNA478247 | 825 | 459 | 2.586047 | 11.86995573 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 104 | 3.33e-23 | NR | AAD37351.1 | 5775 | g720 | i0 | 81.3 | 0.418300653594771 | 64 | 12 | 41.8 | 0 | 266 | 457 | 6 | 69 | AAD37351.1 pepstatin-insensitive carboxyl proteinase 1, partial [Amoeba proteus] | diamond | 192 | 104 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 32888709 | 32888709 | PRJNA478247_P_NODE_2160_length_232_cov_1.487685_g2054_i0 | PRJNA478247 | 2160 | 232 | 1.487685 | 3.4514292 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 127 | 5.34e-33 | NR | AAP88974.1 | 5775 | g2054 | i0 | 77.6 | 0.982758620689655 | 76 | 17 | 98.3 | 0 | 230 | 3 | 180 | 255 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 228 | 127 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus |
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);;