contig_metadata
11 rows where bioproject = "PRJNA949785" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 4761635 | 4761635 | PRJNA949785_P_NODE_3084_length_671_cov_6.461538_g2903_i0 | PRJNA949785 | 3084 | 671 | 6.461538 | 43.35691998 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 310 | 2.3999999999999998e-104 | NR | XP_020430508.1 | 670386 | g2903 | i0 | 74.6 | 6.03576751117735 | 193 | 49 | 86.3 | 0 | 634 | 56 | 1 | 193 | XP_020430508.1 Rho GTPase [Heterostelium album PN500] | diamond | 4050 | 310 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 17839467 | 17839467 | PRJNA949785_P_NODE_6314_length_438_cov_2.016438_g6117_i0 | PRJNA949785 | 6314 | 438 | 2.016438 | 8.83199844 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 130 | 1.48e-33 | NR | XP_646604.1 | 352472 | g6117 | i0 | 44.4 | 1.94520547945205 | 142 | 79 | 97.3 | 0 | 435 | 10 | 17 | 158 | XP_646604.1 hypothetical protein DDB_G0270184 [Dictyostelium discoideum AX4] | diamond | 852 | 130 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 26899059 | 26899059 | PRJNA949785_P_NODE_17641_length_245_cov_0.895349_g17444_i0 | PRJNA949785 | 17641 | 245 | 0.895349 | 2.19360505 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 47.4 | 6.68e-4 | NR | KAH3744612.1 | 1580589 | g17444 | i0 | 57.9 | 0.46530612244898 | 38 | 16 | 46.5 | 0 | 119 | 232 | 4 | 41 | KAH3744612.1 hypothetical protein Pelo_13992 [Pelomyxa schiedti] | diamond | 114 | 47.4 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 27341767 | 27341767 | PRJNA949785_P_NODE_13823_length_271_cov_0.974747_g13626_i0 | PRJNA949785 | 13823 | 271 | 0.974747 | 2.64156437 | Entamoeba invadens IP1 | 370355 | Evosea | other_Eukaryota | 45.1 | 0.00515 | NR | XP_004253729.1 | 370355 | g13626 | i0 | 54.3 | 0.387453874538745 | 35 | 16 | 38.7 | 0 | 166 | 270 | 4 | 38 | XP_004253729.1 guanylate kinase, putative [Entamoeba invadens IP1] | diamond | 105 | 45.1 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 28099357 | 28099357 | PRJNA949785_P_NODE_8285_length_368_cov_1.305085_g8088_i0 | PRJNA949785 | 8285 | 368 | 1.305085 | 4.8027128 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 65.9 | 8.09e-10 | NR | XP_004360639.1 | 261658 | g8088 | i0 | 54.7 | 0.432065217391304 | 53 | 24 | 43.2 | 0 | 281 | 123 | 239 | 291 | XP_004360639.1 general transcription factor IIH [Cavenderia fasciculata] | diamond | 159 | 65.9 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 28478340 | 28478340 | PRJNA949785_P_NODE_11686_length_299_cov_1.362832_g11489_i0 | PRJNA949785 | 11686 | 299 | 1.362832 | 4.07486768 | Entamoeba invadens IP1 | 370355 | Evosea | other_Eukaryota | 80.5 | 9.94e-16 | NR | XP_004256870.1 | 370355 | g11489 | i0 | 59.6 | 1.53511705685619 | 47 | 19 | 47.2 | 0 | 1 | 141 | 220 | 266 | XP_004256870.1 ariadne RING finger, putative [Entamoeba invadens IP1] | diamond | 459 | 80.5 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 28484967 | 28484967 | PRJNA949785_P_NODE_7006_length_409_cov_0.916667_g6809_i0 | PRJNA949785 | 7006 | 409 | 0.916667 | 3.74916803 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 132 | 1.29e-34 | NR | XP_003284501.1 | 5786 | g6809 | i0 | 47.8 | 2.9559902200489 | 134 | 69 | 98.3 | 1 | 5 | 406 | 136 | 268 | XP_003284501.1 uncharacterized protein DICPUDRAFT_96732 [Dictyostelium purpureum] | diamond | 1209 | 133 | 0.992481203007519 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 28699520 | 28699520 | PRJNA949785_P_NODE_8727_length_356_cov_1.392226_g8530_i0 | PRJNA949785 | 8727 | 356 | 1.392226 | 4.95632456 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 80.5 | 7.43e-15 | NR | XP_012758213.1 | 1410327 | g8530 | i0 | 47.4 | 1.43258426966292 | 76 | 40 | 64 | 0 | 356 | 129 | 400 | 475 | XP_012758213.1 hypothetical protein SAMD00019534_007920, partial [Acytostelium subglobosum LB1] | diamond | 510 | 80.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 29456775 | 29456775 | PRJNA949785_P_NODE_16530_length_248_cov_0.880000_g16333_i0 | PRJNA949785 | 16530 | 248 | 0.88 | 2.1824 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 66.6 | 6.94e-11 | NR | XP_003292601.1 | 5786 | g16333 | i0 | 37.5 | 2.92741935483871 | 80 | 49 | 96.8 | 1 | 7 | 246 | 38 | 116 | XP_003292601.1 uncharacterized protein DICPUDRAFT_40821 [Dictyostelium purpureum] | diamond | 726 | 66.6 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 31384457 | 31384457 | PRJNA949785_P_NODE_1136_length_1103_cov_4.973786_g1022_i0 | PRJNA949785 | 1136 | 1103 | 4.973786 | 54.86085958 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 51.2 | 0.0074 | NR | XP_641817.1 | 352472 | g1022 | i0 | 22.2 | 0.601087941976428 | 221 | 150 | 59.3 | 4 | 753 | 100 | 960 | 1161 | XP_641817.1 hypothetical protein DDB_G0279365 [Dictyostelium discoideum AX4] | diamond | 663 | 51.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 31454340 | 31454340 | PRJNA949785_P_NODE_6436_length_432_cov_1.462396_g6239_i0 | PRJNA949785 | 6436 | 432 | 1.462396 | 6.31755072 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 83.2 | 2.16e-15 | NR | KYR02016.1 | 361077 | g6239 | i0 | 29.7 | 2.86805555555556 | 138 | 97 | 95.8 | 0 | 18 | 431 | 108 | 245 | KYR02016.1 oligomeric Golgi complex component [Tieghemostelium lacteum] | diamond | 1239 | 84 | 0.990476190476191 | 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);;