contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA667863" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 634074 | 634074 | PRJNA667863_P_NODE_16601_length_241_cov_7.952381_g16567_i0 | PRJNA667863 | 16601 | 241 | 7.952381 | 19.16523821 | Echinostelium bisporum | 1973072 | Evosea | other_Eukaryota | 320 | 5.39e-83 | NTclustered | gi|1496293921|gb|MH814572.1| | 1973072 | g16567 | i0 | 90.795 | 100.045643153527 | 239 | 22 | 99 | 0 | 1 | 239 | 1047 | 809 | Echinostelium bisporum isolate Nx14-A1 translation elongation factor EF-1 subunit alpha mRNA, partial cds | blastn | 24111 | 320 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Echinosteliales | Echinosteliidae | Echinostelium | Echinostelium bisporum | ||
| 634118 | 634118 | PRJNA667863_P_NODE_19581_length_198_cov_6.152000_g19547_i0 | PRJNA667863 | 19581 | 198 | 6.152 | 12.18096 | Soliformovum irregulare | 435424 | Evosea | other_Eukaryota | 300 | 5.55e-77 | NTclustered | gi|146448863|gb|EF513199.1| | 435424 | g19547 | i0 | 93.939 | 15.979797979798 | 198 | 12 | 100 | 0 | 1 | 198 | 718 | 915 | Soliformovum irregulare elongation factor 1A (EF1A) gene, partial cds | blastn | 3164 | 300 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Soliformoviidae | Soliformovum | Soliformovum irregulare | ||
| 634134 | 634134 | PRJNA667863_P_NODE_341_length_779_cov_7.169972_g313_i0 | PRJNA667863 | 341 | 779 | 7.169972 | 55.85408188 | Hagiwaraea rhizopodium | 361088 | Evosea | other_Eukaryota | 490 | 1.3999999999999995e-133 | NTclustered | gi|169930326|gb|EU360787.1| | 361088 | g313 | i0 | 78.431 | 61.9768934531451 | 765 | 155 | 98 | 10 | 20 | 779 | 998 | 239 | Hagiwaraea rhizopodium isolate Ausk Y-4 elongation factor 1 alpha gene, partial cds | blastn | 48280 | 490 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Hagiwaraea | Hagiwaraea rhizopodium | ||
| 1910194 | 1910194 | PRJNA667863_P_NODE_1942_length_399_cov_2.263804_g1908_i0 | PRJNA667863 | 1942 | 399 | 2.263804 | 9.03257796 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 556 | 6.64e-154 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g1908 | i0 | 92.269 | 35.4035087719298 | 401 | 17 | 99 | 8 | 6 | 399 | 7818 | 7425 | Acanthamoeba castellanii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 14126 | 556 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 4461989 | 4461989 | PRJNA667863_P_NODE_844_length_537_cov_1.290948_g811_i0 | PRJNA667863 | 844 | 537 | 1.290948 | 6.93239076 | Echinostelium bisporum | 1973072 | Evosea | other_Eukaryota | 638 | 3.18e-178 | NTclustered | gi|1496293921|gb|MH814572.1| | 1973072 | g811 | i0 | 88.104 | 92.6014897579143 | 538 | 62 | 100 | 2 | 1 | 537 | 845 | 309 | Echinostelium bisporum isolate Nx14-A1 translation elongation factor EF-1 subunit alpha mRNA, partial cds | blastn | 49727 | 638 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Echinosteliales | Echinosteliidae | Echinostelium | Echinostelium bisporum | ||
| 5737336 | 5737336 | PRJNA667863_P_NODE_12925_length_248_cov_0.880000_g12891_i0 | PRJNA667863 | 12925 | 248 | 0.88 | 2.1824 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 135 | 2.17e-27 | NTclustered | gi|470509261|ref|XM_004349682.1| | 1257118 | g12891 | i0 | 86.29 | 3.40322580645161 | 124 | 17 | 50 | 0 | 1 | 124 | 171 | 48 | Acanthamoeba castellanii str. Neff ribosomal protein S10p/S20e, putative (ACA1_034550), partial mRNA | blastn | 844 | 135 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 5737503 | 5737503 | PRJNA667863_P_NODE_7345_length_275_cov_2.287129_g7311_i0 | PRJNA667863 | 7345 | 275 | 2.287129 | 6.28960475 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 387 | 6.1e-103 | NTclustered | gi|470484649|ref|XM_004344039.1| | 1257118 | g7311 | i0 | 92 | 99.8436363636364 | 275 | 22 | 100 | 0 | 1 | 275 | 5293 | 5567 | Acanthamoeba castellanii str. Neff PremRNA processing splicing factor 8, putative (ACA1_054320), partial mRNA | blastn | 27457 | 387 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7012566 | 7012566 | PRJNA667863_P_NODE_3306_length_340_cov_3.779026_g3272_i0 | PRJNA667863 | 3306 | 340 | 3.779026 | 12.8486884 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 361 | 4.7e-95 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g3272 | i0 | 85.794 | 13.2058823529412 | 359 | 30 | 100 | 15 | 1 | 340 | 6464 | 6108 | Acanthamoeba castellanii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 4490 | 361 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 7012586 | 7012586 | PRJNA667863_P_NODE_5406_length_295_cov_6.360360_g5372_i0 | PRJNA667863 | 5406 | 295 | 6.36036 | 18.763062 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 333 | 8.729999999999999e-87 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g5372 | i0 | 87.291 | 13.7254237288136 | 299 | 28 | 100 | 9 | 1 | 295 | 7066 | 6774 | Acanthamoeba castellanii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 4049 | 333 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 12113384 | 12113384 | PRJNA667863_P_NODE_9590_length_260_cov_1.572193_g9556_i0 | PRJNA667863 | 9590 | 260 | 1.572193 | 4.0877018 | Soliformovum irregulare | 435424 | Evosea | other_Eukaryota | 387 | 5.72e-103 | NTclustered | gi|146448863|gb|EF513199.1| | 435424 | g9556 | i0 | 93.462 | 91.5923076923077 | 260 | 17 | 100 | 0 | 1 | 260 | 445 | 704 | Soliformovum irregulare elongation factor 1A (EF1A) gene, partial cds | blastn | 23814 | 387 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Fractovitellida | Soliformoviidae | Soliformovum | Soliformovum irregulare | ||
| 19760914 | 19760914 | PRJNA667863_P_NODE_1956_length_398_cov_1.590769_g1922_i0 | PRJNA667863 | 1956 | 398 | 1.590769 | 6.33126062 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 71.3 | 1.05e-7 | NTclustered | gi|1160570028|ref|XM_020574508.1| | 670386 | g1922 | i0 | 92 | 2.3894472361809 | 50 | 4 | 13 | 0 | 21 | 70 | 95 | 46 | Polysphondylium pallidum PN500 eukaryotic release factor 3 (eRF3), partial mRNA | blastn | 951 | 71.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 22311326 | 22311326 | PRJNA667863_P_NODE_2018_length_395_cov_1.186335_g1984_i0 | PRJNA667863 | 2018 | 395 | 1.186335 | 4.68602325 | Trichia sordida | 435425 | Evosea | other_Eukaryota | 448 | 4.13e-121 | NTclustered | gi|146448865|gb|EF513200.1| | 435425 | g1984 | i0 | 90.116 | 79.8481012658228 | 344 | 34 | 87 | 0 | 52 | 395 | 1287 | 944 | Trichia sordida elongation factor 1A (EF1A) gene, partial cds | blastn | 31540 | 448 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Trichia | Trichia sordida | ||
| 22840890 | 22840890 | PRJNA667863_P_NODE_10478_length_255_cov_1.565934_g10444_i0 | PRJNA667863 | 10478 | 255 | 1.565934 | 3.9931317 | Acanthamoeba | 5754 | Discosea | other_Eukaryota | 455 | 1.51e-123 | NTclustered | gi|2044079936|gb|MZ272128.1| | 5756 | g10444 | i0 | 98.824 | 100.937254901961 | 255 | 3 | 100 | 0 | 1 | 255 | 1424 | 1170 | Acanthamoeba sp. isolate AcW149 small subunit ribosomal RNA gene, partial sequence | blastn | 25739 | 455 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba sp. | |||
| 23586747 | 23586747 | PRJNA667863_P_NODE_2119_length_388_cov_11.120635_g2085_i0 | PRJNA667863 | 2119 | 388 | 11.120635 | 43.1480638 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 161 | 5.9e-35 | NTclustered | gi|1160574132|ref|XM_020577244.1| | 670386 | g2085 | i0 | 92.105 | 30.4407216494845 | 114 | 9 | 29 | 0 | 2 | 115 | 1018 | 1131 | Polysphondylium pallidum PN500 actin (act10), partial mRNA | blastn | 11811 | 161 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 23586839 | 23586839 | PRJNA667863_P_NODE_819_length_545_cov_9.779661_g787_i0 | PRJNA667863 | 819 | 545 | 9.779661 | 53.29915245 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 737 | 0 | NTclustered | gi|300078498|gb|GU001160.1| | 5755 | g787 | i0 | 91.15 | 18.5376146788991 | 565 | 18 | 100 | 19 | 1 | 545 | 5925 | 5373 | Acanthamoeba castellanii 18S ribosomal RNA gene, partial sequence; internal transcribed spacer 1, 5.8S ribosomal RNA gene, and internal transcribed spacer 2, complete sequence; and 28S ribosomal RNA gene, partial sequence | blastn | 10103 | 737 | 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);;