metadata: contig_metadata: 5 rows where bioproject = "PRJNA1240805" and tax

5 rows where bioproject = "PRJNA1240805" 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_species
27957970	27957970	PRJNA1240805_P_NODE_3905_length_234_cov_4.248649_g3856_i0	PRJNA1240805	3905	234	4.248649	9.94183866	archaeon	1906665	Archaea	Archaea	51.2	3.37e-5	NR	MCQ2818861.1	1906665	g3856	i0	39.7	0.935897435897436	73	42	92.3	2	232	17	150	221	MCQ2818861.1 AAA family ATPase [archaeon]	diamond	219	51.2	1	Archaea	archaeon
28841904	28841904	PRJNA1240805_P_NODE_2688_length_288_cov_15.577406_g2639_i0	PRJNA1240805	2688	288	15.577406	44.86292928	archaeon	1906665	Archaea	Archaea	73.9	5.84e-14	NR	MCQ2819365.1	1906665	g2639	i0	46.2	1.35416666666667	65	35	67.7	0	55	249	112	176	MCQ2819365.1 LITAF-like zinc ribbon domain-containing protein [archaeon]	diamond	390	73.9	1	Archaea	archaeon
30926852	30926852	PRJNA1240805_P_NODE_5294_length_198_cov_5.597315_g5245_i0	PRJNA1240805	5294	198	5.597315	11.0826837	archaeon	1906665	Archaea	Archaea	53.9	1.13e-6	NR	MCQ2821738.1	1906665	g5245	i0	49	1.56060606060606	51	26	77.3	0	178	26	146	196	MCQ2821738.1 hypothetical protein [archaeon]	diamond	309	53.9	1	Archaea	archaeon
32128549	32128549	PRJNA1240805_P_NODE_2998_length_271_cov_6.225225_g2949_i0	PRJNA1240805	2998	271	6.225225	16.87035975	archaeon	1906665	Archaea	Archaea	62.8	4.24e-9	NR	MDP2435102.1	1906665	g2949	i0	42.9	0.774907749077491	70	40	77.5	0	267	58	294	363	MDP2435102.1 CBS domain-containing protein [archaeon]	diamond	210	62.8	1	Archaea	archaeon
32760218	32760218	PRJNA1240805_P_NODE_8360_length_161_cov_1.821429_g8311_i0	PRJNA1240805	8360	161	1.821429	2.93250069	archaeon	1906665	Archaea	Archaea	53.9	1.92e-7	NR	NDB55883.1	1906665	g8311	i0	65.9	1.63975155279503	44	15	82	0	134	3	38	81	NDB55883.1 hypothetical protein [archaeon]	diamond	264	53.9	1	Archaea	archaeon

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