contig_metadata
8 rows where analysis = "blastn", bioproject = "PRJNA915212" and tax_phylum = "Discosea"
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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 895106 | 895106 | PRJNA915212_P_NODE_6481_length_230_cov_1.265193_g6443_i0 | PRJNA915212 | 6481 | 230 | 1.265193 | 2.9099439 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 100 | 7.23e-17 | NTclustered | gi|470428251|ref|XM_004338026.1| | 1257118 | g6443 | i0 | 80.62 | 0.560869565217391 | 129 | 25 | 56 | 0 | 3 | 131 | 562 | 690 | Acanthamoeba castellanii str. Neff TolAlike protein (ACA1_224400), partial mRNA | blastn | 129 | 100 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 2170501 | 2170501 | PRJNA915212_P_NODE_1282_length_590_cov_2.353050_g1250_i0 | PRJNA915212 | 1282 | 590 | 2.35305 | 13.882995 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 322 | 4.03e-83 | NTclustered | gi|470484553|ref|XM_004344028.1| | 1257118 | g1250 | i0 | 79.866 | 45.6677966101695 | 447 | 84 | 75 | 5 | 1 | 444 | 539 | 96 | Acanthamoeba castellanii str. Neff Sadenosyl-L-homocysteine hydrolase, putative (ACA1_054200), partial mRNA | blastn | 26944 | 322 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 3446027 | 3446027 | PRJNA915212_P_NODE_4643_length_280_cov_1.103896_g4605_i0 | PRJNA915212 | 4643 | 280 | 1.103896 | 3.0909088 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 159 | 1.48e-34 | NTclustered | gi|470439750|ref|XM_004339178.1| | 1257118 | g4605 | i0 | 80.676 | 0.739285714285714 | 207 | 38 | 74 | 2 | 64 | 269 | 408 | 203 | Acanthamoeba castellanii str. Neff GDPassociated inhibitor, putative (ACA1_058790), partial mRNA | blastn | 207 | 159 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 5998359 | 5998359 | PRJNA915212_P_NODE_1505_length_543_cov_3.042510_g1470_i0 | PRJNA915212 | 1505 | 543 | 3.04251 | 16.5208293 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 243 | 2.950000000000001e-59 | NTclustered | gi|470529917|ref|XM_004368096.1| | 1257118 | g1470 | i0 | 81.126 | 55.5046040515654 | 302 | 57 | 56 | 0 | 102 | 403 | 422 | 121 | Acanthamoeba castellanii str. Neff ribosomal protein S17, putative (ACA1_292890), partial mRNA | blastn | 30139 | 243 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 8548048 | 8548048 | PRJNA915212_P_NODE_10747_length_175_cov_1.579365_g10709_i0 | PRJNA915212 | 10747 | 175 | 1.579365 | 2.76388875 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 134 | 5.12e-27 | NTclustered | gi|470510585|ref|XM_004351497.1| | 1257118 | g10709 | i0 | 85.714 | 10.1485714285714 | 126 | 18 | 72 | 0 | 2 | 127 | 934 | 809 | Acanthamoeba castellanii str. Neff transport protein Sec61 alpha subunit, putative (ACA1_149400), partial mRNA | blastn | 1776 | 134 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 16553525 | 16553525 | PRJNA915212_P_NODE_1773_length_498_cov_8.632517_g1738_i0 | PRJNA915212 | 1773 | 498 | 8.632517 | 42.98993466 | Vannellidae | 95227 | Discosea | other_Eukaryota | 725 | 0 | NTclustered | gi|62865947|gb|AY929922.1| | 325065 | g1738 | i0 | 93.426 | 100.570281124498 | 502 | 12 | 100 | 16 | 1 | 498 | 1187 | 1671 | Platyamoeba sp. strain CAZ7/I 18S small subunit ribosomal RNA gene, partial sequence | blastn | 50084 | 728 | 0.995879120879121 | Eukaryota | Amoebozoa | Discosea | Flabellinia | Vannellidae | Platyamoeba | Platyamoeba sp. strain CAZ7/I | |||
| 23847455 | 23847455 | PRJNA915212_P_NODE_8219_length_203_cov_1.545455_g8181_i0 | PRJNA915212 | 8219 | 203 | 1.545455 | 3.13727365 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 226 | 9.849999999999997e-55 | NTclustered | gi|927486|emb|X79205.1| | 5755 | g8181 | i0 | 86.765 | 87.2610837438424 | 204 | 25 | 100 | 2 | 1 | 203 | 997 | 795 | A.castellanii mRNA for methionine adenosyltransferase | blastn | 17714 | 226 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii | |||
| 25121217 | 25121217 | PRJNA915212_P_NODE_1980_length_471_cov_1.696682_g1945_i0 | PRJNA915212 | 1980 | 471 | 1.696682 | 7.99137222 | Acanthamoeba castellanii | 5755 | Discosea | other_Eukaryota | 355 | 3.12e-93 | NTclustered | gi|470484553|ref|XM_004344028.1| | 1257118 | g1945 | i0 | 87.066 | 70.0021231422505 | 317 | 37 | 67 | 4 | 120 | 433 | 593 | 908 | Acanthamoeba castellanii str. Neff Sadenosyl-L-homocysteine hydrolase, putative (ACA1_054200), partial mRNA | blastn | 32971 | 355 | 1 | Eukaryota | Amoebozoa | Discosea | Longamoebia | Acanthamoebidae | Acanthamoeba | Acanthamoeba castellanii |
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);;