metadata: contig_metadata: 5 rows where bioproject = "PRJNA382357", tax_clade = "Amoebozoa" and tax

5 rows where bioproject = "PRJNA382357", tax_clade = "Amoebozoa" and tax_phylum = "Discosea"

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
10607387	10607387	PRJNA382357_P_NODE_29749_length_413_cov_37525.988636_g29011_i0	PRJNA382357	29749	413	37525.988636	154982.33306668	Acanthamoeba sp. Ac_E12d	931326	Discosea	other_Eukaryota	472	2.5699999999999997e-128	NTclustered	gi\|313493458\|gb\|GU808310.1\|	931326	g29011	i0	92.216	76.0314769975787	334	24	100	2	1	332	2023	1690	Acanthamoeba sp. Ac_E12d small subunit ribosomal RNA gene, partial sequence	blastn	31401	472	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba sp. Ac_E12d
13156441	13156441	PRJNA382357_P_NODE_127811_length_216_cov_1.722581_g127072_i0	PRJNA382357	127811	216	1.722581	3.72077496	Cochliopodium larifeili	1017091	Discosea	other_Eukaryota	122	1.43e-23	NTclustered	gi\|330902889\|gb\|JF298269.1\|	1017091	g127072	i0	90.323	32.1157407407407	93	9	43	0	124	216	231	139	Cochliopodium larifeili clone 1807 actin gene, partial cds	blastn	6937	122	1	Eukaryota	Amoebozoa	Discosea		Himatismenida	Cochliopodiidae	Cochliopodium	Cochliopodium larifeili
20201321	20201321	PRJNA382357_P_NODE_47116_length_337_cov_3.355072_g46377_i0	PRJNA382357	47116	337	3.355072	11.30659264	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	87.9	8.72e-13	NTclustered	gi\|398850\|emb\|X73881.1\|	5755	g46377	i0	98	14.2818991097923	50	1	15	0	89	138	513	464	A.castellanii gene for 26S ribosomal RNA	blastn	4813	87.9	1	Eukaryota	Amoebozoa	Discosea		Longamoebia	Acanthamoebidae	Acanthamoeba	Acanthamoeba castellanii
23355992	23355992	PRJNA382357_P_NODE_46739_length_338_cov_7.722022_g46000_i0	PRJNA382357	46739	338	7.722022	26.10043436	Ripella platypodia	2047821	Discosea	other_Eukaryota	516	9.41e-142	NTclustered	gi\|1269228358\|gb\|MF683483.1\|	2047821	g46000	i0	97.368	98.9260355029586	304	6	100	2	37	338	1529	1226	Ripella platypodia clone 23.4.33 18S ribosomal RNA gene, partial sequence	blastn	33437	516	1	Eukaryota	Amoebozoa	Discosea	Flabellinia		Vannellidae	Ripella	Ripella platypodia
26948355	26948355	PRJNA382357_P_NODE_101402_length_240_cov_491.061453_g100663_i0	PRJNA382357	101402	240	491.061453	1178.5474872	Acanthamoeba castellanii str. Neff	1257118	Discosea	other_Eukaryota	48.1	4.57e-4	NR	XP_004341866.1	1257118	g100663	i0	46.8	0.5875	47	25	58.8	0	100	240	135	181	XP_004341866.1 transmembrane 9 superfamily protein member 4, putative [Acanthamoeba castellanii str. Neff]	diamond	141	48.1	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);;