contig_metadata
13 rows where analysis = "blastn", bioproject = "PRJNA407886" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1692621 | 1692621 | PRJNA407886_P_NODE_59542_length_275_cov_2.202970_g57848_i0 | PRJNA407886 | 59542 | 275 | 2.20297 | 6.0581675 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 248 | 3e-61 | NTclustered | gi|470525569|ref|XM_004356569.1| | 1257118 | g57848 | i0 | 83.395 | 1.78545454545455 | 271 | 41 | 98 | 4 | 7 | 275 | 760 | 492 | Acanthamoeba castellanii str. Neff mitochondrial phosphate transporter, putative (ACA1_173800), partial mRNA | blastn | 491 | 248 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 2968135 | 2968135 | PRJNA407886_P_NODE_41823_length_337_cov_1.742424_g40129_i0 | PRJNA407886 | 41823 | 337 | 1.742424 | 5.87196888 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 222 | 2.29e-53 | NTclustered | gi|1160557950|ref|XM_020575808.1| | 670386 | g40129 | i0 | 89.655 | 61.1008902077151 | 174 | 18 | 52 | 0 | 146 | 319 | 1332 | 1159 | Polysphondylium pallidum PN500 ubiquitin (ubqI), partial mRNA | blastn | 20591 | 222 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 2968285 | 2968285 | PRJNA407886_P_NODE_49443_length_306_cov_1.789700_g47749_i0 | PRJNA407886 | 49443 | 306 | 1.7897 | 5.476482 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|66803509|ref|XM_630506.1| | 352472 | g47749 | i0 | 97.059 | 0.111111111111111 | 34 | 0 | 11 | 1 | 146 | 178 | 47 | 14 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0290691) mRNA, complete cds | blastn | 34 | 56.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 4244015 | 4244015 | PRJNA407886_P_NODE_19604_length_579_cov_22.689723_g17923_i0 | PRJNA407886 | 19604 | 579 | 22.689723 | 131.37349617 | Ripella platypodia | 2047821 | Discosea | other_Eukaryota | 913 | 0 | NTclustered | gi|1269228359|gb|MF683484.1| | 2047821 | g17923 | i0 | 95.197 | 100.697754749568 | 583 | 18 | 100 | 7 | 1 | 579 | 1072 | 1648 | Ripella platypodia clone 23.4.34 18S ribosomal RNA gene, partial sequence | blastn | 58304 | 913 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella platypodia | |||
| 8071423 | 8071423 | PRJNA407886_P_NODE_78307_length_244_cov_0.900585_g76613_i0 | PRJNA407886 | 78307 | 244 | 0.900585 | 2.1974274 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 62.1 | 3.66e-5 | NTclustered | gi|831771740|ref|XM_012897941.1| | 1410327 | g76613 | i0 | 93.023 | 0.290983606557377 | 43 | 2 | 18 | 1 | 139 | 181 | 36 | 77 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 71 | 62.1 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 9346192 | 9346192 | PRJNA407886_P_NODE_75828_length_246_cov_0.890173_g74134_i0 | PRJNA407886 | 75828 | 246 | 0.890173 | 2.18982558 | Cavenderia medusoides | 361117 | Evosea | other_Eukaryota | 191 | 4.51e-44 | NTclustered | gi|169930320|gb|EU360785.1| | 361117 | g74134 | i0 | 81.328 | 44.4308943089431 | 241 | 40 | 97 | 5 | 2 | 240 | 553 | 790 | Cavenderia medusoides isolate OH592 elongation factor 1 alpha gene, partial cds | blastn | 10930 | 191 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Cavenderiaceae | Cavenderia | Cavenderia medusoides | ||
| 10621163 | 10621163 | PRJNA407886_P_NODE_33449_length_388_cov_2.596825_g31755_i0 | PRJNA407886 | 33449 | 388 | 2.596825 | 10.075681 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 235 | 3.43e-57 | NTclustered | gi|330845446|ref|XM_003294549.1| | 5786 | g31755 | i0 | 80.435 | 4.53865979381443 | 322 | 51 | 81 | 8 | 6 | 321 | 223 | 538 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_93248), mRNA | blastn | 1761 | 235 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 11897142 | 11897142 | PRJNA407886_P_NODE_9570_length_1015_cov_22.805732_g8350_i0 | PRJNA407886 | 9570 | 1015 | 22.805732 | 231.4781798 | Ripella sp. 805 | 1217113 | Discosea | other_Eukaryota | 878 | 0 | NTclustered | gi|399764202|gb|JQ271713.1| | 1217113 | g8350 | i0 | 95.332 | 55.1655172413793 | 557 | 18 | 54 | 6 | 2 | 554 | 553 | 1 | Ripella sp. 805 18S ribosomal RNA gene, partial sequence | blastn | 55993 | 878 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Ripella | Ripella sp. 805 | |||
| 14446178 | 14446178 | PRJNA407886_P_NODE_34812_length_378_cov_3.013115_g33118_i0 | PRJNA407886 | 34812 | 378 | 3.013115 | 11.3895747 | uncultured Amoebozoa | 590481 | Root_unresolved | Root_unresolved | 459 | 1.8199999999999999e-124 | NTclustered | gi|221185864|gb|FJ577811.1| | 590481 | g33118 | i0 | 91.117 | 52.6428571428571 | 349 | 15 | 89 | 13 | 42 | 377 | 664 | 1009 | Uncultured Amoebozoa clone Ivry07 18S ribosomal RNA gene, partial sequence | blastn | 19899 | 459 | 1 | Eukaryota | Amoebozoa | uncultured Amoebozoa | |||||||
| 16995481 | 16995481 | PRJNA407886_P_NODE_71294_length_250_cov_0.870056_g69600_i0 | PRJNA407886 | 71294 | 250 | 0.870056 | 2.17514 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 143 | 1.31e-29 | NTclustered | gi|831771575|ref|XM_012897889.1| | 1410327 | g69600 | i0 | 77.5 | 59.704 | 240 | 52 | 96 | 2 | 10 | 248 | 401 | 163 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 14926 | 143 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 20819419 | 20819419 | PRJNA407886_P_NODE_60017_length_274_cov_1.532338_g58323_i0 | PRJNA407886 | 60017 | 274 | 1.532338 | 4.19860612 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 56.5 | 0.002 | NTclustered | gi|470482349|ref|XM_004342971.1| | 1257118 | g58323 | i0 | 100 | 0.109489051094891 | 30 | 0 | 11 | 0 | 191 | 220 | 480 | 451 | Acanthamoeba castellanii str. Neff cathepsin L, putative (ACA1_317670), partial mRNA | blastn | 30 | 56.5 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 20819540 | 20819540 | PRJNA407886_P_NODE_65577_length_260_cov_1.647059_g63883_i0 | PRJNA407886 | 65577 | 260 | 1.647059 | 4.2823534 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 95.3 | 3.88e-15 | NTclustered | gi|831761070|ref|XM_012894692.1| | 1410327 | g63883 | i0 | 87.654 | 3.4 | 81 | 10 | 31 | 0 | 177 | 257 | 319 | 399 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 884 | 95.3 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 24644208 | 24644208 | PRJNA407886_P_NODE_63940_length_264_cov_1.602094_g62246_i0 | PRJNA407886 | 63940 | 264 | 1.602094 | 4.22952816 | Platyamoeba placida | 3454475 | Discosea | other_Eukaryota | 333 | 7.689999999999999e-87 | NTclustered | gi|33946348|gb|AY294153.1| | 197527 | g62246 | i0 | 89.394 | 95.5037878787879 | 264 | 28 | 100 | 0 | 1 | 264 | 870 | 607 | Platyamoeba placida actin mRNA, partial cds | blastn | 25213 | 333 | 1 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba placida |
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);;