metadata: contig_metadata: 11 rows where analysis = "diamond", bioproject = "PRJNA741997" and tax

11 rows where analysis = "diamond", bioproject = "PRJNA741997" 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
13475587	13475587	PRJNA741997_P_NODE_89511_length_241_cov_0.916667_g88391_i0	PRJNA741997	89511	241	0.916667	2.20916747	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	112	5.2900000000000005e-27	NR	MCX6136456.1	2049428	g88391	i0	63.6	1.91701244813278	77	28	95.9	0	10	240	153	229	MCX6136456.1 aminotransferase class I/II-fold pyridoxal phosphate-dependent enzyme [Ignavibacteriales bacterium]	diamond	462	112	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
26714115	26714115	PRJNA741997_P_NODE_18421_length_541_cov_1.645299_g17308_i0	PRJNA741997	18421	541	1.645299	8.90106759	Bacteria	2	Bacteria	Bacteria	113	1.85e-25	NR	PLX32242.1	2053306	g17308	i0	39.2	4.97412199630314	181	105	98.2	4	9	539	693	872	PLX32242.1 MAG: beta-N-acetylglucosaminidase [Ignavibacteria bacterium]	diamond	2691	114	0.991228070175439	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
27337151	27337151	PRJNA741997_P_NODE_58183_length_282_cov_1.181818_g57063_i0	PRJNA741997	58183	282	1.181818	3.33272676	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	54.3	3.74e-6	NR	HKI79936.1	2651163	g57063	i0	40.3	0.712765957446808	67	37	68.1	2	278	87	189	255	HKI79936.1 DUF547 domain-containing protein [Ignavibacteriaceae bacterium]	diamond	201	54.3	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae		Ignavibacteriaceae bacterium
27589822	27589822	PRJNA741997_P_NODE_60304_length_277_cov_1.465686_g59184_i0	PRJNA741997	60304	277	1.465686	4.05995022	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	75.9	1.28e-13	NR	MBI5476107.1	2049428	g59184	i0	40.2	0.942238267148014	87	48	91	2	2	253	107	192	MBI5476107.1 beta galactosidase jelly roll domain-containing protein [Ignavibacteriales bacterium]	diamond	261	75.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales bacterium
29231668	29231668	PRJNA741997_P_NODE_58909_length_280_cov_1.487923_g57789_i0	PRJNA741997	58909	280	1.487923	4.1661844	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	128	3.54e-33	NR	RPI68559.1	2026749	g57789	i0	68.8	0.996428571428571	93	29	99.6	0	1	279	185	277	RPI68559.1 MAG: transporter [Ignavibacteriota bacterium]	diamond	279	128	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota					Ignavibacteriota bacterium
30115666	30115666	PRJNA741997_P_NODE_87592_length_242_cov_0.911243_g86472_i0	PRJNA741997	87592	242	0.911243	2.20520806	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	56.2	6.23e-7	NR	MBD1209263.1	2053306	g86472	i0	34.6	1.99586776859504	81	52	99.2	1	1	240	185	265	MBD1209263.1 response regulator [Ignavibacteria bacterium]	diamond	483	56.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
30495012	30495012	PRJNA741997_P_NODE_55253_length_288_cov_1.958140_g54133_i0	PRJNA741997	55253	288	1.95814	5.6394432	Rosettibacter primus	3111523	Bacteria	Bacteria	75.5	1.75e-15	NR	WP_353676144.1	3111523	g54133	i0	49.3	1.5625	75	38	78.1	0	63	287	1	75	WP_353676144.1 RNA recognition motif domain-containing protein [Rosettibacter primus]	diamond	450	75.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Rosettibacter	Rosettibacter primus
30779270	30779270	PRJNA741997_P_NODE_63094_length_271_cov_1.166667_g61974_i0	PRJNA741997	63094	271	1.166667	3.16166757	Ignavibacteria bacterium RBG_16_34_14	1798433	Bacteria	Bacteria	43.5	0.0278	NR	OGU74271.1	1798433	g61974	i0	32.9	0.907749077490775	82	50	87.5	2	24	260	209	288	OGU74271.1 MAG: hypothetical protein A2V93_08225 [Ignavibacteria bacterium RBG_16_34_14]	diamond	246	43.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium RBG_16_34_14
31632692	31632692	PRJNA741997_P_NODE_45456_length_322_cov_0.927711_g44336_i0	PRJNA741997	45456	322	0.927711	2.98722942	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	60.5	5.45e-8	NR	HRE40685.1	2053306	g44336	i0	40.8	0.661490683229814	71	40	66.1	1	16	228	308	376	HRE40685.1 hypothetical protein [Ignavibacteria bacterium]	diamond	213	60.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
31632734	31632734	PRJNA741997_P_NODE_81516_length_246_cov_0.890173_g80396_i0	PRJNA741997	81516	246	0.890173	2.18982558	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	69.7	3.08e-12	NR	NQW30970.1	2053306	g80396	i0	53.6	0.841463414634146	69	31	84.1	1	207	1	26	93	NQW30970.1 hypothetical protein [Ignavibacteria bacterium]	diamond	207	69.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria				Ignavibacteria bacterium
32518895	32518895	PRJNA741997_P_NODE_37259_length_356_cov_0.936396_g36139_i0	PRJNA741997	37259	356	0.936396	3.33356976	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	45.1	0.0108	NR	TSA30635.1	2049428	g36139	i0	31.3	0.674157303370786	80	51	65.7	2	355	122	66	143	TSA30635.1 MAG: nuclear transport factor 2 family protein [Ignavibacteriales bacterium]	diamond	240	45.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales			Ignavibacteriales 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);;