contig_metadata
18 rows where analysis = "diamond", bioproject = "PRJNA613025" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 20994160 | 20994160 | PRJNA613025_S_NODE_28117_length_174_cov_1.816000_g27963_i0 | PRJNA613025 | 28117 | 174 | 1.816 | 3.15984 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 107 | 6.03e-26 | NR | XP_004334335.1 | 1257118 | g27963 | i0 | 78.9 | 7.94827586206897 | 57 | 12 | 98.3 | 0 | 2 | 172 | 111 | 167 | XP_004334335.1 actin related protein 2/3 complex, 41 kDa subunit [Acanthamoeba castellanii str. Neff] | diamond | 1383 | 107 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 22268800 | 22268800 | PRJNA613025_S_NODE_17098_length_249_cov_2.040000_g16944_i0 | PRJNA613025 | 17098 | 249 | 2.04 | 5.0796 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 122 | 3.49e-33 | NR | XP_004368153.1 | 1257118 | g16944 | i0 | 75 | 2.62650602409639 | 72 | 18 | 86.7 | 0 | 1 | 216 | 90 | 161 | XP_004368153.1 ribosomal protein S17, putative [Acanthamoeba castellanii str. Neff] | diamond | 654 | 122 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 24817730 | 24817730 | PRJNA613025_S_NODE_10340_length_383_cov_4.182635_g10187_i0 | PRJNA613025 | 10340 | 383 | 4.182635 | 16.01949205 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 132 | 5.42e-37 | NR | 1PRQ_A | 5755 | g10187 | i0 | 62.6 | 1.67624020887728 | 107 | 39 | 83.8 | 1 | 376 | 56 | 20 | 125 | 1PRQ_A Chain A, PROFILIN IA [Acanthamoeba castellanii] | diamond | 642 | 132 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 24817865 | 24817865 | PRJNA613025_S_NODE_15600_length_270_cov_1.375566_g15446_i0 | PRJNA613025 | 15600 | 270 | 1.375566 | 3.7140282 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 78.2 | 6.39e-16 | NR | XP_004338635.1 | 1257118 | g15446 | i0 | 58.9 | 3.01111111111111 | 73 | 29 | 81.1 | 1 | 264 | 46 | 82 | 153 | XP_004338635.1 60S ribosomal protein L36, putative [Acanthamoeba castellanii str. Neff] | diamond | 813 | 78.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27016941 | 27016941 | PRJNA613025_S_NODE_10202_length_388_cov_2.407080_g10049_i0 | PRJNA613025 | 10202 | 388 | 2.40708 | 9.3394704 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 164 | 2.69e-49 | NR | 7SOG_A | 5755 | g10049 | i0 | 63.9 | 0.920103092783505 | 119 | 43 | 92 | 0 | 8 | 364 | 17 | 135 | 7SOG_A Chain A, Actophorin [Acanthamoeba castellanii] | diamond | 357 | 164 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27143100 | 27143100 | PRJNA613025_S_NODE_26262_length_182_cov_1.533835_g26108_i0 | PRJNA613025 | 26262 | 182 | 1.533835 | 2.7915797 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 84.3 | 4.55e-19 | NR | XP_004333102.1 | 1257118 | g26108 | i0 | 80.8 | 1.71428571428571 | 52 | 10 | 85.7 | 0 | 178 | 23 | 81 | 132 | XP_004333102.1 ribosomal protein L32, putative [Acanthamoeba castellanii str. Neff] | diamond | 312 | 84.3 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27649045 | 27649045 | PRJNA613025_S_NODE_24884_length_189_cov_1.092857_g24730_i0 | PRJNA613025 | 24884 | 189 | 1.092857 | 2.06549973 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 87.4 | 1.54e-19 | NR | XP_004356664.1 | 1257118 | g24730 | i0 | 72.9 | 1.52380952380952 | 48 | 13 | 76.2 | 0 | 1 | 144 | 151 | 198 | XP_004356664.1 rho guanine dissociation factor isoform 2, putative [Acanthamoeba castellanii str. Neff] | diamond | 288 | 87.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28185473 | 28185473 | PRJNA613025_S_NODE_31586_length_165_cov_0.862069_g31432_i0 | PRJNA613025 | 31586 | 165 | 0.862069 | 1.42241385 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 67 | 3.41e-11 | NR | XP_020431823.1 | 670386 | g31432 | i0 | 50.9 | 1.92727272727273 | 53 | 26 | 96.4 | 0 | 3 | 161 | 88 | 140 | XP_020431823.1 glutathione S-transferase domain-containing protein [Heterostelium album PN500] | diamond | 318 | 67 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 28943792 | 28943792 | PRJNA613025_S_NODE_16108_length_262_cov_1.375587_g15954_i0 | PRJNA613025 | 16108 | 262 | 1.375587 | 3.60403794 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 92.8 | 9.07e-20 | NR | XP_647081.2 | 352472 | g15954 | i0 | 51.9 | 2.81679389312977 | 81 | 39 | 92.7 | 0 | 245 | 3 | 73 | 153 | XP_647081.2 p21-activated protein kinase [Dictyostelium discoideum AX4] | diamond | 738 | 92.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 29587671 | 29587671 | PRJNA613025_S_NODE_8230_length_465_cov_3.689904_g8078_i0 | PRJNA613025 | 8230 | 465 | 3.689904 | 17.1580536 | Eumycetozoa | 142796 | Evosea | other_Eukaryota | 141 | 8.77e-40 | NR | KYR02504.1 | 361077 | g8078 | i0 | 50.7 | 2.6 | 134 | 66 | 86.5 | 0 | 463 | 62 | 7 | 140 | KYR02504.1 actin binding protein [Tieghemostelium lacteum] | diamond | 1209 | 141 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 29606154 | 29606154 | PRJNA613025_S_NODE_27050_length_179_cov_1.000000_g26896_i0 | PRJNA613025 | 27050 | 179 | 1 | 1.79 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 47 | 1.86e-4 | NR | XP_012758105.1 | 1410327 | g26896 | i0 | 35.7 | 0.93854748603352 | 56 | 36 | 93.9 | 0 | 172 | 5 | 22 | 77 | XP_012758105.1 hypothetical protein SAMD00019534_020600, partial [Acytostelium subglobosum LB1] | diamond | 168 | 47 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 31072844 | 31072844 | PRJNA613025_S_NODE_19775_length_222_cov_1.161850_g19621_i0 | PRJNA613025 | 19775 | 222 | 1.16185 | 2.579307 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 67 | 7.79e-11 | NR | XP_004182963.1 | 370355 | g19621 | i0 | 44.6 | 2.01351351351351 | 74 | 38 | 97.3 | 2 | 218 | 3 | 772 | 844 | XP_004182963.1 Gelation factor, putative [Entamoeba invadens IP1] | diamond | 447 | 67.4 | 0.99406528189911 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 31280924 | 31280924 | PRJNA613025_S_NODE_25375_length_186_cov_2.379562_g25221_i0 | PRJNA613025 | 25375 | 186 | 2.379562 | 4.42598532 | Polysphondylium violaceum | 133409 | Evosea | other_Eukaryota | 54.7 | 9.99e-7 | NR | KAF2073311.1 | 133409 | g25221 | i0 | 49.2 | 1.96774193548387 | 61 | 31 | 98.4 | 0 | 3 | 185 | 198 | 258 | KAF2073311.1 hypothetical protein CYY_005364 [Polysphondylium violaceum] | diamond | 366 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Polysphondylium | Polysphondylium violaceum | ||
| 31660348 | 31660348 | PRJNA613025_S_NODE_18777_length_231_cov_1.390110_g18623_i0 | PRJNA613025 | 18777 | 231 | 1.39011 | 3.2111541 | Heterostelium album PN5 | 2086695 | Evosea | other_Eukaryota | 90.1 | 6.4e-20 | NR | XP_020433716.1 | 670386 | g18623 | i0 | 54.8 | 0.948051948051948 | 73 | 30 | 94.8 | 1 | 3 | 221 | 56 | 125 | XP_020433716.1 component of the counting factor complex [Heterostelium album PN500] | diamond | 219 | 90.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 31818600 | 31818600 | PRJNA613025_S_NODE_19117_length_228_cov_0.849162_g18963_i0 | PRJNA613025 | 19117 | 228 | 0.849162 | 1.93608936 | Acytostelium subglobosum LB1 | 1410327 | Evosea | other_Eukaryota | 92 | 1.11e-21 | NR | XP_012752219.1 | 1410327 | g18963 | i0 | 56.9 | 0.947368421052632 | 72 | 31 | 94.7 | 0 | 5 | 220 | 48 | 119 | XP_012752219.1 hypothetical protein SAMD00019534_077250 [Acytostelium subglobosum LB1] | diamond | 216 | 92 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 31976823 | 31976823 | PRJNA613025_S_NODE_20078_length_219_cov_1.647059_g19924_i0 | PRJNA613025 | 20078 | 219 | 1.647059 | 3.60705921 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 111 | 6.270000000000001e-27 | NR | XP_004333651.1 | 1257118 | g19924 | i0 | 64.4 | 1 | 73 | 26 | 100 | 0 | 219 | 1 | 50 | 122 | XP_004333651.1 coronin3, putative [Acanthamoeba castellanii str. Neff] | diamond | 219 | 111 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32261959 | 32261959 | PRJNA613025_S_NODE_29678_length_168_cov_1.705882_g29524_i0 | PRJNA613025 | 29678 | 168 | 1.705882 | 2.86588176 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 62.8 | 1.19e-9 | NR | KYR00721.1 | 361077 | g29524 | i0 | 55.8 | 0.928571428571429 | 52 | 23 | 92.9 | 0 | 1 | 156 | 1189 | 1240 | KYR00721.1 alpha actinin [Tieghemostelium lacteum] | diamond | 156 | 62.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 32325272 | 32325272 | PRJNA613025_S_NODE_32779_length_163_cov_0.885965_g32625_i0 | PRJNA613025 | 32779 | 163 | 0.885965 | 1.44412295 | Entamoeba invadens IP1 | 370355 | Evosea | other_Eukaryota | 46.6 | 5.63e-4 | NR | XP_004254922.1 | 370355 | g32625 | i0 | 48.8 | 0.754601226993865 | 41 | 20 | 75.5 | 1 | 133 | 11 | 1193 | 1232 | XP_004254922.1 serine-threonine protein kinase, putative [Entamoeba invadens IP1] | diamond | 123 | 46.6 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens |
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);;