metadata: contig_metadata: 13 rows where analysis = "diamond", bioproject = "PRJNA290839" and tax

13 rows where analysis = "diamond", bioproject = "PRJNA290839" 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
16950299	16950299	PRJNA290839_P_NODE_594_length_332_cov_1.200772_g573_i0	PRJNA290839	594	332	1.200772	3.98656304	archaeon	1906665	Archaea	Archaea	132	7.489999999999999e-37	NR	RYH30236.1	1906665	g573	i0	70.4	0.885542168674699	98	23	84.9	2	33	314	42	137	RYH30236.1 MAG: hypothetical protein EON65_05740 [archaeon]	diamond	294	132	1	Archaea								archaeon
19498817	19498817	PRJNA290839_P_NODE_1576_length_243_cov_0.911765_g1555_i0	PRJNA290839	1576	243	0.911765	2.21558895	Candidatus Woesearchaeota archaeon	2026803	Archaea	Archaea	74.7	1.94e-13	NR	MEM4247223.1	2026803	g1555	i0	60.3	1.32098765432099	58	20	71.6	1	235	62	9	63	MEM4247223.1 proline--tRNA ligase [Candidatus Woesearchaeota archaeon]	diamond	321	74.7	1	Archaea		Nanobdellati	Candidatus Woesearchaeota					Candidatus Woesearchaeota archaeon
27060204	27060204	PRJNA290839_P_NODE_1402_length_246_cov_0.895954_g1381_i0	PRJNA290839	1402	246	0.895954	2.20404684	root	1	Root_unresolved	Root_unresolved	104	6.13e-24	NR	RYG70266.1	1906665	g1381	i0	64.6	2.18292682926829	82	29	100	0	1	246	628	709	RYG70266.1 MAG: hypothetical protein EON64_00630 [archaeon]	diamond	537	104	1	Archaea								archaeon
27154597	27154597	PRJNA290839_P_NODE_962_length_259_cov_0.994624_g941_i0	PRJNA290839	962	259	0.994624	2.57607616	Methanobrevibacter	2172	Archaea	Archaea	47	0.00148	NR	MBR0370732.1	66852	g941	i0	37	4.22779922779923	73	46	84.6	0	12	230	3063	3135	MBR0370732.1 Ig-like domain repeat protein [Methanobrevibacter sp.]	diamond	1095	47	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobrevibacter	Methanobrevibacter sp.
27927025	27927025	PRJNA290839_P_NODE_1165_length_250_cov_0.881356_g1144_i0	PRJNA290839	1165	250	0.881356	2.20339	Thermoplasmata archaeon	1906666	Archaea	Archaea	112	6.79e-27	NR	MCD6236474.1	1906666	g1144	i0	62.2	2.856	82	30	97.2	1	4	246	226	307	MCD6236474.1 AMP-binding protein [Thermoplasmata archaeon]	diamond	714	112	1	Archaea		Methanobacteriati	Thermoplasmatota	Thermoplasmata				Thermoplasmata archaeon
28116375	28116375	PRJNA290839_P_NODE_1565_length_243_cov_0.911765_g1544_i0	PRJNA290839	1565	243	0.911765	2.21558895	Candidatus Methanophagales archaeon	2056316	Archaea	Archaea	42.7	0.0285	NR	MCD6209521.1	2056316	g1544	i0	38.9	0.666666666666667	54	33	66.7	0	200	39	22	75	MCD6209521.1 hypothetical protein [Candidatus Methanophagales archaeon]	diamond	162	42.7	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Candidatus Methanophagales			Candidatus Methanophagales archaeon
28179366	28179366	PRJNA290839_P_NODE_1546_length_243_cov_0.917647_g1525_i0	PRJNA290839	1546	243	0.917647	2.22988221	archaeon	1906665	Archaea	Archaea	67.8	1.64e-12	NR	RYG54404.1	1906665	g1525	i0	47.5	0.753086419753086	61	32	75.3	0	61	243	20	80	RYG54404.1 MAG: hypothetical protein EON66_07190 [archaeon]	diamond	183	67.8	1	Archaea								archaeon
28544754	28544754	PRJNA290839_P_NODE_287_length_498_cov_1.628235_g266_i0	PRJNA290839	287	498	1.628235	8.1086103	root	1	Root_unresolved	Root_unresolved	108	5.28e-24	NR	OPX78749.1	1811685	g266	i0	40.2	4.67469879518072	164	89	95.8	5	495	19	923	1082	OPX78749.1 MAG: HYR domain protein [Methanosaeta sp. PtaB.Bin039]	diamond	2328	108	1	Archaea	Stenosarchaea group	Methanobacteriati	Methanobacteriota	Methanomicrobia	Methanotrichales	Methanotrichaceae	Methanothrix	Methanosaeta sp. PtaB.Bin039
28842513	28842513	PRJNA290839_P_NODE_868_length_275_cov_1.405941_g847_i0	PRJNA290839	868	275	1.405941	3.86633775	archaeon	1906665	Archaea	Archaea	59.3	7.62e-9	NR	RYG63012.1	1906665	g847	i0	53.7	0.589090909090909	54	25	58.9	0	113	274	6	59	RYG63012.1 MAG: hypothetical protein EON64_16780, partial [archaeon]	diamond	162	59.3	1	Archaea								archaeon
28937483	28937483	PRJNA290839_P_NODE_1228_length_249_cov_0.880682_g1207_i0	PRJNA290839	1228	249	0.880682	2.19289818	archaeon	1906665	Archaea	Archaea	109	9.7e-26	NR	RYH25180.1	1906665	g1207	i0	63.4	0.987951807228916	82	30	98.8	0	248	3	123	204	RYH25180.1 MAG: hypothetical protein EON65_15925 [archaeon]	diamond	246	109	1	Archaea								archaeon
29221740	29221740	PRJNA290839_P_NODE_1649_length_242_cov_0.911243_g1628_i0	PRJNA290839	1649	242	0.911243	2.20520806	archaeon	1906665	Archaea	Archaea	60.5	1.18e-9	NR	RYH05092.1	1906665	g1628	i0	56.9	0.632231404958678	51	20	63.2	1	1	153	56	104	RYH05092.1 MAG: hypothetical protein EON65_45670, partial [archaeon]	diamond	153	60.5	1	Archaea								archaeon
31970731	31970731	PRJNA290839_P_NODE_1118_length_251_cov_0.870787_g1097_i0	PRJNA290839	1118	251	0.870787	2.18567537	archaeon	1906665	Archaea	Archaea	65.5	1.06e-11	NR	RYH26656.1	1906665	g1097	i0	67.7	0.776892430278884	65	20	76.5	1	216	25	22	86	RYH26656.1 MAG: hypothetical protein EON65_14320 [archaeon]	diamond	195	65.5	1	Archaea								archaeon
32255949	32255949	PRJNA290839_P_NODE_638_length_321_cov_0.939516_g617_i0	PRJNA290839	638	321	0.939516	3.01584636	archaeon	1906665	Archaea	Archaea	138	4.409999999999999e-37	NR	RYG68823.1	1906665	g617	i0	72.7	0.822429906542056	88	24	82.2	0	3	266	261	348	RYG68823.1 MAG: hypothetical protein EON64_04280 [archaeon]	diamond	264	138	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);;