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

9 rows where analysis = "diamond", bioproject = "PRJDB4470" and tax_kingdom = "Thermoproteati"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
14037097	14037097	PRJDB4470_P_NODE_105712_length_167_cov_0.864407_g104557_i0	PRJDB4470	105712	167	0.864407	1.44355969	Sulfolobaceae archaeon	2967306	Archaea	Archaea	94	1.05e-21	NR	MEM0173401.1	2967306	g104557	i0	80	0.988023952095808	55	11	98.8	0	167	3	184	238	MEM0173401.1 hypothetical protein [Sulfolobaceae archaeon]	diamond	165	94	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Sulfolobaceae archaeon
26810981	26810981	PRJDB4470_P_NODE_78821_length_201_cov_1.993421_g77666_i0	PRJDB4470	78821	201	1.993421	4.00677621	Nitrososphaeraceae archaeon	2169593	Archaea	Archaea	93.2	1.04e-20	NR	HJR46673.1	2169593	g77666	i0	82.4	2.28358208955224	51	9	76.1	0	5	157	285	335	HJR46673.1 site-specific integrase [Nitrososphaeraceae archaeon]	diamond	459	93.2	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria	Nitrososphaerales	Nitrososphaeraceae	Nitrososphaeraceae archaeon
27064038	27064038	PRJDB4470_P_NODE_100862_length_169_cov_0.866667_g99707_i0	PRJDB4470	100862	169	0.866667	1.46466723	Thermoprotei archaeon	2250277	Archaea	Archaea	45.4	0.00158	NR	RLE67006.1	2250277	g99707	i0	60.5	0.674556213017751	38	15	67.5	0	169	56	690	727	RLE67006.1 MAG: hypothetical protein DRJ38_00100 [Thermoprotei archaeon]	diamond	114	45.4	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei			Thermoprotei archaeon
27064052	27064052	PRJDB4470_P_NODE_45962_length_310_cov_1.383142_g44809_i0	PRJDB4470	45962	310	1.383142	4.2877402	Sulfolobaceae archaeon	2967306	Archaea	Archaea	57	3.78e-7	NR	MEM0173671.1	2967306	g44809	i0	38	2.7	100	41	76.5	4	73	309	1	100	MEM0173671.1 zonular occludens toxin domain-containing protein [Sulfolobaceae archaeon]	diamond	837	57	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Sulfolobaceae archaeon
27632816	27632816	PRJDB4470_P_NODE_102624_length_168_cov_0.873950_g101469_i0	PRJDB4470	102624	168	0.87395	1.468236	Thermoproteota archaeon	2056631	Archaea	Archaea	42.4	0.0185	NR	MEM2886237.1	2056631	g101469	i0	35.8	0.946428571428571	53	33	94.6	1	2	160	137	188	MEM2886237.1 DUF6785 family protein [Thermoproteota archaeon]	diamond	159	42.4	1	Archaea	Thermoproteati	Thermoproteota				Thermoproteota archaeon
28422317	28422317	PRJDB4470_P_NODE_96146_length_174_cov_1.648000_g94991_i0	PRJDB4470	96146	174	1.648	2.86752	Nitrososphaeria archaeon	2268198	Archaea	Archaea	56.6	6.66e-8	NR	MEM2741052.1	2268198	g94991	i0	53.5	0.741379310344828	43	20	74.1	0	7	135	133	175	MEM2741052.1 hypothetical protein [Nitrososphaeria archaeon]	diamond	129	56.6	1	Archaea	Thermoproteati	Nitrososphaerota	Nitrososphaeria			Nitrososphaeria archaeon
29589999	29589999	PRJDB4470_P_NODE_87070_length_187_cov_1.456522_g85915_i0	PRJDB4470	87070	187	1.456522	2.72369614	Sulfolobaceae archaeon	2967306	Archaea	Archaea	126	1.33e-34	NR	MEM0173166.1	2967306	g85915	i0	98.4	0.978609625668449	61	1	97.9	0	185	3	39	99	MEM0173166.1 hypothetical protein [Sulfolobaceae archaeon]	diamond	183	126	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Sulfolobaceae archaeon
31011894	31011894	PRJDB4470_P_NODE_112075_length_165_cov_0.879310_g110920_i0	PRJDB4470	112075	165	0.87931	1.4508615	Sulfolobaceae archaeon	2967306	Archaea	Archaea	82.4	1.32e-16	NR	MEM0174437.1	2967306	g110920	i0	79.6	0.981818181818182	54	11	98.2	0	164	3	434	487	MEM0174437.1 phage tail tape measure protein [Sulfolobaceae archaeon]	diamond	162	82.4	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Sulfolobaceae archaeon
31454631	31454631	PRJDB4470_P_NODE_89796_length_183_cov_1.522388_g88641_i0	PRJDB4470	89796	183	1.522388	2.78597004	Sulfolobaceae archaeon	2967306	Archaea	Archaea	61.2	1.78e-9	NR	MEM0173399.1	2967306	g88641	i0	49.2	0.967213114754098	59	28	96.7	2	183	7	146	202	MEM0173399.1 hypothetical protein [Sulfolobaceae archaeon]	diamond	177	61.2	1	Archaea	Thermoproteati	Thermoproteota	Thermoprotei	Sulfolobales	Sulfolobaceae	Sulfolobaceae 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);;