metadata: contig_metadata: 6 rows where bioproject = "PRJNA322517" and tax

6 rows where bioproject = "PRJNA322517" 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
29190509	29190509	PRJNA322517_P_NODE_5449_length_167_cov_0.864407_g5427_i0	PRJNA322517	5449	167	0.864407	1.44355969	archaeon	1906665	Archaea	Archaea	57.4	2.71e-9	NR	RYG65148.1	1906665	g5427	i0	52.8	0.952095808383233	53	25	95.2	0	6	164	3	55	RYG65148.1 MAG: hypothetical protein EON64_12525 [archaeon]	diamond	159	57.4	1	Archaea	archaeon
30011532	30011532	PRJNA322517_P_NODE_4271_length_190_cov_0.879433_g4249_i0	PRJNA322517	4271	190	0.879433	1.6709227	archaeon	1906665	Archaea	Archaea	87	4.62e-18	NR	RYG70422.1	1906665	g4249	i0	66.1	0.978947368421053	62	21	97.9	0	4	189	259	320	RYG70422.1 MAG: hypothetical protein EON64_00215 [archaeon]	diamond	186	87	1	Archaea	archaeon
30011536	30011536	PRJNA322517_P_NODE_6311_length_161_cov_0.910714_g6289_i0	PRJNA322517	6311	161	0.910714	1.46624954	archaeon	1906665	Archaea	Archaea	83.2	1.45e-17	NR	RYG70102.1	1906665	g6289	i0	71.7	0.987577639751553	53	15	98.8	0	161	3	116	168	RYG70102.1 MAG: hypothetical protein EON64_01060 [archaeon]	diamond	159	83.2	1	Archaea	archaeon
30579862	30579862	PRJNA322517_P_NODE_5853_length_164_cov_0.886957_g5831_i0	PRJNA322517	5853	164	0.886957	1.45460948	archaeon	1906665	Archaea	Archaea	82.4	2.22e-17	NR	RYH06232.1	1906665	g5831	i0	70.9	1.9390243902439	55	15	98.8	1	164	3	145	199	RYH06232.1 MAG: hypothetical protein EON65_43130, partial [archaeon]	diamond	318	82.4	1	Archaea	archaeon
32002863	32002863	PRJNA322517_P_NODE_5878_length_164_cov_0.886957_g5856_i0	PRJNA322517	5878	164	0.886957	1.45460948	archaeon	1906665	Archaea	Archaea	63.2	7.48e-11	NR	RYH29610.1	1906665	g5856	i0	51.9	0.98780487804878	54	26	98.8	0	162	1	76	129	RYH29610.1 MAG: hypothetical protein EON65_07900 [archaeon]	diamond	162	63.2	1	Archaea	archaeon
32572574	32572574	PRJNA322517_P_NODE_5699_length_165_cov_0.879310_g5677_i0	PRJNA322517	5699	165	0.87931	1.4508615	archaeon	1906665	Archaea	Archaea	94	5.94e-24	NR	RYY87947.1	1906665	g5677	i0	97.9	1.70909090909091	47	1	85.5	0	23	163	1	47	RYY87947.1 MAG: hypothetical protein EON63_03185 [archaeon]	diamond	282	94	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);;