metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA293022" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA293022" and tax_phylum = "Evosea"

descending

Link	rowid ▼	query	bioproject	node	length	coverage	rel_abundance	taxname_lca	taxid_lca	taxoncategory	taxoncategorysimple	bits	evalue	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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
11851971	11851971	PRJNA293022_P_NODE_47470_length_202_cov_2.640523_g46733_i0	PRJNA293022	47470	202	2.640523	5.33385646	Heterostelium pallidum	13642	Evosea	other_Eukaryota	84.2	6.24e-12	NTclustered	gi\|160688721\|gb\|EU275726.1\|	13642	g46733	i0	80.531	70.6336633663366	113	19	55	3	6	116	21962	21851	Polysphondylium pallidum strain PN500 mitochondrion, complete genome	blastn	14268	84.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium pallidum
11852130	11852130	PRJNA293022_P_NODE_79450_length_162_cov_0.920354_g78713_i0	PRJNA293022	79450	162	0.920354	1.49097348	Heterostelium pallidum	13642	Evosea	other_Eukaryota	111	2.19e-20	NTclustered	gi\|60117108\|ref\|NC_006862.1\|	13642	g78713	i0	92.5	9.24691358024691	80	3	48	3	4	81	261	183	Polysphondylium pallidum mitochondrion, complete genome	blastn	1498	111	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Acytosteliaceae	Heterostelium	Heterostelium pallidum
14402439	14402439	PRJNA293022_P_NODE_78752_length_162_cov_1.123894_g78015_i0	PRJNA293022	78752	162	1.123894	1.82070828	Protostelium mycophagum	472931	Evosea	other_Eukaryota	279	5.68e-71	NTclustered	gi\|262262901\|gb\|FJ766444.1\|	472931	g78015	i0	98.125	2.98765432098765	160	3	99	0	1	160	740	581	Protostelium mycophagum strain BRNFDF05-11A-3 small subunit ribosomal RNA gene, partial sequence	blastn	484	279	1	Eukaryota	Amoebozoa	Evosea	Variosea	Protosteliida	Protosteliaceae	Protostelium	Protostelium mycophagum
16950705	16950705	PRJNA293022_P_NODE_46654_length_204_cov_2.000000_g45917_i0	PRJNA293022	46654	204	2	4.08	Entamoeba invadens	33085	Evosea	other_Eukaryota	52.8	0.018	NTclustered	gi\|471207746\|ref\|XM_004260429.1\|	370355	g45917	i0	100	0.137254901960784	28	0	14	0	140	167	433	406	Entamoeba invadens IP1 hypothetical protein (EIN_432580) mRNA, complete cds	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba invadens
19499296	19499296	PRJNA293022_P_NODE_65856_length_171_cov_0.852459_g65119_i0	PRJNA293022	65856	171	0.852459	1.45770489	Phalansterium sp. PJK-2012	1267188	Evosea	other_Eukaryota	52.8	0.014	NTclustered	gi\|429125732\|gb\|KC121006.1\|	1267188	g65119	i0	100	0.16374269005848	28	0	16	0	9	36	1417	1390	Phalansterium sp. PJK-2012 mitochondrion, complete genome	blastn	28	52.8	1	Eukaryota	Amoebozoa	Evosea	Variosea			Phalansterium	Phalansterium sp. PJK-2012
22049909	22049909	PRJNA293022_P_NODE_71238_length_167_cov_0.881356_g70501_i0	PRJNA293022	71238	167	0.881356	1.47186452	Coremiostelium polycephalum	142831	Evosea	other_Eukaryota	93.5	8.25e-15	NTclustered	gi\|85062629\|gb\|DQ340387.1\|	142831	g70501	i0	88.312	48.059880239521	77	9	46	0	77	153	12448	12524	Dictyostelium polycephalum 17S ribosomal RNA, 5.8S ribosomal RNA, and 26S ribosomal RNA genes, complete sequence	blastn	8026	93.5	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales		Coremiostelium	Coremiostelium polycephalum
23325272	23325272	PRJNA293022_P_NODE_27379_length_269_cov_1.654545_g26642_i0	PRJNA293022	27379	269	1.654545	4.45072605	Protostelium mycophagum	472931	Evosea	other_Eukaryota	473	4.439999999999999e-129	NTclustered	gi\|262262901\|gb\|FJ766444.1\|	472931	g26642	i0	98.513	64.2044609665428	269	2	99	1	1	267	271	3	Protostelium mycophagum strain BRNFDF05-11A-3 small subunit ribosomal RNA gene, partial sequence	blastn	17271	473	1	Eukaryota	Amoebozoa	Evosea	Variosea	Protosteliida	Protosteliaceae	Protostelium	Protostelium mycophagum
23325293	23325293	PRJNA293022_P_NODE_33659_length_241_cov_1.755208_g32922_i0	PRJNA293022	33659	241	1.755208	4.23005128	Entamoeba gingivalis	38877	Evosea	other_Eukaryota	442	1.0999999999999999e-119	NTclustered	gi\|2425687086\|gb\|OQ225454.1\|	38877	g32922	i0	100	85.7551867219917	239	0	99	0	1	239	371	133	Entamoeba gingivalis isolate IH_ST2 small subunit ribosomal RNA gene and internal transcribed spacer 1, partial sequence	blastn	20667	442	1	Eukaryota	Amoebozoa	Evosea		Mastigamoebida	Entamoebidae	Entamoeba	Entamoeba gingivalis
23325393	23325393	PRJNA293022_P_NODE_59479_length_180_cov_1.923664_g58742_i0	PRJNA293022	59479	180	1.923664	3.4625952	Perichaena vermicularis	2715190	Evosea	other_Eukaryota	141	3.17e-29	NTclustered	gi\|1883421894\|gb\|MT162157.1\|	2715190	g58742	i0	83.784	85.0555555555556	148	24	82	0	1	148	968	821	Perichaena vermicularis voucher BR<BEL>:5020025765604 elongation factor 1-alpha (EF1A) gene, partial cds	blastn	15310	141	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Trichiida	Trichiidae	Perichaena	Perichaena vermicularis

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);;