contig_metadata
16 rows where analysis = "diamond", bioproject = "PRJNA340009" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 18243635 | 18243635 | PRJNA340009_P_NODE_28435_length_232_cov_2.704918_g28128_i0 | PRJNA340009 | 28435 | 232 | 2.704918 | 6.27540976 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 66.6 | 1.14e-10 | NR | XP_004356655.1 | 1257118 | g28128 | i0 | 63.2 | 0.737068965517241 | 57 | 21 | 73.7 | 0 | 32 | 202 | 327 | 383 | XP_004356655.1 uncharacterized protein ACA1_174150 [Acanthamoeba castellanii str. Neff] | diamond | 171 | 66.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 19517674 | 19517674 | PRJNA340009_P_NODE_12496_length_330_cov_2.822064_g12189_i0 | PRJNA340009 | 12496 | 330 | 2.822064 | 9.3128112 | Dictyostelium discoideum AX4 | 352472 | Evosea | other_Eukaryota | 100 | 7.750000000000001e-22 | NR | XP_636821.1 | 352472 | g12189 | i0 | 59.7 | 0.7 | 77 | 31 | 70 | 0 | 321 | 91 | 634 | 710 | XP_636821.1 threonyl-tRNA synthetase [Dictyostelium discoideum AX4] | diamond | 231 | 100 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 27706925 | 27706925 | PRJNA340009_P_NODE_22084_length_258_cov_43.267943_g21777_i0 | PRJNA340009 | 22084 | 258 | 43.267943 | 111.63129294 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 55.1 | 1.98e-6 | NR | KAH3765306.1 | 1580589 | g21777 | i0 | 57.5 | 0.465116279069767 | 40 | 17 | 46.5 | 0 | 14 | 133 | 584 | 623 | KAH3765306.1 hypothetical protein Pelo_2830 [Pelomyxa schiedti] | diamond | 120 | 55.1 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 27895860 | 27895860 | PRJNA340009_P_NODE_49425_length_184_cov_2.755556_g49118_i0 | PRJNA340009 | 49425 | 184 | 2.755556 | 5.07022304 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 103 | 4.729999999999999e-24 | NR | PRP73176.1 | 1890364 | g49118 | i0 | 70.5 | 1.98913043478261 | 61 | 18 | 99.5 | 0 | 2 | 184 | 149 | 209 | PRP73176.1 u3 small nucleolar RNA-interacting protein 2-like [Planoprotostelium fungivorum] | diamond | 366 | 103 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28464458 | 28464458 | PRJNA340009_P_NODE_76166_length_161_cov_0.910714_g75859_i0 | PRJNA340009 | 76166 | 161 | 0.910714 | 1.46624954 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 80.1 | 8.21e-16 | NR | PRP81845.1 | 1890364 | g75859 | i0 | 70 | 0.93167701863354 | 50 | 15 | 93.2 | 0 | 152 | 3 | 824 | 873 | PRP81845.1 P-type ATPase [Planoprotostelium fungivorum] | diamond | 150 | 80.1 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 28860297 | 28860297 | PRJNA340009_P_NODE_30288_length_226_cov_1.988701_g29981_i0 | PRJNA340009 | 30288 | 226 | 1.988701 | 4.49446426 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 43.9 | 0.00968 | NR | KAH3756887.1 | 1580589 | g29981 | i0 | 72 | 2.04424778761062 | 25 | 7 | 33.2 | 0 | 214 | 140 | 135 | 159 | KAH3756887.1 meiosis protein [Pelomyxa schiedti] | diamond | 462 | 43.9 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 29474417 | 29474417 | PRJNA340009_P_NODE_76770_length_161_cov_0.910714_g76463_i0 | PRJNA340009 | 76770 | 161 | 0.910714 | 1.46624954 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 47 | 3.9e-4 | NR | XP_004336759.1 | 1257118 | g76463 | i0 | 48.9 | 0.875776397515528 | 47 | 24 | 87.6 | 0 | 16 | 156 | 33 | 79 | XP_004336759.1 peptidase family M3 protein, partial [Acanthamoeba castellanii str. Neff] | diamond | 141 | 47 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30169340 | 30169340 | PRJNA340009_P_NODE_43932_length_193_cov_2.833333_g43625_i0 | PRJNA340009 | 43932 | 193 | 2.833333 | 5.46833269 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 53.5 | 3.03e-6 | NR | PRP83212.1 | 1890364 | g43625 | i0 | 45.1 | 0.792746113989637 | 51 | 27 | 77.7 | 1 | 44 | 193 | 357 | 407 | PRP83212.1 ras-related protein Rab-11B-like [Planoprotostelium fungivorum] | diamond | 153 | 53.5 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 31102855 | 31102855 | PRJNA340009_P_NODE_4695_length_492_cov_4.103837_g4391_i0 | PRJNA340009 | 4695 | 492 | 4.103837 | 20.19087804 | Entamoeba | 5758 | Evosea | other_Eukaryota | 50.4 | 9.94e-4 | NR | XP_656595.2 | 294381 | g4391 | i0 | 34.6 | 3.20731707317073 | 78 | 50 | 47.6 | 1 | 162 | 395 | 1243 | 1319 | XP_656595.2 protein kinase, putative [Entamoeba histolytica HM-1:IMSS] | diamond | 1578 | 50.4 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 31338618 | 31338618 | PRJNA340009_P_NODE_71816_length_163_cov_0.894737_g71509_i0 | PRJNA340009 | 71816 | 163 | 0.894737 | 1.45842131 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 58.5 | 3.22e-8 | NR | XP_004362351.1 | 261658 | g71509 | i0 | 48.1 | 1.91411042944785 | 52 | 27 | 95.7 | 0 | 3 | 158 | 227 | 278 | XP_004362351.1 PhoPQ-activated pathogenicity-related protein [Cavenderia fasciculata] | diamond | 312 | 58.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 31781313 | 31781313 | PRJNA340009_P_NODE_29517_length_228_cov_8.832402_g29210_i0 | PRJNA340009 | 29517 | 228 | 8.832402 | 20.13787656 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 67.8 | 1.41e-11 | NR | PRP86794.1 | 1890364 | g29210 | i0 | 46 | 0.828947368421053 | 63 | 34 | 82.9 | 0 | 4 | 192 | 161 | 223 | PRP86794.1 hypothetical protein PROFUN_05011 [Planoprotostelium fungivorum] | diamond | 189 | 67.8 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32097823 | 32097823 | PRJNA340009_P_NODE_70198_length_163_cov_20.956140_g69891_i0 | PRJNA340009 | 70198 | 163 | 20.95614 | 34.1585082 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 62 | 2e-9 | NR | KAH3759061.1 | 1580589 | g69891 | i0 | 54.5 | 4.95092024539877 | 44 | 20 | 81 | 0 | 2 | 133 | 279 | 322 | KAH3759061.1 glycoside hydrolase family 27 protein [Pelomyxa schiedti] | diamond | 807 | 62 | 1 | Eukaryota | Amoebozoa | Evosea | Pelobiontida | Pelomyxidae | Pelomyxa | Pelomyxa schiedti | |||
| 32224515 | 32224515 | PRJNA340009_P_NODE_20038_length_269_cov_27.581818_g19731_i0 | PRJNA340009 | 20038 | 269 | 27.581818 | 74.19509042 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 87 | 1.78e-19 | NR | KYQ91463.1 | 361077 | g19731 | i0 | 53.4 | 0.814126394052045 | 73 | 33 | 81.4 | 1 | 269 | 51 | 69 | 140 | KYQ91463.1 hypothetical protein DLAC_08430 [Tieghemostelium lacteum] | diamond | 219 | 87 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 32382621 | 32382621 | PRJNA340009_P_NODE_33199_length_217_cov_66.107143_g32892_i0 | PRJNA340009 | 33199 | 217 | 66.107143 | 143.45250031 | Planoprotostelium fungivorum | 1890364 | Evosea | other_Eukaryota | 80.1 | 1.75e-15 | NR | PRP75504.1 | 1890364 | g32892 | i0 | 90 | 0.552995391705069 | 40 | 4 | 55.3 | 0 | 3 | 122 | 552 | 591 | PRP75504.1 hypothetical protein PROFUN_10682 [Planoprotostelium fungivorum] | diamond | 120 | 80.1 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Cavosteliida | Cavosteliaceae | Planoprotostelium | Planoprotostelium fungivorum | ||
| 32666840 | 32666840 | PRJNA340009_P_NODE_5940_length_445_cov_30.825758_g5633_i0 | PRJNA340009 | 5940 | 445 | 30.825758 | 137.1746231 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 85.9 | 1.13e-18 | NR | XP_004335921.1 | 1257118 | g5633 | i0 | 56.7 | 0.451685393258427 | 67 | 29 | 45.2 | 0 | 340 | 140 | 5 | 71 | XP_004335921.1 uncharacterized protein ACA1_364340 [Acanthamoeba castellanii str. Neff] | diamond | 201 | 85.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32698297 | 32698297 | PRJNA340009_P_NODE_74460_length_162_cov_0.902655_g74153_i0 | PRJNA340009 | 74460 | 162 | 0.902655 | 1.4623011 | Pelomyxa schiedti | 1580589 | Evosea | other_Eukaryota | 80.9 | 4.39e-16 | NR | KAH3744365.1 | 1580589 | g74153 | i0 | 67.9 | 0.981481481481482 | 53 | 15 | 98.1 | 1 | 2 | 160 | 547 | 597 | KAH3744365.1 protein kinase [Pelomyxa schiedti] | diamond | 159 | 80.9 | 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);;