metadata: contig_metadata: 13 rows where bioproject = "PRJNA379145", tax_clade = "FCB group" and tax

13 rows where bioproject = "PRJNA379145", 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
400601	400601	PRJNA379145_P_NODE_12741_length_821_cov_11.762690_g11319_i0	PRJNA379145	12741	821	11.76269	96.5716849	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	290	9.839999999999999e-96	NR	MBI5807568.1	2049428	g11319	i0	60.6	16.816077953715	208	82	76	0	8	631	1	208	MBI5807568.1 carbonate dehydratase [Ignavibacteriales bacterium]	diamond	13806	290	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
5504539	5504539	PRJNA379145_P_NODE_46045_length_257_cov_1.678571_g43892_i0	PRJNA379145	46045	257	1.678571	4.31392747	Pseudomonadati	3379134	Bacteria	Bacteria	122	3.1999999999999993e-31	NR	KXK56416.1	1617412	g43892	i0	68.2	19.8443579766537	85	27	99.2	0	256	2	12	96	KXK56416.1 MAG: GTP-dependent nucleic acid-binding protein EngD [Chlorobi bacterium OLB5]	diamond	5100	123	0.991869918699187	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Candidatus Tepidiaquacellales		Candidatus Tepidiaquacellales bacterium OLB5
27738658	27738658	PRJNA379145_P_NODE_22624_length_539_cov_6.820158_g20667_i0	PRJNA379145	22624	539	6.820158	36.76065162	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	123	3.659999999999999e-32	NR	MDZ7764859.1	2614255	g20667	i0	44.9	0.818181818181818	147	79	80.7	2	496	62	4	150	MDZ7764859.1 hypothetical protein [Melioribacteraceae bacterium]	diamond	441	123	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
28401439	28401439	PRJNA379145_P_NODE_62506_length_180_cov_1.789116_g60352_i0	PRJNA379145	62506	180	1.789116	3.2204088	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	92.8	1.6000000000000002e-22	NR	MDX1700758.1	2614255	g60352	i0	67.8	2.96666666666667	59	19	98.3	0	4	180	27	85	MDX1700758.1 hypothetical protein [Melioribacteraceae bacterium]	diamond	534	92.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
28639680	28639680	PRJNA379145_P_NODE_7307_length_1126_cov_10.022873_g6440_i0	PRJNA379145	7307	1126	10.022873	112.85754998	root	1	Root_unresolved	Root_unresolved	372	1.84e-124	NR	PJA98267.1	1974043	g6440	i0	54.2	15.7806394316163	332	145	87.1	3	130	1110	22	351	PJA98267.1 MAG: proline racemase [Ignavibacteriales bacterium CG_4_9_14_3_um_filter_30_11]	diamond	17769	375	0.992	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium CG_4_9_14_3_um_filter_30_11
29649413	29649413	PRJNA379145_P_NODE_14310_length_760_cov_3.152682_g12760_i0	PRJNA379145	14310	760	3.152682	23.9603832	FCB group	1783270	Bacteria	Bacteria	274	1.13e-89	NR	MBI5807568.1	2049428	g12760	i0	61.6	16.2434210526316	203	78	80.1	0	715	107	4	206	MBI5807568.1 carbonate dehydratase [Ignavibacteriales bacterium]	diamond	12345	274	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
30422940	30422940	PRJNA379145_P_NODE_6133_length_1226_cov_7.996647_g5384_i0	PRJNA379145	6133	1226	7.996647	98.03889222	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	95.1	2.31e-19	NR	MBI3578804.1	2049428	g5384	i0	38	0.692495921696574	137	79	32.8	3	102	503	6	139	MBI3578804.1 Holliday junction resolvase RuvX [Ignavibacteriales bacterium]	diamond	849	95.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
30959726	30959726	PRJNA379145_P_NODE_59014_length_192_cov_2.251572_g56860_i0	PRJNA379145	59014	192	2.251572	4.32301824	Ignavibacteriae bacterium HGW-Ignavibacteriae-2	2013809	Bacteria	Bacteria	51.6	1.29e-5	NR	PKL88999.1	2013809	g56860	i0	46.6	0.90625	58	30	90.6	1	174	1	79	135	PKL88999.1 MAG: fructosamine kinase [Ignavibacteriae bacterium HGW-Ignavibacteriae-2]	diamond	174	51.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriae bacterium HGW-Ignavibacteriae-2
31243930	31243930	PRJNA379145_P_NODE_22095_length_549_cov_10.046512_g20150_i0	PRJNA379145	22095	549	10.046512	55.15535088	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	66.6	9.14e-10	NR	HPN37501.1	2614255	g20150	i0	35	0.655737704918033	120	76	65.6	2	82	441	32	149	HPN37501.1 SdrD B-like domain-containing protein [Melioribacteraceae bacterium]	diamond	360	66.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
31244014	31244014	PRJNA379145_P_NODE_8035_length_1072_cov_5.179018_g229_i2	PRJNA379145	8035	1072	5.179018	55.51907296	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	70.1	7.02e-9	NR	MBV6511003.1	2651163	g229	i2	39.2	0.349813432835821	125	70	35	3	44	418	826	944	MBV6511003.1 hypothetical protein [Ignavibacteriaceae bacterium]	diamond	375	70.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
31465714	31465714	PRJNA379145_P_NODE_68936_length_162_cov_1.682171_g66782_i0	PRJNA379145	68936	162	1.682171	2.72511702	Ignavibacteria bacterium RIFOXYA2_FULL_37_17	1798443	Bacteria	Bacteria	40.4	0.0345	NR	OGV22960.1	1798443	g66782	i0	53.3	0.555555555555556	30	14	55.6	0	71	160	31	60	OGV22960.1 MAG: hypothetical protein A3J84_02910 [Ignavibacteria bacterium RIFOXYA2_FULL_37_17]	diamond	90	40.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium RIFOXYA2_FULL_37_17
32824650	32824650	PRJNA379145_P_NODE_58860_length_193_cov_1.606250_g56706_i0	PRJNA379145	58860	193	1.60625	3.1000625	Ignavibacteriales bacterium CG18_big_fil_WC_8_21_14_2_5	2049428	Bacteria	Bacteria	63.9	6.52e-10	NR	PIQ09371.1	1974047	g56706	i0	47.5	0.917098445595855	59	29	91.7	2	177	1	664	720	PIQ09371.1 MAG: hypothetical protein COW71_06735 [Ignavibacteriales bacterium CG18_big_fil_WC_8_21_14_2_50_31_20]	diamond	177	63.9	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium CG18_big_fil_WC_8_21_14_2_50_31_20
32887376	32887376	PRJNA379145_P_NODE_22660_length_539_cov_2.086957_g20701_i0	PRJNA379145	22660	539	2.086957	11.24869823	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	92.4	7.4e-21	NR	MBK8663282.1	2049428	g20701	i0	75.4	0.317254174397032	57	14	31.7	0	5	175	39	95	MBK8663282.1 hypothetical protein [Ignavibacteriales bacterium]	diamond	171	92.4	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);;