contig_metadata
11 rows where bioproject = "PRJNA508758" and tax_clade = "Amoebozoa"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1759743 | 1759743 | PRJNA508758_P_NODE_36502_length_341_cov_1.970149_g35454_i0 | PRJNA508758 | 36502 | 341 | 1.970149 | 6.71820809 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 76.8 | 1.91e-9 | NTclustered | gi|330792832|ref|XM_003284443.1| | 5786 | g35454 | i0 | 88.889 | 2 | 63 | 6 | 18 | 1 | 8 | 70 | 1653 | 1714 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_52984), mRNA | blastn | 682 | 76.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 13238832 | 13238832 | PRJNA508758_P_NODE_79711_length_247_cov_0.885057_g78663_i0 | PRJNA508758 | 79711 | 247 | 0.885057 | 2.18609079 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 99 | 3.71e-23 | NR | PRP76790.1 | 1890364 | g78663 | i0 | 73.8 | 0.740890688259109 | 61 | 16 | 74.1 | 0 | 244 | 62 | 197 | 257 | PRP76790.1 hypothetical protein PROFUN_14840 [Planoprotostelium fungivorum] | diamond | 183 | 99 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 14513431 | 14513431 | PRJNA508758_P_NODE_30852_length_366_cov_2.156997_g29804_i0 | PRJNA508758 | 30852 | 366 | 2.156997 | 7.89460902 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 58.4 | 7.47e-4 | NTclustered | gi|470236295|ref|XM_004350051.1| | 261658 | g29804 | i0 | 89.583 | 0.131147540983607 | 48 | 1 | 12 | 3 | 149 | 193 | 66 | 20 | Cavenderia fasciculata uncharacterized protein (DFA_11158), partial mRNA | blastn | 48 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 15787141 | 15787141 | PRJNA508758_P_NODE_20233_length_447_cov_2.740642_g19186_i0 | PRJNA508758 | 20233 | 447 | 2.740642 | 12.25066974 | Mastigamoeba balamuthi | 108607 | Evosea | other_Eukaryota | 132 | 5.4e-26 | NTclustered | gi|19911164|dbj|AB066364.1| | 108607 | g19186 | i0 | 96.25 | 16.7852348993289 | 80 | 3 | 18 | 0 | 1 | 80 | 1622 | 1701 | Mastigamoeba balamuthi gene for LSU rRNA, partial sequence, clone:MbR2 | blastn | 7503 | 132 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Mastigamoebidae | Mastigamoeba | Mastigamoeba balamuthi | |||
| 17061906 | 17061906 | PRJNA508758_P_NODE_35514_length_345_cov_1.757353_g34466_i0 | PRJNA508758 | 35514 | 345 | 1.757353 | 6.06286785 | Endolimax piscium | 1284676 | Evosea | other_Eukaryota | 405 | 2.18e-108 | NTclustered | gi|443299289|gb|JX101954.1| | 1284676 | g34466 | i0 | 91.611 | 53.0608695652174 | 298 | 17 | 86 | 5 | 1 | 297 | 1917 | 1627 | Endolimax piscium clone PM1 18S ribosomal RNA gene, partial sequence | blastn | 18306 | 405 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Endolimax | Endolimax piscium | |||
| 22161578 | 22161578 | PRJNA508758_P_NODE_70998_length_256_cov_1.431694_g69950_i0 | PRJNA508758 | 70998 | 256 | 1.431694 | 3.66513664 | Mastigamoeba balamuthi | 108607 | Evosea | other_Eukaryota | 148 | 2.68e-39 | NR | AAN33185.1 | 108607 | g69950 | i0 | 81 | 3.8203125 | 84 | 16 | 98.4 | 0 | 254 | 3 | 822 | 905 | AAN33185.1 putative pyruvate phosphate dikinase [Mastigamoeba balamuthi] | diamond | 978 | 148 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Mastigamoebidae | Mastigamoeba | Mastigamoeba balamuthi | |||
| 28056154 | 28056154 | PRJNA508758_P_NODE_78665_length_248_cov_0.880000_g77617_i0 | PRJNA508758 | 78665 | 248 | 0.88 | 2.1824 | Entamoeba invadens IP1 | 370355 | Evosea | other_Eukaryota | 45.4 | 0.00439 | NR | XP_004256767.1 | 370355 | g77617 | i0 | 38.7 | 0.75 | 62 | 37 | 75 | 1 | 63 | 248 | 34 | 94 | XP_004256767.1 hypothetical protein EIN_403100 [Entamoeba invadens IP1] | diamond | 186 | 45.4 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 28403582 | 28403582 | PRJNA508758_P_NODE_73946_length_251_cov_0.865169_g72898_i0 | PRJNA508758 | 73946 | 251 | 0.865169 | 2.17157419 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 102 | 4.13e-25 | NR | PRP74751.1 | 1890364 | g72898 | i0 | 49.4 | 0.920318725099602 | 77 | 39 | 92 | 0 | 238 | 8 | 106 | 182 | PRP74751.1 glutathione S transferase D8-like, partial [Planoprotostelium fungivorum] | diamond | 231 | 102 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28688007 | 28688007 | PRJNA508758_P_NODE_79807_length_247_cov_0.885057_g78759_i0 | PRJNA508758 | 79807 | 247 | 0.885057 | 2.18609079 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 127 | 3.07e-33 | NR | PRP85821.1 | 1890364 | g78759 | i0 | 77.5 | 0.97165991902834 | 80 | 18 | 97.2 | 0 | 3 | 242 | 11 | 90 | PRP85821.1 phosphoserine aminotransferase-like [Planoprotostelium fungivorum] | diamond | 240 | 127 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 29792677 | 29792677 | PRJNA508758_P_NODE_63351_length_271_cov_1.212121_g62303_i0 | PRJNA508758 | 63351 | 271 | 1.212121 | 3.28484791 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 74.3 | 4.01e-13 | NR | KAF2074433.1 | 133409 | g62303 | i0 | 47.7 | 0.974169741697417 | 88 | 45 | 97.4 | 1 | 267 | 4 | 324 | 410 | KAF2074433.1 hypothetical protein CYY_004251 [Polysphondylium violaceum] | diamond | 264 | 74.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 31372922 | 31372922 | PRJNA508758_P_NODE_74096_length_251_cov_0.865169_g73048_i0 | PRJNA508758 | 74096 | 251 | 0.865169 | 2.17157419 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 79.7 | 4.04e-15 | NR | KAH3759770.1 | 1580589 | g73048 | i0 | 39 | 0.9800796812749 | 82 | 50 | 98 | 0 | 1 | 246 | 1886 | 1967 | KAH3759770.1 alpha-actinin A [Pelomyxa schiedti] | diamond | 246 | 79.7 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti |
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);;