metadata: contig_metadata: 14 rows where bioproject = "PRJNA690592", tax_clade = "FCB group" and tax

14 rows where bioproject = "PRJNA690592", tax_clade = "FCB group" 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_species
24898316	24898316	PRJNA690592_S_NODE_82300_length_355_cov_1.092199_g81286_i0	PRJNA690592	82300	355	1.092199	3.87730645	Pseudomonadati	3379134	Bacteria	Bacteria	162	1.9599999999999998e-46	NR	OGU45603.1	1798425	g81286	i0	68.1	31.1323943661972	119	36	98.9	1	4	354	132	250	OGU45603.1 MAG: aspartate-semialdehyde dehydrogenase [Ignavibacteria bacterium GWB2_36_8]	diamond	11052	163	0.993865030674847	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium GWB2_36_8
27050976	27050976	PRJNA690592_S_NODE_42942_length_469_cov_6.356061_g41928_i0	PRJNA690592	42942	469	6.356061	29.80992609	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	179	7.089999999999999e-55	NR	MCX7878661.1	2053306	g41928	i0	67.8	0.773987206823028	121	37	76.8	2	407	48	4	123	MCX7878661.1 peptide-methionine (R)-S-oxide reductase MsrB [Ignavibacteria bacterium]	diamond	363	179	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
28061541	28061541	PRJNA690592_S_NODE_205045_length_244_cov_1.818713_g204031_i0	PRJNA690592	205045	244	1.818713	4.43765972	Ignavibacteria bacterium GWB2_35_6b	1798424	Bacteria	Bacteria	76.3	2.14e-15	NR	OGU35992.1	1798424	g204031	i0	61.5	1.77049180327869	52	20	63.9	0	158	3	5	56	OGU35992.1 MAG: hypothetical protein A2068_13375 [Ignavibacteria bacterium GWB2_35_6b]	diamond	432	76.3	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium GWB2_35_6b
28472260	28472260	PRJNA690592_S_NODE_69946_length_380_cov_1.824104_g68932_i0	PRJNA690592	69946	380	1.824104	6.9315952	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	70.5	3.53e-11	NR	MFM6956880.1	2053306	g68932	i0	46.1	0.805263157894737	102	47	75.8	4	63	350	64	163	MFM6956880.1 hypothetical protein [Ignavibacteria bacterium]	diamond	306	70.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
28850736	28850736	PRJNA690592_S_NODE_216388_length_241_cov_0.869048_g215374_i0	PRJNA690592	216388	241	0.869048	2.09440568	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	79	1.34e-16	NR	HMS33164.1	2053306	g215374	i0	61.8	0.684647302904564	55	21	68.5	0	165	1	7	61	HMS33164.1 thiol-disulfide oxidoreductase DCC family protein [Ignavibacteria bacterium]	diamond	165	79	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
29356274	29356274	PRJNA690592_S_NODE_71249_length_377_cov_1.865132_g70235_i0	PRJNA690592	71249	377	1.865132	7.03154764	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	77.8	4.12e-14	NR	MCB0725956.1	2026749	g70235	i0	41.8	0.724137931034483	91	52	72.4	1	344	72	147	236	MCB0725956.1 16S rRNA (cytosine(1402)-N(4))-methyltransferase RsmH [Ignavibacteriota bacterium]	diamond	273	77.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
30399016	30399016	PRJNA690592_S_NODE_95493_length_334_cov_0.988506_g94479_i0	PRJNA690592	95493	334	0.988506	3.30161004	Ignavibacteriota bacterium	2026749	Bacteria	Bacteria	80.1	1.33e-15	NR	MCB0711714.1	2026749	g94479	i0	50.6	1.55389221556886	89	42	79	2	71	334	15	102	MCB0711714.1 50S ribosomal protein L1 [Ignavibacteriota bacterium]	diamond	519	80.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
31283052	31283052	PRJNA690592_S_NODE_1515_length_1784_cov_3.739334_g1269_i0	PRJNA690592	1515	1784	3.739334	66.70971856	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	65.9	4.53e-7	NR	MCX7878700.1	2053306	g1269	i0	27.8	0.356502242152466	212	123	34.5	7	1660	1046	123	311	MCX7878700.1 M14 family zinc carboxypeptidase [Ignavibacteria bacterium]	diamond	636	65.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
31441268	31441268	PRJNA690592_S_NODE_199736_length_246_cov_1.335260_g198722_i0	PRJNA690592	199736	246	1.33526	3.2847396	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	58.9	3.74e-8	NR	MCB9207629.1	2049428	g198722	i0	46.2	2.67073170731707	65	34	78	1	234	43	153	217	MCB9207629.1 hypothetical protein [Ignavibacteriales bacterium]	diamond	657	58.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
31990411	31990411	PRJNA690592_S_NODE_21118_length_650_cov_6.202773_g20148_i0	PRJNA690592	21118	650	6.202773	40.3180245	Pseudomonadati	3379134	Bacteria	Bacteria	113	1.02e-27	NR	OGV03533.1	1798447	g20148	i0	40.1	4.58307692307692	157	83	68.8	5	89	535	13	166	OGV03533.1 MAG: hypothetical protein A2330_06670 [Ignavibacteria bacterium RIFOXYB2_FULL_36_7]	diamond	2979	113	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium RIFOXYB2_FULL_36_7
32232533	32232533	PRJNA690592_S_NODE_44058_length_464_cov_2.138107_g43044_i0	PRJNA690592	44058	464	2.138107	9.92081648	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	89	2.09e-17	NR	RJP71584.1	2049428	g43044	i0	49.5	1.93318965517241	101	48	63.4	2	464	171	328	428	RJP71584.1 MAG: class A beta-lactamase-related serine hydrolase [Ignavibacteriales bacterium]	diamond	897	89	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
32454037	32454037	PRJNA690592_S_NODE_94739_length_335_cov_1.137405_g93725_i0	PRJNA690592	94739	335	1.137405	3.81030675	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	56.2	5.83e-7	NR	HOJ36617.1	2049428	g93725	i0	42.4	1.1910447761194	66	38	59.1	0	327	130	110	175	HOJ36617.1 50S ribosomal protein L10 [Ignavibacteriales bacterium]	diamond	399	56.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
32642817	32642817	PRJNA690592_S_NODE_125000_length_299_cov_1.637168_g123986_i0	PRJNA690592	125000	299	1.637168	4.89513232	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	41.6	0.0339	NR	GJQ44039.1	2651163	g123986	i0	30.6	0.722408026755853	72	46	68.2	1	204	1	12	83	GJQ44039.1 MAG: hypothetical protein JETCAE03_35370 [Ignavibacteriaceae bacterium]	diamond	216	41.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
32894938	32894938	PRJNA690592_S_NODE_215160_length_241_cov_0.916667_g214146_i0	PRJNA690592	215160	241	0.916667	2.20916747	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	58.5	9.32e-8	NR	NUM71270.1	2651163	g214146	i0	45.5	0.95850622406639	77	36	92.1	2	224	3	200	273	NUM71270.1 putative Ig domain-containing protein [Ignavibacteriaceae bacterium]	diamond	231	58.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae 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);;