contig_metadata
7 rows where analysis = "blastn", bioproject = "PRJNA870096" 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 | ||
| 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 | ||
| 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 |
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);;