contig_metadata
16 rows where analysis = "blastn", bioproject = "PRJNA1132896" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1558204 | 1558204 | PRJNA1132896_P_NODE_3182_length_315_cov_1.272727_g3091_i0 | PRJNA1132896 | 3182 | 315 | 1.272727 | 4.00909005 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 130 | 1.32e-25 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g3091 | i0 | 87.611 | 31.7460317460317 | 113 | 13 | 36 | 1 | 9 | 120 | 219 | 107 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 10000 | 130 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 2834259 | 2834259 | PRJNA1132896_P_NODE_1283_length_461_cov_2.649485_g1192_i0 | PRJNA1132896 | 1283 | 461 | 2.649485 | 12.21412585 | Badhamia melanospora | 1346252 | Evosea | other_Eukaryota | 429 | 1.7699999999999996e-115 | NTclustered | gi|2440757457|gb|OP616492.1| | 1346252 | g1192 | i0 | 83.589 | 96.9197396963124 | 457 | 73 | 99 | 2 | 3 | 458 | 469 | 14 | Badhamia melanospora voucher LE266197 translation elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 44680 | 429 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Badhamia | Badhamia melanospora | ||
| 2834331 | 2834331 | PRJNA1132896_P_NODE_863_length_554_cov_44.110187_g772_i0 | PRJNA1132896 | 863 | 554 | 44.110187 | 244.37043598 | Vannella sp. strain CAZ6/I | 325077 | Discosea | other_Eukaryota | 931 | 0 | NTclustered | gi|62865939|gb|AY929914.1| | 325077 | g772 | i0 | 97.107 | 101.675090252708 | 553 | 15 | 99 | 1 | 2 | 554 | 1091 | 540 | Vannella sp. strain CAZ6/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 56328 | 931 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain CAZ6/I | |||
| 5386814 | 5386814 | PRJNA1132896_P_NODE_2545_length_345_cov_1.529412_g2454_i0 | PRJNA1132896 | 2545 | 345 | 1.529412 | 5.2764714 | Diderma niveum | 372584 | Evosea | other_Eukaryota | 257 | 6.45e-64 | NTclustered | gi|381140154|emb|HE655061.1| | 372584 | g2454 | i0 | 80.912 | 60.4492753623188 | 351 | 46 | 100 | 17 | 1 | 345 | 3372 | 3037 | Diderma niveum partial 28S rRNA gene, isolate Uk-K79 | blastn | 20855 | 257 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Diderma | Diderma niveum | ||
| 6661526 | 6661526 | PRJNA1132896_P_NODE_7346_length_249_cov_2.187500_g7255_i0 | PRJNA1132896 | 7346 | 249 | 2.1875 | 5.446875 | Diderma europaeum | 2656919 | Evosea | other_Eukaryota | 399 | 6.989999999999999e-107 | NTclustered | gi|118577471|gb|DQ903677.1| | 2656919 | g7255 | i0 | 95.582 | 100.076305220884 | 249 | 11 | 100 | 0 | 1 | 249 | 947 | 1195 | Diderma globosum var. europaeum voucher AMFD110 small subunit ribosomal RNA gene, partial sequence | blastn | 24919 | 399 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Diderma | Diderma europaeum | ||
| 10487195 | 10487195 | PRJNA1132896_P_NODE_9169_length_244_cov_0.900585_g9078_i0 | PRJNA1132896 | 9169 | 244 | 0.900585 | 2.1974274 | Physarum polycephalum | 5791 | Evosea | other_Eukaryota | 195 | 3.46e-45 | NTclustered | gi|326632058|gb|HQ849399.1| | 5791 | g9078 | i0 | 83.178 | 3.70901639344262 | 214 | 34 | 87 | 2 | 32 | 244 | 2058 | 2270 | Physarum polycephalum strain M3CVIII 23S large subunit ribosomal RNA, complete sequence; mitochondrial | blastn | 905 | 195 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Physaraceae | Physarum | Physarum polycephalum | ||
| 12510500 | 12510500 | PRJNA1132896_P_NODE_490_length_749_cov_1.326923_g404_i0 | PRJNA1132896 | 490 | 749 | 1.326923 | 9.93865327 | Didymium | 5792 | Evosea | other_Eukaryota | 433 | 2.2899999999999996e-116 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g404 | i0 | 85.45 | 6.07076101468625 | 433 | 44 | 58 | 11 | 1 | 431 | 1769 | 2184 | D.iridis LSU rRNA gene | blastn | 4547 | 433 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 14312587 | 14312587 | PRJNA1132896_P_NODE_812_length_571_cov_4.819277_g721_i0 | PRJNA1132896 | 812 | 571 | 4.819277 | 27.51807167 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 254 | 1.44e-62 | NTclustered | gi|330799393|ref|XM_003287682.1| | 5786 | g721 | i0 | 80.851 | 6.87565674255692 | 329 | 58 | 57 | 4 | 14 | 341 | 515 | 191 | Dictyostelium purpureum 40S ribosomal protein S2 (DICPUDRAFT_32959), partial mRNA | blastn | 3926 | 254 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 16860795 | 16860795 | PRJNA1132896_P_NODE_2114_length_373_cov_1.903333_g2023_i0 | PRJNA1132896 | 2114 | 373 | 1.903333 | 7.09943209 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 303 | 8.87e-78 | NTclustered | gi|470420395|ref|XM_004337241.1| | 1257118 | g2023 | i0 | 82.123 | 20.8525469168901 | 358 | 60 | 95 | 4 | 1 | 356 | 2117 | 1762 | Acanthamoeba castellanii str. Neff eukaryotic translation elongation factor 2, putative (ACA1_220140), partial mRNA | blastn | 7778 | 303 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 16860796 | 16860796 | PRJNA1132896_P_NODE_214_length_1114_cov_21.984630_g160_i0 | PRJNA1132896 | 214 | 1114 | 21.98463 | 244.9087782 | Vannella sp. strain CAZ6/I | 325077 | Discosea | other_Eukaryota | 926 | 0 | NTclustered | gi|62865939|gb|AY929914.1| | 325077 | g160 | i0 | 96.931 | 49.9174147217235 | 554 | 13 | 49 | 3 | 563 | 1113 | 3 | 555 | Vannella sp. strain CAZ6/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 55608 | 926 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. strain CAZ6/I | |||
| 19409514 | 19409514 | PRJNA1132896_P_NODE_3676_length_296_cov_2.932735_g3585_i0 | PRJNA1132896 | 3676 | 296 | 2.932735 | 8.6808956 | Vannella septentrionalis | 197531 | Discosea | other_Eukaryota | 388 | 1.84e-103 | NTclustered | gi|300078499|gb|GU001161.1| | 197531 | g3585 | i0 | 90.429 | 66.4560810810811 | 303 | 17 | 99 | 10 | 3 | 296 | 3492 | 3791 | Vannella septentrionalis 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 | 19671 | 388 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella septentrionalis | |||
| 19409553 | 19409553 | PRJNA1132896_P_NODE_756_length_589_cov_4.618217_g666_i0 | PRJNA1132896 | 756 | 589 | 4.618217 | 27.20129813 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 104 | 1.58e-17 | NTclustered | gi|330790854|ref|XM_003283463.1| | 5786 | g666 | i0 | 73.759 | 0.721561969439728 | 282 | 66 | 48 | 6 | 108 | 388 | 118 | 392 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_93471), partial mRNA | blastn | 425 | 104 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 21960380 | 21960380 | PRJNA1132896_P_NODE_1098_length_495_cov_2.431280_g1007_i0 | PRJNA1132896 | 1098 | 495 | 2.43128 | 12.034836 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 760 | 0 | NTclustered | gi|365928255|gb|JN825705.1| | 590481 | g1007 | i0 | 95.616 | 49.779797979798 | 479 | 12 | 96 | 8 | 1 | 475 | 630 | 1103 | Uncultured Amoebozoa clone Alchichica_AQ2b_5E_39 small subunit ribosomal RNA gene, partial sequence | blastn | 24641 | 760 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 21960381 | 21960381 | PRJNA1132896_P_NODE_1538_length_427_cov_3.104520_g1447_i0 | PRJNA1132896 | 1538 | 427 | 3.10452 | 13.2563004 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 472 | 2.67e-128 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g1447 | i0 | 90.476 | 85.2693208430913 | 357 | 34 | 84 | 0 | 69 | 425 | 538 | 894 | Platyamoeba placida actin mRNA, partial cds | blastn | 36410 | 472 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida | |||
| 21960463 | 21960463 | PRJNA1132896_P_NODE_938_length_533_cov_43.550000_g847_i0 | PRJNA1132896 | 938 | 533 | 43.55 | 232.1215 | Ripella decalvata | 2047822 | Discosea | other_Eukaryota | 835 | 0 | NTclustered | gi|1269228425|gb|MF683550.1| | 2047822 | g847 | i0 | 95.31 | 100.373358348968 | 533 | 13 | 99 | 11 | 1 | 529 | 1133 | 1657 | Ripella decalvata clone 26.2.4 18S ribosomal RNA gene, partial sequence | blastn | 53499 | 835 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella decalvata | |||
| 23235947 | 23235947 | PRJNA1132896_P_NODE_59_length_1843_cov_3.140113_g45_i0 | PRJNA1132896 | 59 | 1843 | 3.140113 | 57.87228259 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 966 | 0 | NTclustered | gi|330818764|ref|XM_003291461.1| | 5786 | g45 | i0 | 77.348 | 84.1150298426479 | 1682 | 350 | 91 | 27 | 159 | 1826 | 1677 | 13 | Dictyostelium purpureum heat shock protein (DICPUDRAFT_49867), partial mRNA | blastn | 155024 | 966 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum |
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);;