contig_metadata
10 rows where analysis = "blastn", bioproject = "PRJNA312899" and tax_phylum = "Evosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 380517 | 380517 | PRJNA312899_P_NODE_98341_length_162_cov_3.610619_g97899_i0 | PRJNA312899 | 98341 | 162 | 3.610619 | 5.84920278 | Entamoeba histolytica | 5759 | Evosea | other_Eukaryota | 110 | 7.89e-20 | NTclustered | gi|415339|emb|X65163.1| | 5759 | g97899 | i0 | 88.043 | 0.567901234567901 | 92 | 11 | 57 | 0 | 71 | 162 | 5710 | 5619 | E.histolytica rRNA | blastn | 92 | 110 | 1 | Eukaryota | Amoebozoa | Evosea | Mastigamoebida | Entamoebidae | Entamoeba | Entamoeba histolytica | |||
| 8032596 | 8032596 | PRJNA312899_P_NODE_32587_length_320_cov_19.789668_g32145_i0 | PRJNA312899 | 32587 | 320 | 19.789668 | 63.3269376 | Echinostelium minutum | 300235 | Evosea | other_Eukaryota | 571 | 1.86e-158 | NTclustered | gi|210062522|gb|AY842034.2| | 300235 | g32145 | i0 | 99.057 | 20.015625 | 318 | 3 | 99 | 0 | 3 | 320 | 1866 | 2183 | Echinostelium minutum strain ATCC 22345 18S ribosomal RNA gene, partial sequence | blastn | 6405 | 571 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Echinosteliales | Echinosteliidae | Echinostelium | Echinostelium minutum | ||
| 9307146 | 9307146 | PRJNA312899_P_NODE_18948_length_433_cov_89.127604_g18507_i0 | PRJNA312899 | 18948 | 433 | 89.127604 | 385.92252532 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 549 | 1.2199999999999996e-151 | NTclustered | gi|2687|emb|X60210.1| | 5793 | g18507 | i0 | 89.498 | 9.18937644341801 | 438 | 40 | 100 | 6 | 1 | 433 | 5491 | 5055 | D.iridis LSU rRNA gene | blastn | 3979 | 549 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 9307452 | 9307452 | PRJNA312899_P_NODE_36428_length_299_cov_7.492000_g35986_i0 | PRJNA312899 | 36428 | 299 | 7.492 | 22.40108 | Coremiostelium polycephalum | 142831 | Evosea | other_Eukaryota | 93.5 | 1.64e-14 | NTclustered | gi|85062629|gb|DQ340387.1| | 142831 | g35986 | i0 | 88.312 | 26.8494983277592 | 77 | 9 | 26 | 0 | 207 | 283 | 12448 | 12524 | Dictyostelium polycephalum 17S ribosomal RNA, 5.8S ribosomal RNA, and 26S ribosomal RNA genes, complete sequence | blastn | 8028 | 93.5 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Coremiostelium | Coremiostelium polycephalum | |||
| 10584215 | 10584215 | PRJNA312899_P_NODE_8869_length_634_cov_8.873504_g8479_i0 | PRJNA312899 | 8869 | 634 | 8.873504 | 56.25801536 | Acytostelium subglobosum | 361139 | Evosea | other_Eukaryota | 329 | 2.6e-85 | NTclustered | gi|831754130|ref|XM_012892568.1| | 1410327 | g8479 | i0 | 82.415 | 63.2397476340694 | 381 | 64 | 60 | 3 | 204 | 582 | 441 | 62 | Acytostelium subglobosum LB1 hypothetical protein partial mRNA | blastn | 40094 | 329 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium subglobosum | ||
| 11267590 | 11267590 | PRJNA312899_P_NODE_21589_length_404_cov_19.360563_g21148_i0 | PRJNA312899 | 21589 | 404 | 19.360563 | 78.21667452 | Didymium | 5792 | Evosea | other_Eukaryota | 649 | 0 | NTclustered | gi|117165666|dbj|AB259388.1| | 289975 | g21148 | i0 | 96.447 | 99.6608910891089 | 394 | 12 | 98 | 2 | 1 | 394 | 31 | 422 | Didymium bahiense gene for small subunit ribosomal RNA, partial sequence, specimen_voucher: TNS-M-Y-4948 (TNS) | blastn | 40263 | 651 | 0.996927803379416 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium bahiense | ||
| 13134050 | 13134050 | PRJNA312899_P_NODE_87171_length_167_cov_0.864407_g86729_i0 | PRJNA312899 | 87171 | 167 | 0.864407 | 1.44355969 | Acytostelium leptosomum | 133408 | Evosea | other_Eukaryota | 298 | 1.63e-76 | NTclustered | gi|1057487862|gb|KX539491.1| | 133408 | g86729 | i0 | 98.802 | 102.790419161677 | 167 | 2 | 100 | 0 | 1 | 167 | 3118 | 3284 | Acytostelium leptosomum strain FG12A dihydrolipoamide acetyltransferase (pdhC) gene, complete cds | blastn | 17166 | 298 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Acytosteliales | Acytosteliaceae | Acytostelium | Acytostelium leptosomum | ||
| 14408260 | 14408260 | PRJNA312899_P_NODE_29992_length_337_cov_4.347222_g29550_i0 | PRJNA312899 | 29992 | 337 | 4.347222 | 14.65013814 | Didymium iridis | 5793 | Evosea | other_Eukaryota | 529 | 1.2099999999999994e-145 | NTclustered | gi|116010570|emb|AM407415.1| | 5793 | g29550 | i0 | 95.509 | 69.2611275964392 | 334 | 10 | 98 | 5 | 3 | 333 | 1008 | 1339 | Didymium iridis partial 26S rRNA gene, isolate CR8-1 | blastn | 23341 | 529 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Physariida | Didymiaceae | Didymium | Didymium iridis | ||
| 18231227 | 18231227 | PRJNA312899_P_NODE_41275_length_277_cov_3.442982_g40833_i0 | PRJNA312899 | 41275 | 277 | 3.442982 | 9.53706014 | Dictyostelium purpureum | 5786 | Evosea | other_Eukaryota | 60.2 | 1.52e-4 | NTclustered | gi|330802404|ref|XM_003289160.1| | 5786 | g40833 | i0 | 100 | 0.115523465703971 | 32 | 0 | 12 | 0 | 216 | 247 | 3619 | 3588 | Dictyostelium purpureum uncharacterized protein (DICPUDRAFT_153539), partial mRNA | blastn | 32 | 60.2 | 1 | Eukaryota | Amoebozoa | Evosea | Eumycetozoa | Dictyosteliales | Dictyosteliaceae | Dictyostelium | Dictyostelium purpureum | ||
| 20780602 | 20780602 | PRJNA312899_P_NODE_16797_length_460_cov_16.155718_g16358_i0 | PRJNA312899 | 16797 | 460 | 16.155718 | 74.3163028 | uncultured Soliformovum | 2510342 | Evosea | other_Eukaryota | 730 | 0 | NTclustered | gi|1564356923|gb|MK443523.1| | 2510342 | g16358 | i0 | 97.647 | 40.9434782608696 | 425 | 10 | 92 | 0 | 32 | 456 | 425 | 1 | Uncultured Soliformovum clone OTUA345 small subunit ribosomal RNA gene, partial sequence; mitochondrial | blastn | 18834 | 730 | 1 | Eukaryota | Amoebozoa | Evosea | Variosea | Protosteliida | Protosteliaceae | uncultured Soliformovum |
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);;