contig_metadata
15 rows where bioproject = "PRJNA559720" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1819197 | 1819197 | PRJNA559720_P_NODE_14702_length_247_cov_0.885057_g14563_i0 | PRJNA559720 | 14702 | 247 | 0.885057 | 2.18609079 | Echinostelium bisporum | 1973072 | Evosea | other_Eukaryota | 383 | 6.97e-102 | NTclustered | gi|1465309735|gb|MH809395.1| | 1973072 | g14563 | i0 | 95.455 | 52.2307692307692 | 242 | 7 | 98 | 3 | 1 | 242 | 1305 | 1542 | Echinostelium bisporum isolate Nx14-A1 small subunit ribosomal RNA gene, partial sequence | blastn | 12901 | 383 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Echinosteliales | Echinosteliidae | Echinostelium | Echinostelium bisporum | ||
| 10747836 | 10747836 | PRJNA559720_P_NODE_13089_length_257_cov_1.010870_g12950_i0 | PRJNA559720 | 13089 | 257 | 1.01087 | 2.5979359 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 104 | 6.729999999999999e-24 | NR | XP_003289202.1 | 5786 | g12950 | i0 | 55.6 | 18.0466926070039 | 81 | 36 | 94.6 | 0 | 248 | 6 | 76 | 156 | XP_003289202.1 UDP-glucose pyrophosphorylase 2 [Dictyostelium purpureum] | diamond | 4638 | 105 | 0.990476190476191 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 22220627 | 22220627 | PRJNA559720_P_NODE_198_length_1553_cov_3.945270_g175_i0 | PRJNA559720 | 198 | 1553 | 3.94527 | 61.2700431 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 302 | 9.56e-91 | NR | KAF2076314.1 | 133409 | g175 | i0 | 48.8 | 4.02382485511912 | 336 | 165 | 64.1 | 3 | 135 | 1130 | 126 | 458 | KAF2076314.1 hypothetical protein CYY_002370 [Polysphondylium violaceum] | diamond | 6249 | 302 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 22807498 | 22807498 | PRJNA559720_P_NODE_10218_length_304_cov_0.909091_g10079_i0 | PRJNA559720 | 10218 | 304 | 0.909091 | 2.76363664 | Entamoeba | 5758 | Evosea | other_Eukaryota | 147 | 1.26e-30 | NTclustered | gi|54401028|gb|AY641405.1| | 5759 | g10079 | i0 | 77.778 | 2.34210526315789 | 252 | 46 | 81 | 8 | 58 | 304 | 869 | 623 | Entamoeba histolytica vacuolar ATPase subunit B gene, complete cds | blastn | 712 | 147 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 27141786 | 27141786 | PRJNA559720_P_NODE_12522_length_266_cov_0.839378_g12383_i0 | PRJNA559720 | 12522 | 266 | 0.839378 | 2.23274548 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 64.7 | 3.63e-11 | NR | AAG45131.1 | 44689 | g12383 | i0 | 41.1 | 1.37593984962406 | 73 | 37 | 75.6 | 1 | 207 | 7 | 22 | 94 | AAG45131.1 unknown, partial [Dictyostelium discoideum] | diamond | 366 | 64.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 27268559 | 27268559 | PRJNA559720_P_NODE_6003_length_419_cov_3.332370_g5864_i0 | PRJNA559720 | 6003 | 419 | 3.33237 | 13.9626303 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 45.8 | 0.00299 | NR | KYQ92517.1 | 361077 | g5864 | i0 | 34 | 0.379474940334129 | 53 | 35 | 37.9 | 0 | 142 | 300 | 40 | 92 | KYQ92517.1 cytochrome c oxidase subunit VIb [Tieghemostelium lacteum] | diamond | 159 | 45.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 27489825 | 27489825 | PRJNA559720_P_NODE_2003_length_714_cov_1.992200_g1891_i0 | PRJNA559720 | 2003 | 714 | 1.9922 | 14.224308 | Entamoeba dispar SAW76 | 46681 | Evosea | other_Eukaryota | 51.6 | 4.72e-4 | NR | XP_001734015.1 | 370354 | g1891 | i0 | 27.2 | 0.710084033613445 | 169 | 97 | 63.9 | 5 | 707 | 252 | 30 | 189 | XP_001734015.1 uncharacterized protein EDI_298050 [Entamoeba dispar SAW760] | diamond | 507 | 51.6 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 27647776 | 27647776 | PRJNA559720_P_NODE_12584_length_265_cov_1.020833_g12445_i0 | PRJNA559720 | 12584 | 265 | 1.020833 | 2.70520745 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 70.9 | 6.18e-12 | NR | XP_003287385.1 | 5786 | g12445 | i0 | 53.4 | 0.656603773584906 | 58 | 27 | 65.7 | 0 | 2 | 175 | 485 | 542 | XP_003287385.1 uncharacterized protein DICPUDRAFT_32400 [Dictyostelium purpureum] | diamond | 174 | 70.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 27963342 | 27963342 | PRJNA559720_P_NODE_13365_length_252_cov_2.715084_g13226_i0 | PRJNA559720 | 13365 | 252 | 2.715084 | 6.84201168 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 62.8 | 9.55e-10 | NR | XP_004359634.1 | 261658 | g13226 | i0 | 53.7 | 0.642857142857143 | 54 | 25 | 64.3 | 0 | 206 | 45 | 136 | 189 | XP_004359634.1 DJ-1/ThiJ/PfpI family protein [Cavenderia fasciculata] | diamond | 162 | 62.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 29415647 | 29415647 | PRJNA559720_P_NODE_16169_length_242_cov_0.911243_g16030_i0 | PRJNA559720 | 16169 | 242 | 0.911243 | 2.20520806 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 96.3 | 9.51e-22 | NR | XP_003290573.1 | 5786 | g16030 | i0 | 59 | 1.99586776859504 | 78 | 29 | 96.7 | 1 | 234 | 1 | 194 | 268 | XP_003290573.1 uncharacterized protein DICPUDRAFT_155103 [Dictyostelium purpureum] | diamond | 483 | 96.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 29713575 | 29713575 | PRJNA559720_P_NODE_8630_length_339_cov_0.778195_g8491_i0 | PRJNA559720 | 8630 | 339 | 0.778195 | 2.63808105 | root | 1 | Root_unresolved | Root_unresolved | 75.5 | 3.65e-13 | NR | XP_642437.1 | 352472 | g8491 | i0 | 44.7 | 9.53982300884956 | 85 | 34 | 75.2 | 2 | 8 | 262 | 291 | 362 | XP_642437.1 hypothetical protein DDB_G0278551 [Dictyostelium discoideum AX4] | diamond | 3234 | 75.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 31546896 | 31546896 | PRJNA559720_P_NODE_12436_length_267_cov_1.159794_g12297_i0 | PRJNA559720 | 12436 | 267 | 1.159794 | 3.09664998 | root | 1 | Root_unresolved | Root_unresolved | 94.7 | 2.61e-20 | NR | PRP82844.1 | 1890364 | g12297 | i0 | 65.2 | 4.73033707865169 | 66 | 23 | 74.2 | 0 | 267 | 70 | 417 | 482 | PRP82844.1 hypothetical protein PROFUN_04707 [Planoprotostelium fungivorum] | diamond | 1263 | 95.1 | 0.995793901156677 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31596201 | 31596201 | PRJNA559720_P_NODE_6416_length_404_cov_1.344411_g6277_i0 | PRJNA559720 | 6416 | 404 | 1.344411 | 5.43142044 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 104 | 1.29e-23 | NR | XP_003293769.1 | 5786 | g6277 | i0 | 39.3 | 0.905940594059406 | 122 | 70 | 89.9 | 2 | 39 | 401 | 4 | 122 | XP_003293769.1 uncharacterized protein DICPUDRAFT_51128 [Dictyostelium purpureum] | diamond | 366 | 104 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 31912272 | 31912272 | PRJNA559720_P_NODE_2137_length_695_cov_2.073955_g2025_i0 | PRJNA559720 | 2137 | 695 | 2.073955 | 14.41398725 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 118 | 8.69e-29 | NR | KAF2076370.1 | 133409 | g2025 | i0 | 34.8 | 0.807194244604317 | 187 | 120 | 79.9 | 1 | 629 | 75 | 8 | 194 | KAF2076370.1 hypothetical protein CYY_002327 [Polysphondylium violaceum] | diamond | 561 | 118 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 32608172 | 32608172 | PRJNA559720_P_NODE_6300_length_408_cov_5.513433_g6161_i0 | PRJNA559720 | 6300 | 408 | 5.513433 | 22.49480664 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 85.5 | 1.27e-17 | NR | KYR00502.1 | 361077 | g6161 | i0 | 46.6 | 0.647058823529412 | 88 | 46 | 64.7 | 1 | 140 | 403 | 79 | 165 | KYR00502.1 succinate dehydrogenase [Tieghemostelium lacteum] | diamond | 264 | 85.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum |
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);;