metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA1129273" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA1129273" 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
13036978	13036978	PRJNA1129273_P_NODE_6691_length_277_cov_1.931373_g6411_i0	PRJNA1129273	6691	277	1.931373	5.34990321	archaeon	1906665	Archaea	Archaea	167	8.05e-51	NR	RYG68742.1	1906665	g6411	i0	82.6	0.996389891696751	92	16	99.6	0	276	1	12	103	RYG68742.1 MAG: hypothetical protein EON64_04505 [archaeon]	diamond	276	167	1	Archaea	archaeon
26690452	26690452	PRJNA1129273_P_NODE_4441_length_341_cov_1.082090_g4161_i0	PRJNA1129273	4441	341	1.08209	3.6899269	archaeon	1906665	Archaea	Archaea	127	6.799999999999999e-36	NR	RYG99347.1	1906665	g4161	i0	73	0.782991202346041	89	22	78.3	1	20	286	1	87	RYG99347.1 MAG: hypothetical protein EON65_50365 [archaeon]	diamond	267	127	1	Archaea	archaeon
27133173	27133173	PRJNA1129273_P_NODE_9262_length_248_cov_0.885714_g8982_i0	PRJNA1129273	9262	248	0.885714	2.19657072	archaeon	1906665	Archaea	Archaea	50.4	7.42e-5	NR	MCQ2818809.1	1906665	g8982	i0	42.6	0.82258064516129	68	34	79.8	2	202	5	106	170	MCQ2818809.1 hypothetical protein [archaeon]	diamond	204	50.4	1	Archaea	archaeon
28302017	28302017	PRJNA1129273_P_NODE_6466_length_281_cov_1.173077_g6186_i0	PRJNA1129273	6466	281	1.173077	3.29634637	archaeon	1906665	Archaea	Archaea	97.4	8.039999999999999e-23	NR	RYG62669.1	1906665	g6186	i0	48.2	0.907473309608541	85	44	90.7	0	256	2	51	135	RYG62669.1 MAG: hypothetical protein EON64_17440 [archaeon]	diamond	255	97.4	1	Archaea	archaeon
29344081	29344081	PRJNA1129273_P_NODE_10469_length_242_cov_1.810651_g10189_i0	PRJNA1129273	10469	242	1.810651	4.38177542	archaeon	1906665	Archaea	Archaea	94.4	1.3400000000000002e-21	NR	RYH03686.1	1906665	g10189	i0	64.6	1.01652892561983	82	27	99.2	2	3	242	79	160	RYH03686.1 MAG: hypothetical protein EON65_47215 [archaeon]	diamond	246	94.4	1	Archaea	archaeon
30260164	30260164	PRJNA1129273_P_NODE_9812_length_245_cov_1.779070_g9532_i0	PRJNA1129273	9812	245	1.77907	4.3587215	archaeon	1906665	Archaea	Archaea	111	4.8e-29	NR	RYH28351.1	1906665	g9532	i0	67.1	0.96734693877551	79	26	96.7	0	244	8	75	153	RYH28351.1 MAG: hypothetical protein EON65_12555 [archaeon]	diamond	237	111	1	Archaea	archaeon
31081496	31081496	PRJNA1129273_P_NODE_7355_length_267_cov_1.597938_g7075_i0	PRJNA1129273	7355	267	1.597938	4.26649446	archaeon	1906665	Archaea	Archaea	126	1.03e-35	NR	RYG99347.1	1906665	g7075	i0	79.2	0.865168539325843	77	16	86.5	0	3	233	11	87	RYG99347.1 MAG: hypothetical protein EON65_50365 [archaeon]	diamond	231	126	1	Archaea	archaeon
32662331	32662331	PRJNA1129273_P_NODE_10860_length_236_cov_2.355828_g10580_i0	PRJNA1129273	10860	236	2.355828	5.55975408	archaeon	1906665	Archaea	Archaea	142	2.42e-41	NR	MCQ2818557.1	1906665	g10580	i0	78.2	5.94915254237288	78	17	99.2	0	2	235	3	80	MCQ2818557.1 ubiquitin-conjugating enzyme E2 [archaeon]	diamond	1404	142	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);;