contig_metadata
20 rows where bioproject = "PRJEB14664", tax_clade = "Amoebozoa" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1295470 | 1295470 | PRJEB14664_P_NODE_5322_length_366_cov_1.785498_g5192_i0 | PRJEB14664 | 5322 | 366 | 1.785498 | 6.53492268 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 165 | 3.46e-50 | NR | XP_004339588.1 | 1257118 | g5192 | i0 | 90.1 | 1.50819672131148 | 91 | 9 | 74.6 | 0 | 94 | 366 | 5 | 95 | XP_004339588.1 60S ribosomal protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 552 | 165 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 2571112 | 2571112 | PRJEB14664_P_NODE_3183_length_505_cov_2.889362_g3061_i0 | PRJEB14664 | 3183 | 505 | 2.889362 | 14.5912781 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 658 | 0 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g3061 | i0 | 90.4 | 99.0594059405941 | 500 | 48 | 99 | 0 | 3 | 502 | 581 | 1080 | Platyamoeba placida actin mRNA, partial cds | blastn | 50025 | 658 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 11189094 | 11189094 | PRJEB14664_P_NODE_16849_length_169_cov_1.425373_g16719_i0 | PRJEB14664 | 16849 | 169 | 1.425373 | 2.40888037 | Vannella | 95228 | Discosea | other_Eukaryota | 313 | 5.859999999999999e-81 | NTclustered | gi|62865934|gb|AY929909.1| | 325075 | g16719 | i0 | 100 | 100.781065088757 | 169 | 0 | 100 | 0 | 1 | 169 | 851 | 1019 | Vannella sp. strain 4362V/II 18S small subunit ribosomal RNA gene, partial sequence | blastn | 17032 | 313 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain 4362V/II | |||
| 11499179 | 11499179 | PRJEB14664_P_NODE_12030_length_212_cov_1.830508_g11900_i0 | PRJEB14664 | 12030 | 212 | 1.830508 | 3.88067696 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 281 | 2.18e-71 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g11900 | i0 | 90.61 | 99.3066037735849 | 213 | 19 | 100 | 1 | 1 | 212 | 919 | 707 | Platyamoeba placida actin mRNA, partial cds | blastn | 21053 | 281 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 16598067 | 16598067 | PRJEB14664_P_NODE_2754_length_547_cov_3.652344_g2638_i0 | PRJEB14664 | 2754 | 547 | 3.652344 | 19.97832168 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 190 | 1.7899999999999998e-55 | NR | XP_004341586.1 | 1257118 | g2638 | i0 | 57.9 | 1.57952468007313 | 145 | 61 | 79.5 | 0 | 445 | 11 | 249 | 393 | XP_004341586.1 elongation factor 1-gamma family protein [Acanthamoeba castellanii str. Neff] | diamond | 864 | 191 | 0.994764397905759 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 16598072 | 16598072 | PRJEB14664_P_NODE_3234_length_500_cov_2.341935_g3111_i0 | PRJEB14664 | 3234 | 500 | 2.341935 | 11.709675 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 204 | 4.3499999999999996e-62 | NR | XP_004356622.1 | 1257118 | g3111 | i0 | 83.8 | 0.702 | 117 | 19 | 70.2 | 0 | 3 | 353 | 199 | 315 | XP_004356622.1 mitochondrial phosphate transporter, putative [Acanthamoeba castellanii str. Neff] | diamond | 351 | 204 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 17872881 | 17872881 | PRJEB14664_P_NODE_5275_length_367_cov_20.689759_g5145_i0 | PRJEB14664 | 5275 | 367 | 20.689759 | 75.93141553 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 204 | 9.09e-48 | NTclustered | gi|470521486|ref|XM_004353672.1| | 1257118 | g5145 | i0 | 82.479 | 64.16621253406 | 234 | 39 | 63 | 2 | 99 | 331 | 99 | 331 | Acanthamoeba castellanii str. Neff Histone H4, putative (ACA1_376700), partial mRNA | blastn | 23549 | 204 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 26621497 | 26621497 | PRJEB14664_P_NODE_6681_length_317_cov_1.734043_g6551_i0 | PRJEB14664 | 6681 | 317 | 1.734043 | 5.49691631 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 160 | 7.829999999999999e-46 | NR | XP_004356622.1 | 1257118 | g6551 | i0 | 69.5 | 1.98738170347003 | 105 | 32 | 99.4 | 0 | 1 | 315 | 94 | 198 | XP_004356622.1 mitochondrial phosphate transporter, putative [Acanthamoeba castellanii str. Neff] | diamond | 630 | 160 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27507220 | 27507220 | PRJEB14664_P_NODE_12563_length_206_cov_1.614035_g12433_i0 | PRJEB14664 | 12563 | 206 | 1.614035 | 3.3249121 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 80.9 | 1.18e-16 | NR | XP_004349741.1 | 1257118 | g12433 | i0 | 64.4 | 0.859223300970874 | 59 | 21 | 85.9 | 0 | 181 | 5 | 169 | 227 | XP_004349741.1 uncharacterized protein ACA1_034610 [Acanthamoeba castellanii str. Neff] | diamond | 177 | 80.9 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 27854335 | 27854335 | PRJEB14664_P_NODE_8445_length_272_cov_1.021097_g8315_i0 | PRJEB14664 | 8445 | 272 | 1.021097 | 2.77738384 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 89.4 | 2.21e-18 | NR | XP_004335167.1 | 1257118 | g8315 | i0 | 59.2 | 0.838235294117647 | 76 | 31 | 83.8 | 0 | 3 | 230 | 996 | 1071 | XP_004335167.1 cellulose synthase (udp-forming), putative, partial [Acanthamoeba castellanii str. Neff] | diamond | 228 | 89.4 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28170099 | 28170099 | PRJEB14664_P_NODE_18746_length_157_cov_1.959016_g18616_i0 | PRJEB14664 | 18746 | 157 | 1.959016 | 3.07565512 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 79 | 1.02e-17 | NR | XP_004336976.1 | 1257118 | g18616 | i0 | 76.9 | 0.993630573248408 | 52 | 12 | 99.4 | 0 | 157 | 2 | 7 | 58 | XP_004336976.1 major vault protein [Acanthamoeba castellanii str. Neff] | diamond | 156 | 79 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 28511079 | 28511079 | PRJEB14664_P_NODE_5907_length_342_cov_1.302932_g5777_i0 | PRJEB14664 | 5907 | 342 | 1.302932 | 4.45602744 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 113 | 1.22e-29 | NR | XP_004352819.1 | 1257118 | g5777 | i0 | 58.9 | 3.76315789473684 | 107 | 44 | 93.9 | 0 | 12 | 332 | 1 | 107 | XP_004352819.1 ribosomal protein L35, putative [Acanthamoeba castellanii str. Neff] | diamond | 1287 | 113 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29496173 | 29496173 | PRJEB14664_P_NODE_11270_length_223_cov_1.260638_g11140_i0 | PRJEB14664 | 11270 | 223 | 1.260638 | 2.81122274 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 49.7 | 6.6e-5 | NR | XP_004340499.1 | 1257118 | g11140 | i0 | 40.6 | 0.860986547085202 | 64 | 38 | 86.1 | 0 | 199 | 8 | 30 | 93 | XP_004340499.1 translation initiation inhibitor, putative [Acanthamoeba castellanii str. Neff] | diamond | 192 | 49.7 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29521403 | 29521403 | PRJEB14664_P_NODE_6970_length_308_cov_1.831502_g6840_i0 | PRJEB14664 | 6970 | 308 | 1.831502 | 5.64102616 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 153 | 8.23e-46 | NR | XP_004339588.1 | 1257118 | g6840 | i0 | 76.8 | 13.4707792207792 | 99 | 23 | 96.4 | 0 | 10 | 306 | 5 | 103 | XP_004339588.1 60S ribosomal protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 4149 | 154 | 0.993506493506494 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 29685322 | 29685322 | PRJEB14664_P_NODE_9350_length_253_cov_2.564220_g9220_i0 | PRJEB14664 | 9350 | 253 | 2.56422 | 6.4874766 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 104 | 2.52e-26 | NR | XP_004341583.1 | 1257118 | g9220 | i0 | 64.6 | 7.04347826086957 | 79 | 28 | 93.7 | 0 | 238 | 2 | 3 | 81 | XP_004341583.1 ribosomal protein S9, putative [Acanthamoeba castellanii str. Neff] | diamond | 1782 | 104 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30190927 | 30190927 | PRJEB14664_P_NODE_10972_length_227_cov_0.817708_g10842_i0 | PRJEB14664 | 10972 | 227 | 0.817708 | 1.85619716 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 130 | 1.55e-34 | NR | XP_004358308.1 | 1257118 | g10842 | i0 | 79.7 | 0.977973568281938 | 74 | 15 | 97.8 | 0 | 222 | 1 | 144 | 217 | XP_004358308.1 papain family cysteine protease subfamily protein [Acanthamoeba castellanii str. Neff] | diamond | 222 | 130 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 30917892 | 30917892 | PRJEB14664_P_NODE_11194_length_224_cov_1.253968_g11064_i0 | PRJEB14664 | 11194 | 224 | 1.253968 | 2.80888832 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 87 | 2.46e-20 | NR | XP_004335971.1 | 1257118 | g11064 | i0 | 67.3 | 2.91964285714286 | 52 | 17 | 69.6 | 0 | 156 | 1 | 20 | 71 | XP_004335971.1 cytochrome b5, putative [Acanthamoeba castellanii str. Neff] | diamond | 654 | 87 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31543754 | 31543754 | PRJEB14664_P_NODE_7816_length_286_cov_1.832669_g7686_i0 | PRJEB14664 | 7816 | 286 | 1.832669 | 5.24143334 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 90.1 | 2.34e-19 | NR | XP_004336608.1 | 1257118 | g7686 | i0 | 61.4 | 11.7062937062937 | 70 | 26 | 72.4 | 1 | 208 | 2 | 34 | 103 | XP_004336608.1 Rpl7A, putative [Acanthamoeba castellanii str. Neff] | diamond | 3348 | 90.1 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 31992865 | 31992865 | PRJEB14664_P_NODE_18858_length_157_cov_1.172131_g18728_i0 | PRJEB14664 | 18858 | 157 | 1.172131 | 1.84024567 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 41.6 | 0.0288 | NR | XP_004344891.1 | 1257118 | g18728 | i0 | 61.3 | 0.592356687898089 | 31 | 12 | 59.2 | 0 | 152 | 60 | 208 | 238 | XP_004344891.1 anthranilate synthase component I family protein, partial [Acanthamoeba castellanii str. Neff] | diamond | 93 | 41.6 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 32119577 | 32119577 | PRJEB14664_P_NODE_18738_length_157_cov_1.967213_g18608_i0 | PRJEB14664 | 18738 | 157 | 1.967213 | 3.08852441 | Acanthamoeba castellanii str. Neff | 1257118 | Discosea | other_Eukaryota | 60.1 | 6.65e-10 | NR | XP_004339588.1 | 1257118 | g18608 | i0 | 65.1 | 12.5732484076433 | 43 | 15 | 82.2 | 0 | 136 | 8 | 11 | 53 | XP_004339588.1 60S ribosomal protein, putative [Acanthamoeba castellanii str. Neff] | diamond | 1974 | 60.1 | 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);;