metadata: contig_metadata: 9 rows where analysis = "diamond", bioproject = "PRJNA478247" and tax

9 rows where analysis = "diamond", bioproject = "PRJNA478247" 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
28308074	28308074	PRJNA478247_P_NODE_526_length_624_cov_13.736134_g429_i0	PRJNA478247	526	624	13.736134	85.71347616	archaeon	1906665	Archaea	Archaea	227	4.3799999999999995e-72	NR	RYH12636.1	1906665	g429	i0	54.1	0.985576923076923	205	92	98.1	2	623	12	1	204	RYH12636.1 MAG: glutathione transferase GstA [archaeon]	diamond	615	227	1	Archaea								archaeon
28529200	28529200	PRJNA478247_P_NODE_527_length_624_cov_8.594958_g430_i0	PRJNA478247	527	624	8.594958	53.63253792	archaeon	1906665	Archaea	Archaea	228	3.2e-72	NR	RYH12636.1	1906665	g430	i0	54.2	0.975961538461538	203	91	97.1	2	621	16	3	204	RYH12636.1 MAG: glutathione transferase GstA [archaeon]	diamond	609	228	1	Archaea								archaeon
28560705	28560705	PRJNA478247_P_NODE_2407_length_214_cov_2.167568_g2301_i0	PRJNA478247	2407	214	2.167568	4.63859552	archaeon	1906665	Archaea	Archaea	103	2.09e-26	NR	MCQ2820256.1	1906665	g2301	i0	65.7	0.981308411214953	70	24	98.1	0	213	4	5	74	MCQ2820256.1 50S ribosomal protein L32e [archaeon]	diamond	210	103	1	Archaea								archaeon
28781403	28781403	PRJNA478247_P_NODE_2147_length_233_cov_1.946078_g2041_i0	PRJNA478247	2147	233	1.946078	4.53436174	archaeon	1906665	Archaea	Archaea	102	6.1199999999999996e-24	NR	MDP2439249.1	1906665	g2041	i0	79.3	0.746781115879828	58	12	74.7	0	59	232	22	79	MDP2439249.1 MC/SLC25 family protein [archaeon]	diamond	174	102	1	Archaea								archaeon
30202421	30202421	PRJNA478247_P_NODE_2292_length_222_cov_1.844560_g2186_i0	PRJNA478247	2292	222	1.84456	4.0949232	archaeon	1906665	Archaea	Archaea	73.6	1.49e-13	NR	MCQ2821136.1	1906665	g2186	i0	60	0.743243243243243	55	21	74.3	1	11	175	7	60	MCQ2821136.1 hypothetical protein [archaeon]	diamond	165	73.6	1	Archaea								archaeon
30518601	30518601	PRJNA478247_P_NODE_2993_length_178_cov_2.255034_g2887_i0	PRJNA478247	2993	178	2.255034	4.01396052	archaeon	1906665	Archaea	Archaea	75.1	4.9e-14	NR	MCQ2815781.1	1906665	g2887	i0	67.3	0.876404494382023	52	17	87.6	0	20	175	152	203	MCQ2815781.1 thioredoxin domain-containing protein [archaeon]	diamond	156	75.1	1	Archaea								archaeon
31972846	31972846	PRJNA478247_P_NODE_2958_length_180_cov_2.006623_g2852_i0	PRJNA478247	2958	180	2.006623	3.6119214	Methanobrevibacter sp.	66852	Archaea	Archaea	42	0.0298	NR	MEE3443986.1	66852	g2852	i0	37.9	0.966666666666667	58	36	96.7	0	2	175	203	260	MEE3443986.1 hypothetical protein [Methanobrevibacter sp.]	diamond	174	42	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
32210515	32210515	PRJNA478247_P_NODE_2278_length_223_cov_2.443299_g2172_i0	PRJNA478247	2278	223	2.443299	5.44855677	root	1	Root_unresolved	Root_unresolved	100	3.1999999999999998e-24	NR	RYH12636.1	1906665	g2172	i0	68.1	2.73094170403587	69	22	92.8	0	208	2	1	69	RYH12636.1 MAG: glutathione transferase GstA [archaeon]	diamond	609	100	1	Archaea								archaeon
32321237	32321237	PRJNA478247_P_NODE_179_length_1140_cov_3.030603_g132_i0	PRJNA478247	179	1140	3.030603	34.5488742	archaeon	1906665	Archaea	Archaea	199	2.04e-56	NR	MDP2435485.1	1906665	g132	i0	48.8	4.73947368421053	203	102	53.2	2	652	47	173	374	MDP2435485.1 NAD(P)-dependent oxidoreductase [archaeon]	diamond	5403	199	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);;