metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA976345" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA976345" and tax_clade = "Amoebozoa"

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
27120535	27120535	PRJNA976345_P_NODE_132022_length_174_cov_2.467626_g130414_i0	PRJNA976345	132022	174	2.467626	4.29366924	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	93.6	1.36e-21	NR	PRP84349.1	1890364	g130414	i0	84.5	1	58	9	100	0	174	1	144	201	PRP84349.1 hypothetical protein PROFUN_07650 [Planoprotostelium fungivorum]	diamond	174	93.6	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
27784390	27784390	PRJNA976345_P_NODE_127864_length_176_cov_2.758865_g126256_i0	PRJNA976345	127864	176	2.758865	4.8556024	Tieghemostelium lacteum	361077	Evosea	other_Eukaryota	41.6	0.0396	NR	KYQ92121.1	361077	g126256	i0	45.7	0.784090909090909	46	25	78.4	0	27	164	705	750	KYQ92121.1 RapGAP/RanGAP domain-containing protein [Tieghemostelium lacteum]	diamond	138	41.6	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Dictyosteliales	Raperosteliaceae	Tieghemostelium	Tieghemostelium lacteum
29489010	29489010	PRJNA976345_P_NODE_110670_length_183_cov_1.614865_g109062_i0	PRJNA976345	110670	183	1.614865	2.95520295	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	119	1.13e-33	NR	PRP84579.1	1890364	g109062	i0	100	0.967213114754098	59	0	96.7	0	179	3	1	59	PRP84579.1 hypothetical protein PROFUN_09252 [Planoprotostelium fungivorum]	diamond	177	119	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum
29520743	29520743	PRJNA976345_P_NODE_18850_length_388_cov_2.677054_g17255_i0	PRJNA976345	18850	388	2.677054	10.38696952	Cavenderia fasciculata	261658	Evosea	other_Eukaryota	83.2	1.04e-15	NR	XP_004356395.1	261658	g17255	i0	51.2	1.22164948453608	84	36	62.6	5	2	244	341	422	XP_004356395.1 uncharacterized protein DFA_08912 [Cavenderia fasciculata]	diamond	474	83.2	1	Eukaryota	Amoebozoa	Evosea	Eumycetozoa	Acytosteliales	Cavenderiaceae	Cavenderia	Cavenderia fasciculata
31954136	31954136	PRJNA976345_P_NODE_69657_length_217_cov_1.313187_g68049_i0	PRJNA976345	69657	217	1.313187	2.84961579	Planoprotostelium fungivorum	1890364	Evosea	other_Eukaryota	157	9.16e-44	NR	PRP73190.1	1890364	g68049	i0	100	0.995391705069124	72	0	99.5	0	217	2	286	357	PRP73190.1 serine/threonine-protein phosphatase 5 [Planoprotostelium fungivorum]	diamond	216	157	1	Eukaryota	Amoebozoa	Evosea	Variosea	Cavosteliida	Cavosteliaceae	Planoprotostelium	Planoprotostelium fungivorum

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