contig_metadata
15 rows where analysis = "blastn", bioproject = "PRJNA1087264" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 2292798 | 2292798 | PRJNA1087264_P_NODE_21962_length_160_cov_2.279279_g21880_i0 | PRJNA1087264 | 21962 | 160 | 2.279279 | 3.6468464 | Entamoeba | 5758 | Evosea | other_Eukaryota | 106 | 1e-18 | NTclustered | gi|511091168|dbj|AK422924.1| | 33085 | g21880 | i0 | 89.286 | 9.86875 | 84 | 9 | 53 | 0 | 1 | 84 | 1204 | 1287 | Entamoeba invadens cDNA clone: Xei-007J10, elongation factor 1-alpha, putative, complete cds, strain: IP1 | blastn | 1579 | 106 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba invadens | |||
| 2744769 | 2744769 | PRJNA1087264_P_NODE_3583_length_347_cov_0.916107_g3501_i0 | PRJNA1087264 | 3583 | 347 | 0.916107 | 3.17889129 | Cavenderia fasciculata | 261658 | Evosea | other_Eukaryota | 182 | 4.02e-41 | NTclustered | gi|470269854|ref|XM_004362533.1| | 261658 | g3501 | i0 | 77.882 | 6.05763688760807 | 321 | 52 | 89 | 16 | 36 | 345 | 402 | 90 | Cavenderia fasciculata 60S ribosomal protein L3 (rpl3), partial mRNA | blastn | 2102 | 182 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia fasciculata | ||
| 2744821 | 2744821 | PRJNA1087264_P_NODE_9703_length_202_cov_1.457516_g9621_i0 | PRJNA1087264 | 9703 | 202 | 1.457516 | 2.94418232 | Filamoeba nolandi | 136452 | Evosea | other_Eukaryota | 67.6 | 6.28e-7 | NTclustered | gi|146448849|gb|EF513192.1| | 136452 | g9621 | i0 | 97.436 | 0.193069306930693 | 39 | 1 | 19 | 0 | 1 | 39 | 1317 | 1355 | Filamoeba nolandi elongation factor 1A (EF1A) gene, partial cds | blastn | 39 | 67.6 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Filamoeba | Filamoeba nolandi | ||||
| 7846675 | 7846675 | PRJNA1087264_P_NODE_14807_length_167_cov_0.864407_g14725_i0 | PRJNA1087264 | 14807 | 167 | 0.864407 | 1.44355969 | Stemonaria longa | 1258717 | Evosea | other_Eukaryota | 243 | 7.739999999999999e-60 | NTclustered | gi|426281758|gb|JX681132.1| | 1258717 | g14725 | i0 | 93.293 | 98.311377245509 | 164 | 11 | 98 | 0 | 4 | 167 | 718 | 555 | Stemonaria longa actin gene, partial cds | blastn | 16418 | 243 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Stemonitida | Stemonitidae | Stemonaria | Stemonaria longa | ||
| 10397321 | 10397321 | PRJNA1087264_P_NODE_11829_length_183_cov_1.641791_g11747_i0 | PRJNA1087264 | 11829 | 183 | 1.641791 | 3.00447753 | Vannella sp. BEN3V | 1215631 | Discosea | other_Eukaryota | 259 | 8.56e-65 | NTclustered | gi|399764216|gb|JQ271727.1| | 1215631 | g11747 | i0 | 92.473 | 100.666666666667 | 186 | 7 | 100 | 5 | 1 | 183 | 626 | 807 | Vannella sp. BEN3V 18S ribosomal RNA gene, partial sequence | blastn | 18422 | 259 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Vannella | Vannella sp. BEN3V | |||
| 12947787 | 12947787 | PRJNA1087264_P_NODE_371_length_1032_cov_2.307223_g321_i0 | PRJNA1087264 | 371 | 1032 | 2.307223 | 23.81054136 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 837 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g321 | i0 | 94.679 | 52.9147286821705 | 545 | 19 | 53 | 8 | 1 | 542 | 538 | 1 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 54608 | 837 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 13770797 | 13770797 | PRJNA1087264_P_NODE_3491_length_351_cov_2.298013_g3409_i0 | PRJNA1087264 | 3491 | 351 | 2.298013 | 8.06602563 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 278 | 5.03e-70 | NTclustered | gi|53829569|gb|AY582837.1| | 43142 | g3409 | i0 | 80.966 | 83.0740740740741 | 352 | 65 | 100 | 2 | 1 | 351 | 574 | 924 | Acanthamoeba culbertsoni HSP70 gene, partial cds | blastn | 29159 | 278 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba culbertsoni | |||
| 14222745 | 14222745 | PRJNA1087264_P_NODE_1812_length_500_cov_1.432373_g1732_i0 | PRJNA1087264 | 1812 | 500 | 1.432373 | 7.161865 | Cochliopodium minus | 313997 | Discosea | other_Eukaryota | 649 | 0 | NTclustered | gi|330902862|gb|JF298257.1| | 313997 | g1732 | i0 | 91.649 | 46.942 | 479 | 23 | 100 | 12 | 1 | 468 | 625 | 153 | Cochliopodium minus 18S ribosomal RNA gene, partial sequence | blastn | 23471 | 649 | 1 | Eukaryota | Amoebozoa | Discosea | Himatismenida | Cochliopodiidae | Cochliopodium | Cochliopodium minus | |||
| 15496649 | 15496649 | PRJNA1087264_P_NODE_11733_length_184_cov_1.214815_g11651_i0 | PRJNA1087264 | 11733 | 184 | 1.214815 | 2.2352596 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 71.3 | 4.33e-8 | NTclustered | gi|831770523|ref|XM_012897573.1| | 1410327 | g11651 | i0 | 95.455 | 0.239130434782609 | 44 | 2 | 24 | 0 | 2 | 45 | 395 | 352 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 44 | 71.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 15496760 | 15496760 | PRJNA1087264_P_NODE_6813_length_242_cov_1.860104_g6731_i0 | PRJNA1087264 | 6813 | 242 | 1.860104 | 4.50145168 | Arcyria similaris | 3080334 | Evosea | other_Eukaryota | 158 | 4.49e-34 | NTclustered | gi|2694740592|gb|OR672140.1| | 3080334 | g6731 | i0 | 79.736 | 22.8099173553719 | 227 | 38 | 92 | 6 | 20 | 242 | 238 | 16 | Arcyria similaris isolate HFNNU4396 translation elongation factor 1-alpha (EF1A) gene, partial cds | blastn | 5520 | 158 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Trichiida | Trichiidae | Arcyria | Arcyria similaris | ||
| 16319961 | 16319961 | PRJNA1087264_P_NODE_17373_length_165_cov_0.879310_g17291_i0 | PRJNA1087264 | 17373 | 165 | 0.87931 | 1.4508615 | Eukaryota | 2759 | unresolved_Eukaryota | other_Eukaryota | 300 | 4.46e-77 | NTclustered | gi|319923643|gb|HQ227714.1| | 590481 | g17291 | i0 | 99.394 | 97.2787878787879 | 165 | 1 | 100 | 0 | 1 | 165 | 363 | 199 | Uncultured Amoebozoa clone plate106h02b 18S ribosomal RNA gene, partial sequence | blastn | 16051 | 300 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 16770944 | 16770944 | PRJNA1087264_P_NODE_12034_length_182_cov_1.150376_g11952_i0 | PRJNA1087264 | 12034 | 182 | 1.150376 | 2.09368432 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 154 | 4.13e-33 | NTclustered | gi|330845916|ref|XM_003294762.1| | 5786 | g11952 | i0 | 82.873 | 4.27472527472527 | 181 | 22 | 96 | 8 | 1 | 175 | 481 | 304 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_100069), partial mRNA | blastn | 778 | 154 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 18045704 | 18045704 | PRJNA1087264_P_NODE_11875_length_183_cov_1.141791_g11793_i0 | PRJNA1087264 | 11875 | 183 | 1.141791 | 2.08947753 | Tieghemostelium lacteum | 361077 | Evosea | other_Eukaryota | 178 | 2.4599999999999998e-40 | NTclustered | gi|354683888|gb|JN048920.1| | 361077 | g11793 | i0 | 85.143 | 2.18032786885246 | 175 | 25 | 96 | 1 | 5 | 179 | 315 | 142 | Tieghemostelium lacteum 60S ribosomal protein L5 gene, complete cds | blastn | 399 | 178 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Raperosteliaceae | Tieghemostelium | Tieghemostelium lacteum | ||
| 18869079 | 18869079 | PRJNA1087264_P_NODE_335_length_1083_cov_1.554159_g289_i0 | PRJNA1087264 | 335 | 1083 | 1.554159 | 16.83154197 | Dictyostelium | 5782 | Evosea | other_Eukaryota | 691 | 0 | NTclustered | gi|7276|emb|X55972.1| | 44689 | g289 | i0 | 78.742 | 72.6445060018467 | 1049 | 211 | 96 | 11 | 1 | 1043 | 1058 | 16 | D. discoideum EF1-II gene for elongation factor 1 alpha | blastn | 78674 | 693 | 0.997113997113997 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 23146304 | 23146304 | PRJNA1087264_P_NODE_8079_length_222_cov_1.173410_g7997_i0 | PRJNA1087264 | 8079 | 222 | 1.17341 | 2.6049702 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 300 | 6.37e-77 | NTclustered | gi|1160564476|ref|XM_020583030.1| | 670386 | g7997 | i0 | 90.991 | 99.2792792792793 | 222 | 20 | 100 | 0 | 1 | 222 | 229 | 450 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 22040 | 300 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album |
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);;