contig_metadata
12 rows where analysis = "blastn", bioproject = "PRJNA976345" 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3498366 | 3498366 | PRJNA976345_P_NODE_125703_length_177_cov_2.781690_g124095_i0 | PRJNA976345 | 125703 | 177 | 2.78169 | 4.9235913 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|66813473|ref|XM_635824.1| | 352472 | g124095 | i0 | 96.875 | 0.180790960451977 | 32 | 1 | 18 | 0 | 110 | 141 | 1956 | 1987 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0281257) mRNA, complete cds | blastn | 32 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 3498908 | 3498908 | PRJNA976345_P_NODE_24563_length_339_cov_4.200658_g22960_i0 | PRJNA976345 | 24563 | 339 | 4.200658 | 14.24023062 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 58.4 | 6.88e-4 | NTclustered | gi|831782199|ref|XM_012901153.1| | 1410327 | g22960 | i0 | 100 | 0.176991150442478 | 31 | 0 | 9 | 0 | 106 | 136 | 185 | 155 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 60 | 58.4 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 6051021 | 6051021 | PRJNA976345_P_NODE_135885_length_172_cov_3.656934_g134277_i0 | PRJNA976345 | 135885 | 172 | 3.656934 | 6.28992648 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.014 | NTclustered | gi|66828268|ref|XM_642397.1| | 352472 | g134277 | i0 | 100 | 0.162790697674419 | 28 | 0 | 16 | 0 | 68 | 95 | 1574 | 1547 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0268420) mRNA, complete cds | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 7325557 | 7325557 | PRJNA976345_P_NODE_113606_length_181_cov_2.178082_g111998_i0 | PRJNA976345 | 113606 | 181 | 2.178082 | 3.94232842 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|1160566148|ref|XM_020580696.1| | 670386 | g111998 | i0 | 100 | 0.154696132596685 | 28 | 0 | 15 | 0 | 80 | 107 | 124 | 151 | Polysphondylium pallidum PN500 hypothetical protein partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 8600558 | 8600558 | PRJNA976345_P_NODE_109787_length_183_cov_3.135135_g108179_i0 | PRJNA976345 | 109787 | 183 | 3.135135 | 5.73729705 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 333 | 4.97e-87 | NTclustered | gi|262262899|gb|FJ766442.1| | 472931 | g108179 | i0 | 100 | 32.0054644808743 | 180 | 0 | 98 | 0 | 4 | 183 | 726 | 547 | Protostelium mycophagum strain TB-A2-1 small subunit ribosomal RNA gene, partial sequence | blastn | 5857 | 333 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 8919733 | 8919733 | PRJNA976345_P_NODE_100207_length_190_cov_1.012903_g98599_i0 | PRJNA976345 | 100207 | 190 | 1.012903 | 1.9245157 | root | 1 | Root_unresolved | Root_unresolved | 346 | 6.690000000000001e-91 | NTclustered | gi|1057487664|gb|KX539393.1| | 133408 | g98599 | i0 | 99.474 | 100 | 190 | 1 | 100 | 0 | 1 | 190 | 366 | 555 | Acytostelium leptosomum strain FG12A RNA polymerase I (rpa1) gene, partial cds | blastn | 19000 | 346 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum | ||
| 11151255 | 11151255 | PRJNA976345_P_NODE_115689_length_180_cov_1.813793_g114081_i0 | PRJNA976345 | 115689 | 180 | 1.813793 | 3.2648274 | Protostelium mycophagum | 472931 | Evosea | other_Eukaryota | 327 | 2.2699999999999996e-85 | NTclustered | gi|262262899|gb|FJ766442.1| | 472931 | g114081 | i0 | 99.444 | 49.5833333333333 | 180 | 1 | 100 | 0 | 1 | 180 | 1237 | 1416 | Protostelium mycophagum strain TB-A2-1 small subunit ribosomal RNA gene, partial sequence | blastn | 8925 | 327 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | Protostelium | Protostelium mycophagum | ||
| 16251588 | 16251588 | PRJNA976345_P_NODE_63933_length_224_cov_1.740741_g62325_i0 | PRJNA976345 | 63933 | 224 | 1.740741 | 3.89925984 | Entamoeba dispar | 46681 | Evosea | other_Eukaryota | 52.8 | 0.02 | NTclustered | gi|167391950|ref|XM_001739911.1| | 370354 | g62325 | i0 | 100 | 0.125 | 28 | 0 | 13 | 0 | 130 | 157 | 312 | 339 | Entamoeba dispar SAW760 serine/threonine protein phosphatase, putative (EDI_228200), partial mRNA | blastn | 28 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba dispar | |||
| 17525662 | 17525662 | PRJNA976345_P_NODE_104074_length_187_cov_1.750000_g102466_i0 | PRJNA976345 | 104074 | 187 | 1.75 | 3.2725 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 54.7 | 0.004 | NTclustered | gi|3068582|gb|AF000580.1|AF000580 | 44689 | g102466 | i0 | 100 | 0.155080213903743 | 29 | 0 | 16 | 0 | 86 | 114 | 11679 | 11707 | Dictyostelium discoideum plasmid Ddp5, complete genome | blastn | 29 | 54.7 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 22625246 | 22625246 | PRJNA976345_P_NODE_196378_length_151_cov_1.034483_g194770_i0 | PRJNA976345 | 196378 | 151 | 1.034483 | 1.56206933 | Heterostelium album | 2086695 | Evosea | other_Eukaryota | 171 | 3.26e-38 | NTclustered | gi|1160558366|ref|XM_020576016.1| | 670386 | g194770 | i0 | 90.076 | 87.9470198675497 | 131 | 13 | 87 | 0 | 21 | 151 | 946 | 1076 | Polysphondylium pallidum PN500 actin domain-containing protein (fia), partial mRNA | blastn | 13280 | 171 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Heterostelium | Heterostelium album | ||
| 23900168 | 23900168 | PRJNA976345_P_NODE_111659_length_182_cov_2.476190_g110051_i0 | PRJNA976345 | 111659 | 182 | 2.47619 | 4.5066658 | Dictyostelium discoideum | 44689 | Evosea | other_Eukaryota | 52.8 | 0.015 | NTclustered | gi|66812931|ref|XM_635553.1| | 352472 | g110051 | i0 | 94.286 | 0.192307692307692 | 35 | 1 | 19 | 1 | 61 | 95 | 408 | 375 | Dictyostelium discoideum AX4 hypothetical protein (DDB_G0281789) mRNA, complete cds | blastn | 35 | 52.8 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium discoideum | ||
| 23900598 | 23900598 | PRJNA976345_P_NODE_17379_length_405_cov_2.143243_g15788_i0 | PRJNA976345 | 17379 | 405 | 2.143243 | 8.68013415 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 56.5 | 0.003 | NTclustered | gi|330789920|ref|XM_003282999.1| | 5786 | g15788 | i0 | 92.5 | 0.0987654320987654 | 40 | 2 | 10 | 1 | 190 | 229 | 834 | 796 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_146659), partial mRNA | blastn | 40 | 56.5 | 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);;