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

5 rows where analysis = "diamond", bioproject = "PRJNA1069776" and tax_superkingdom = "Archaea"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
6117795	6117795	PRJNA1069776_S_NODE_24825_length_214_cov_3.473684_g24511_i0	PRJNA1069776	24825	214	3.473684	7.43368376	Methanobrevibacter sp.	66852	Archaea	Archaea	140	5.7e-39	NR	WP_330048003.1	66852	g24511	i0	100	2.64953271028037	63	0	88.3	0	212	24	131	193	WP_330048003.1 class I adenylate-forming enzyme family protein, partial [Methanobrevibacter sp.]	diamond	567	140	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
29553363	29553363	PRJNA1069776_S_NODE_31490_length_193_cov_2.506667_g31176_i0	PRJNA1069776	31490	193	2.506667	4.83786731	Thermoproteati	1783275	Archaea	Archaea	98.2	2.1699999999999998e-23	NR	MEM3714555.1	2268198	g31176	i0	68.8	1.98963730569948	64	20	99.5	0	1	192	158	221	MEM3714555.1 hypothetical protein [Nitrososphaeria archaeon]	diamond	384	99	0.991919191919192	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria				Nitrososphaeria archaeon
30004250	30004250	PRJNA1069776_S_NODE_21251_length_229_cov_3.505376_g20937_i0	PRJNA1069776	21251	229	3.505376	8.02731104	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	45.4	0.0035	NR	HIG98717.1	2026803	g20937	i0	40.4	0.615720524017467	47	28	61.6	0	186	46	258	304	HIG98717.1 hypothetical protein [Candidatus Woesearchaeota archaeon]	diamond	141	45.4	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
31268066	31268066	PRJNA1069776_S_NODE_34295_length_185_cov_12.640845_g33981_i0	PRJNA1069776	34295	185	12.640845	23.38556325	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	42	0.033	NR	HEX9318775.1	2169593	g33981	i0	34.4	0.989189189189189	61	31	84.3	2	170	15	504	564	HEX9318775.1 tandem-95 repeat protein [Nitrososphaeraceae archaeon]	diamond	183	42	1	Archaea		Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae		Nitrososphaeraceae archaeon
31489701	31489701	PRJNA1069776_S_NODE_19916_length_236_cov_1.658031_g19602_i0	PRJNA1069776	19916	236	1.658031	3.91295316	Halorubrum sp. SS7	2518119	Archaea	Archaea	41.6	0.0107	NR	WP_206750415.1	2518119	g19602	i0	38.8	0.622881355932203	49	26	58.5	2	44	181	12	59	WP_206750415.1 hypothetical protein, partial [Halorubrum sp. SS7]	diamond	147	41.6	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Halobacteria	Halobacteriales	Haloferacaceae	Halorubrum	Halorubrum sp. SS7

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