contig_metadata
11 rows where bioproject = "PRJNA870096", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4678476 | 4678476 | PRJNA870096_S_NODE_41804_length_274_cov_2.095238_g40140_i0 | PRJNA870096 | 41804 | 274 | 2.095238 | 5.74095212 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 219 | 2.3399999999999994e-52 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g40140 | i0 | 85.577 | 2.97080291970803 | 208 | 30 | 76 | 0 | 67 | 274 | 1 | 208 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 814 | 219 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 11053582 | 11053582 | PRJNA870096_S_NODE_19869_length_406_cov_76.776860_g18213_i0 | PRJNA870096 | 19869 | 406 | 76.77686 | 311.7140516 | Saccamoeba sp. W187G | 1215626 | Tubulinea | other_Eukaryota | 691 | 0 | NTclustered | gi|399764209|gb|JQ271720.1| | 1215626 | g18213 | i0 | 99.475 | 66.8374384236453 | 381 | 1 | 94 | 1 | 26 | 406 | 588 | 967 | Saccamoeba sp. W187G 18S ribosomal RNA gene, partial sequence | blastn | 27136 | 691 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. W187G | ||
| 11053799 | 11053799 | PRJNA870096_S_NODE_42149_length_273_cov_1.560870_g40485_i0 | PRJNA870096 | 42149 | 273 | 1.56087 | 4.2611751 | Copromyxa laresi | 1789826 | Tubulinea | other_Eukaryota | 195 | 3.94e-45 | NTclustered | gi|1042160952|dbj|LC102283.1| | 1789826 | g40485 | i0 | 81.07 | 85.4249084249084 | 243 | 46 | 89 | 0 | 6 | 248 | 515 | 273 | Copromyxa sp. MK-2016 mitochondrial COXI gene, cytochrome oxidase subunit I, partial sequence, strain: ZEB1 | blastn | 23321 | 195 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa laresi | ||
| 12329036 | 12329036 | PRJNA870096_S_NODE_23530_length_372_cov_2.604863_g21867_i0 | PRJNA870096 | 23530 | 372 | 2.604863 | 9.69009036 | root | 1 | Root_unresolved | Root_unresolved | 105 | 2.19e-23 | NR | AKT93973.1 | 5778 | g21867 | i0 | 53.9 | 2.85483870967742 | 89 | 39 | 70.2 | 1 | 262 | 2 | 9 | 97 | AKT93973.1 NADH dehydrogenase subunit 11 [Vermamoeba vermiformis] | diamond | 1062 | 105 | 1 | Eukaryota | Amoebozoa | Tubulinea | Echinamoebida | Vermamoeba | Vermamoeba vermiformis | ||||
| 14878652 | 14878652 | PRJNA870096_S_NODE_87832_length_187_cov_32.840278_g86168_i0 | PRJNA870096 | 87832 | 187 | 32.840278 | 61.41131986 | Saccamoeba sp. W187G | 1215626 | Tubulinea | other_Eukaryota | 340 | 3.0499999999999998e-89 | NTclustered | gi|399764209|gb|JQ271720.1| | 1215626 | g86168 | i0 | 99.465 | 98.9411764705882 | 187 | 1 | 100 | 0 | 1 | 187 | 1127 | 941 | Saccamoeba sp. W187G 18S ribosomal RNA gene, partial sequence | blastn | 18502 | 340 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. W187G | ||
| 17428430 | 17428430 | PRJNA870096_S_NODE_5314_length_810_cov_13.572360_g4132_i0 | PRJNA870096 | 5314 | 810 | 13.57236 | 109.936116 | Copromyxa protea | 931554 | Tubulinea | other_Eukaryota | 431 | 8.949999999999998e-116 | NTclustered | gi|508737347|dbj|AB766053.1| | 931554 | g4132 | i0 | 79.967 | 1.47407407407407 | 599 | 108 | 73 | 11 | 1 | 593 | 797 | 1389 | Copromyxa protea EFL mRNA for elongation factor-like protein, complete cds, strain: ATCC PRA-324 | blastn | 1194 | 431 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Copromyxa | Copromyxa protea | ||
| 18701237 | 18701237 | PRJNA870096_S_NODE_18175_length_426_cov_6.436031_g16523_i0 | PRJNA870096 | 18175 | 426 | 6.436031 | 27.41749206 | Hartmannella cantabrigiensis | 239731 | Tubulinea | other_Eukaryota | 420 | 9.77e-113 | NTclustered | gi|33946358|gb|AY294158.1| | 239731 | g16523 | i0 | 85.969 | 86.31220657277 | 392 | 55 | 92 | 0 | 26 | 417 | 712 | 1103 | Hartmannella cantabrigiensis actin mRNA, complete cds | blastn | 36769 | 420 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Hartmannella | Hartmannella cantabrigiensis | ||
| 19976473 | 19976473 | PRJNA870096_S_NODE_21996_length_385_cov_11.385965_g20336_i0 | PRJNA870096 | 21996 | 385 | 11.385965 | 43.83596525 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 189 | 5.6499999999999985e-56 | NR | AAP88974.1 | 5775 | g20336 | i0 | 78.4 | 0.903896103896104 | 116 | 25 | 90.4 | 0 | 2 | 349 | 275 | 390 | AAP88974.1 S-adenosylmethionine synthetase 2 [Amoeba proteus] | diamond | 348 | 189 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 20363677 | 20363677 | PRJNA870096_S_NODE_4356_length_894_cov_34.159812_g3314_i0 | PRJNA870096 | 4356 | 894 | 34.159812 | 305.38871928 | Saccamoeba | 136463 | Tubulinea | other_Eukaryota | 1218 | 0 | NTclustered | gi|399764206|gb|JQ271717.1| | 1215623 | g3314 | i0 | 98.972 | 59.1733780760626 | 681 | 6 | 76 | 1 | 189 | 869 | 1808 | 1129 | Saccamoeba sp. DP7 18S ribosomal RNA gene, partial sequence | blastn | 52901 | 1218 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Hartmannellidae | Saccamoeba | Saccamoeba sp. DP7 | ||
| 26770365 | 26770365 | PRJNA870096_S_NODE_84361_length_191_cov_1.945946_g82697_i0 | PRJNA870096 | 84361 | 191 | 1.945946 | 3.71675686 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 83.6 | 1.95e-17 | NR | AKN09689.1 | 5775 | g82697 | i0 | 61.9 | 0.989528795811518 | 63 | 24 | 99 | 0 | 190 | 2 | 185 | 247 | AKN09689.1 Tom20 [Amoeba proteus] | diamond | 189 | 83.6 | 1 | Eukaryota | Amoebozoa | Tubulinea | Elardia | Euamoebida | Amoebidae | Amoeba | Amoeba proteus | ||
| 31445650 | 31445650 | PRJNA870096_S_NODE_129056_length_157_cov_1.263158_g127392_i0 | PRJNA870096 | 129056 | 157 | 1.263158 | 1.98315806 | Amoeba proteus | 5775 | Tubulinea | other_Eukaryota | 72.4 | 2.19e-13 | NR | BAF75060.1 | 5775 | g127392 | i0 | 64 | 0.955414012738854 | 50 | 18 | 95.5 | 0 | 4 | 153 | 81 | 130 | BAF75060.1 aquaporin [Amoeba proteus] | diamond | 150 | 72.4 | 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);;