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

8 rows where analysis = "diamond", bioproject = "PRJNA720429" 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
27178287	27178287	PRJNA720429_P_NODE_2862_length_263_cov_1.063158_g2805_i0	PRJNA720429	2862	263	1.063158	2.79610554	archaeon	1906665	Archaea	Archaea	82	3.47e-17	NR	RYG63467.1	1906665	g2805	i0	52.1	2.55513307984791	73	35	83.3	0	219	1	4	76	RYG63467.1 MAG: iron-containing alcohol dehydrogenase, partial [archaeon]	diamond	672	82	1	Archaea								archaeon
27841624	27841624	PRJNA720429_P_NODE_3204_length_251_cov_0.865169_g3147_i0	PRJNA720429	3204	251	0.865169	2.17157419	Methanobacterium sp.	2164	Archaea	Archaea	145	1.08e-38	NR	HOI40980.1	2164	g3147	i0	100	0.944223107569721	79	0	94.4	0	239	3	125	203	HOI40980.1 histidine kinase dimerization/phosphoacceptor domain -containing protein [Methanobacterium sp.]	diamond	237	145	1	Archaea	Methanomada group	Methanobacteriati	Methanobacteriota	Methanobacteria	Methanobacteriales	Methanobacteriaceae	Methanobacterium	Methanobacterium sp.
29735943	29735943	PRJNA720429_P_NODE_4850_length_242_cov_0.911243_g4793_i0	PRJNA720429	4850	242	0.911243	2.20520806	archaeon	1906665	Archaea	Archaea	77.8	2.12e-15	NR	NCQ50342.1	1906665	g4793	i0	51.3	0.942148760330578	76	37	94.2	0	1	228	83	158	NCQ50342.1 hypothetical protein [archaeon]	diamond	228	77.8	1	Archaea								archaeon
30305282	30305282	PRJNA720429_P_NODE_5132_length_241_cov_0.916667_g5075_i0	PRJNA720429	5132	241	0.916667	2.20916747	archaeon	1906665	Archaea	Archaea	112	9.4e-28	NR	NCQ52303.1	1906665	g5075	i0	61.3	0.995850622406639	80	31	99.6	0	240	1	269	348	NCQ52303.1 type IVB secretion system coupling complex protein DotM/IcmP [archaeon]	diamond	240	112	1	Archaea								archaeon
31821913	31821913	PRJNA720429_P_NODE_3997_length_247_cov_0.885057_g3940_i0	PRJNA720429	3997	247	0.885057	2.18609079	archaeon	1906665	Archaea	Archaea	82.8	1.18e-16	NR	NCQ51613.1	1906665	g3940	i0	51.9	0.983805668016194	81	38	97.2	1	240	1	139	219	NCQ51613.1 hypothetical protein [archaeon]	diamond	243	82.8	1	Archaea								archaeon
31885240	31885240	PRJNA720429_P_NODE_1477_length_343_cov_1.418519_g1420_i0	PRJNA720429	1477	343	1.418519	4.86552017	Thermofilum sp.	1961369	Archaea	Archaea	45.8	0.00926	NR	MEM1516913.1	1961369	g1420	i0	37.6	0.743440233236152	85	39	70.8	3	284	42	272	346	MEM1516913.1 hypothetical protein [Thermofilum sp.]	diamond	255	45.8	1	Archaea		Thermoproteati	Thermoproteota	Thermoprotei	Thermofilales	Thermofilaceae	Thermofilum	Thermofilum sp.
31916984	31916984	PRJNA720429_P_NODE_3777_length_248_cov_0.880000_g3720_i0	PRJNA720429	3777	248	0.88	2.1824	archaeon	1906665	Archaea	Archaea	108	2.92e-29	NR	RYY82745.1	1906665	g3720	i0	83.9	0.75	62	10	75	0	6	191	1	62	RYY82745.1 MAG: hypothetical protein EON63_12740 [archaeon]	diamond	186	108	1	Archaea								archaeon
32550057	32550057	PRJNA720429_P_NODE_1999_length_301_cov_1.640351_g1942_i0	PRJNA720429	1999	301	1.640351	4.93745651	archaeon	1906665	Archaea	Archaea	167	6.05e-50	NR	RYG65124.1	1906665	g1942	i0	87.4	0.946843853820598	95	12	94.7	0	1	285	118	212	RYG65124.1 MAG: 30S ribosomal protein S5 [archaeon]	diamond	285	167	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);;