contig_metadata
8 rows where bioproject = "PRJNA509429", 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 485223 | 485223 | PRJNA509429_P_NODE_39201_length_184_cov_1.067114_g38373_i0 | PRJNA509429 | 39201 | 184 | 1.067114 | 1.96348976 | Mastigamoeba balamuthi | 108607 | Evosea | other_Eukaryota | 99 | 1.99e-16 | NTclustered | gi|463171|gb|L23799.1|PMHRRSS | 108607 | g38373 | i0 | 90.667 | 0.407608695652174 | 75 | 6 | 40 | 1 | 32 | 105 | 1174 | 1100 | Phreatamoeba balamuthi ribosomal RNA small subunit gene | blastn | 75 | 99 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Mastigamoebidae | Mastigamoeba | Mastigamoeba balamuthi | |||
| 3036333 | 3036333 | PRJNA509429_P_NODE_38883_length_185_cov_1.066667_g38055_i0 | PRJNA509429 | 38883 | 185 | 1.066667 | 1.97333395 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 285 | 1.43e-72 | NTclustered | gi|414783|emb|X75592.1| | 5791 | g38055 | i0 | 96.512 | 75.1135135135135 | 172 | 6 | 93 | 0 | 13 | 184 | 151 | 322 | P. polycephalum M3C mitochondrial SSU gene for 17S ribosomal RNA(pSSU) | blastn | 13896 | 285 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 3036360 | 3036360 | PRJNA509429_P_NODE_44303_length_168_cov_1.203008_g43475_i0 | PRJNA509429 | 44303 | 168 | 1.203008 | 2.02105344 | Badhamia foliicola | 647245 | Evosea | other_Eukaryota | 311 | 2.11e-80 | NTclustered | gi|1864351373|gb|MT704208.1| | 647245 | g43475 | i0 | 100 | 100.660714285714 | 168 | 0 | 100 | 0 | 1 | 168 | 395 | 228 | Badhamia foliicola voucher MM21366 small subunit ribosomal RNA gene, partial sequence | blastn | 16911 | 311 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Badhamia | Badhamia foliicola | ||
| 5589048 | 5589048 | PRJNA509429_P_NODE_42305_length_174_cov_1.151079_g41477_i0 | PRJNA509429 | 42305 | 174 | 1.151079 | 2.00287746 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 292 | 7.92e-75 | NTclustered | gi|3221|emb|V01159.1| | 5791 | g41477 | i0 | 98.204 | 16.867816091954 | 167 | 3 | 96 | 0 | 8 | 174 | 1624 | 1790 | Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA | blastn | 2935 | 292 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 6863046 | 6863046 | PRJNA509429_P_NODE_42286_length_174_cov_1.151079_g41458_i0 | PRJNA509429 | 42286 | 174 | 1.151079 | 2.00287746 | Mastigamoeba balamuthi | 108607 | Evosea | other_Eukaryota | 91.6 | 3.1e-14 | NTclustered | gi|19911164|dbj|AB066364.1| | 108607 | g41458 | i0 | 77.273 | 1.01149425287356 | 176 | 26 | 100 | 13 | 1 | 174 | 2125 | 1962 | Mastigamoeba balamuthi gene for LSU rRNA, partial sequence, clone:MbR2 | blastn | 176 | 91.6 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Mastigamoebidae | Mastigamoeba | Mastigamoeba balamuthi | |||
| 14514232 | 14514232 | PRJNA509429_P_NODE_50372_length_153_cov_1.355932_g49544_i0 | PRJNA509429 | 50372 | 153 | 1.355932 | 2.07457596 | Mastigamoeba balamuthi | 108607 | Evosea | other_Eukaryota | 99 | 1.59e-16 | NTclustered | gi|19911164|dbj|AB066364.1| | 108607 | g49544 | i0 | 95.161 | 1.2156862745098 | 62 | 3 | 41 | 0 | 92 | 153 | 1010 | 949 | Mastigamoeba balamuthi gene for LSU rRNA, partial sequence, clone:MbR2 | blastn | 186 | 99 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Mastigamoebidae | Mastigamoeba | Mastigamoeba balamuthi | |||
| 15787998 | 15787998 | PRJNA509429_P_NODE_46293_length_162_cov_6.535433_g45465_i0 | PRJNA509429 | 46293 | 162 | 6.535433 | 10.58740146 | Phalansterium solitarium | 136499 | Evosea | other_Eukaryota | 58.4 | 2.9e-4 | NTclustered | gi|300078500|gb|GU001162.1| | 136499 | g45465 | i0 | 100 | 0.191358024691358 | 31 | 0 | 19 | 0 | 22 | 52 | 4802 | 4772 | Phalansterium solitarium 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 31 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Phalansterium | Phalansterium solitarium | ||||
| 18336863 | 18336863 | PRJNA509429_P_NODE_18555_length_317_cov_1.460993_g17727_i0 | PRJNA509429 | 18555 | 317 | 1.460993 | 4.63134781 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 436 | 7.019999999999999e-118 | NTclustered | gi|3221|emb|V01159.1| | 5791 | g17727 | i0 | 91.562 | 25.0504731861199 | 320 | 21 | 100 | 6 | 1 | 317 | 1265 | 949 | Physarum polycephalum gene encoding 5.8S rRNA and 26S rRNA | blastn | 7941 | 436 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum |
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);;