metadata: contig_metadata: 10 rows where bioproject = "PRJNA493827" and tax

10 rows where bioproject = "PRJNA493827" and tax_phylum = "Ignavibacteriota"

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
11948106	11948106	PRJNA493827_P_NODE_100270_length_342_cov_1.345725_g98072_i0	PRJNA493827	100270	342	1.345725	4.6023795	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	52.8	0.032	NTclustered	gi\|2621786307\|emb\|OY782765.1\|	2614255	g98072	i0	100	0.0818713450292398	28	0	8	0	53	80	672847	672874	MAG: Melioribacteraceae bacterium isolate b49f5fa7-6043-4eb4-88a3-53a29b1f0925 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae		Melioribacteraceae bacterium
11948759	11948759	PRJNA493827_P_NODE_127030_length_303_cov_1.686957_g124832_i0	PRJNA493827	127030	303	1.686957	5.11147971	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	161	1.3e-45	NR	HOJ38068.1	2049428	g124832	i0	79	0.99009900990099	100	21	99	0	3	302	142	241	HOJ38068.1 NADP-dependent isocitrate dehydrogenase [Ignavibacteriales bacterium]	diamond	300	161	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
13224163	13224163	PRJNA493827_P_NODE_140331_length_288_cov_1.879070_g138133_i0	PRJNA493827	140331	288	1.87907	5.4117216	Ignavibacterium album	591197	Bacteria	Bacteria	87.9	7.3e-13	NTclustered	gi\|383800634\|gb\|CP003418.1\|	945713	g138133	i0	84.884	0.458333333333333	86	13	30	0	1	86	1422195	1422280	Ignavibacterium album JCM 16511, complete genome	blastn	132	87.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacterium	Ignavibacterium album
26712370	26712370	PRJNA493827_P_NODE_217361_length_244_cov_0.900585_g215163_i0	PRJNA493827	217361	244	0.900585	2.1974274	Pseudomonadati	3379134	Bacteria	Bacteria	160	5.680000000000001e-44	NR	MBK7986184.1	2053306	g215163	i0	97.5	2.91393442622951	79	2	97.1	0	242	6	377	455	MBK7986184.1 1-deoxy-D-xylulose-5-phosphate synthase [Ignavibacteria bacterium]	diamond	711	160	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
27298085	27298085	PRJNA493827_P_NODE_214103_length_245_cov_0.895349_g211905_i0	PRJNA493827	214103	245	0.895349	2.19360505	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	151	2.02e-40	NR	MBK7985590.1	2053306	g211905	i0	80.2	0.991836734693878	81	16	99.2	0	2	244	97	177	MBK7985590.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium]	diamond	243	151	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
27471808	27471808	PRJNA493827_P_NODE_233683_length_241_cov_0.916667_g231485_i0	PRJNA493827	233683	241	0.916667	2.20916747	Pseudomonadati	3379134	Bacteria	Bacteria	108	3.45e-25	NR	MBK7986389.1	2053306	g231485	i0	61.3	3.98340248962656	80	31	99.6	0	1	240	718	797	MBK7986389.1 IgGFc-binding protein [Ignavibacteria bacterium]	diamond	960	108	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
29350538	29350538	PRJNA493827_P_NODE_197509_length_248_cov_1.474286_g195311_i0	PRJNA493827	197509	248	1.474286	3.65622928	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	84.3	8.33e-19	NR	MDP3683438.1	2053306	g195311	i0	62.7	1.42741935483871	59	22	71.4	0	219	43	1	59	MDP3683438.1 group 1 truncated hemoglobin [Ignavibacteria bacterium]	diamond	354	84.3	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30534780	30534780	PRJNA493827_P_NODE_37953_length_595_cov_2.973180_g35784_i0	PRJNA493827	37953	595	2.97318	17.690421	Bacteria	2	Bacteria	Bacteria	71.2	2.41e-11	NR	KXK03662.1	1617411	g35784	i0	60.4	6.27226890756303	48	19	24.2	0	409	266	90	137	KXK03662.1 MAG: peptide methionine sulfoxide reductase [Chlorobi bacterium OLB4]	diamond	3732	71.6	0.994413407821229	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Candidatus Tepidiaquacellales			Candidatus Tepidiaquacellales bacterium OLB4/UTCHB1
31056573	31056573	PRJNA493827_P_NODE_193915_length_249_cov_0.875000_g191717_i0	PRJNA493827	193915	249	0.875	2.17875	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	53.1	8.48e-6	NR	HEY4756903.1	2651163	g191717	i0	45.6	2.75903614457831	68	34	80.7	2	3	203	118	183	HEY4756903.1 CHRD domain-containing protein [Ignavibacteriaceae bacterium]	diamond	687	53.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
32826484	32826484	PRJNA493827_P_NODE_196620_length_249_cov_0.875000_g194422_i0	PRJNA493827	196620	249	0.875	2.17875	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	122	3.79e-30	NR	MBK7986584.1	2053306	g194422	i0	78.4	0.891566265060241	74	16	89.2	0	224	3	841	914	MBK7986584.1 type I DNA topoisomerase [Ignavibacteria bacterium]	diamond	222	122	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium

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);;