contig_metadata
9 rows where analysis = "diamond", bioproject = "PRJEB12237" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 12774284 | 12774284 | PRJEB12237_P_NODE_2371_length_459_cov_1.622642_g2175_i0 | PRJEB12237 | 2371 | 459 | 1.622642 | 7.44792678 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 163 | 9.62e-49 | NR | 1PRQ_A | 5755 | g2175 | i0 | 67.2 | 1.63398692810458 | 125 | 41 | 81.7 | 0 | 433 | 59 | 1 | 125 | 1PRQ_A Chain A, PROFILIN IA [Acanthamoeba castellanii] | diamond | 750 | 163 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26937917 | 26937917 | PRJEB12237_P_NODE_9822_length_171_cov_0.838235_g9626_i0 | PRJEB12237 | 9822 | 171 | 0.838235 | 1.43338185 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 73.2 | 1.33e-13 | NR | XP_004338074.1 | 1257118 | g9626 | i0 | 79.6 | 2.57894736842105 | 49 | 10 | 86 | 0 | 169 | 23 | 182 | 230 | XP_004338074.1 TolAlike protein [Acanthamoeba castellanii str. Neff] | diamond | 441 | 73.2 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27064574 | 27064574 | PRJEB12237_P_NODE_8762_length_184_cov_1.073826_g8566_i0 | PRJEB12237 | 8762 | 184 | 1.073826 | 1.97583984 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 55.5 | 5.33e-7 | NR | XP_004344664.1 | 1257118 | g8566 | i0 | 56.8 | 12.4891304347826 | 37 | 16 | 60.3 | 0 | 9 | 119 | 358 | 394 | XP_004344664.1 ABC1 domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 2298 | 55.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28580609 | 28580609 | PRJEB12237_P_NODE_8287_length_191_cov_1.012821_g8091_i0 | PRJEB12237 | 8287 | 191 | 1.012821 | 1.93448811 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 48.9 | 1.26e-4 | NR | XP_004335242.1 | 1257118 | g8091 | i0 | 32.3 | 0.973821989528796 | 62 | 42 | 97.4 | 0 | 2 | 187 | 286 | 347 | XP_004335242.1 serine/threonine kinase [Acanthamoeba castellanii str. Neff] | diamond | 186 | 48.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28643837 | 28643837 | PRJEB12237_P_NODE_1307_length_634_cov_2.607679_g1141_i0 | PRJEB12237 | 1307 | 634 | 2.607679 | 16.53268486 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 45.8 | 0.0229 | NR | XP_004334245.1 | 1257118 | g1141 | i0 | 32.1 | 0.738170347003155 | 156 | 83 | 65.8 | 9 | 592 | 176 | 4 | 153 | XP_004334245.1 uncharacterized protein ACA1_031140 [Acanthamoeba castellanii str. Neff] | diamond | 468 | 45.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30159122 | 30159122 | PRJEB12237_P_NODE_10812_length_161_cov_1.142857_g10616_i0 | PRJEB12237 | 10812 | 161 | 1.142857 | 1.83999977 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 64.7 | 9.64e-11 | NR | XP_004335309.1 | 1257118 | g10616 | i0 | 50 | 0.968944099378882 | 52 | 26 | 96.9 | 0 | 3 | 158 | 39 | 90 | XP_004335309.1 SCP2 sterol transfer family protein [Acanthamoeba castellanii str. Neff] | diamond | 156 | 64.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30222498 | 30222498 | PRJEB12237_P_NODE_1372_length_616_cov_2.734940_g1203_i0 | PRJEB12237 | 1372 | 616 | 2.73494 | 16.8472304 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 85.1 | 3e-17 | NR | XP_004349605.1 | 1257118 | g1203 | i0 | 37.1 | 0.642857142857143 | 132 | 75 | 60.9 | 4 | 544 | 170 | 4 | 134 | XP_004349605.1 uncharacterized protein ACA1_142080 [Acanthamoeba castellanii str. Neff] | diamond | 396 | 85.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32656502 | 32656502 | PRJEB12237_P_NODE_9320_length_177_cov_1.119718_g9124_i0 | PRJEB12237 | 9320 | 177 | 1.119718 | 1.98190086 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 87.8 | 4.73e-19 | NR | XP_004352467.1 | 1257118 | g9124 | i0 | 66 | 2.83050847457627 | 53 | 18 | 89.8 | 0 | 164 | 6 | 82 | 134 | XP_004352467.1 zinc finger domain containing protein [Acanthamoeba castellanii str. Neff] | diamond | 501 | 87.8 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32681750 | 32681750 | PRJEB12237_P_NODE_5720_length_247_cov_2.641509_g5524_i0 | PRJEB12237 | 5720 | 247 | 2.641509 | 6.52452723 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 116 | 2.1199999999999996e-31 | NR | 7SOG_A | 5755 | g5524 | i0 | 67.9 | 5.79352226720648 | 81 | 25 | 98.4 | 1 | 247 | 5 | 45 | 124 | 7SOG_A Chain A, Actophorin [Acanthamoeba castellanii] | diamond | 1431 | 116 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;