metadata: contig_metadata: 10 rows where bioproject = "PRJNA704949", tax_clade = "FCB group" and tax

10 rows where bioproject = "PRJNA704949", tax_clade = "FCB group" and tax_phylum = "Fidelibacterota"

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_species
27399615	27399615	PRJNA704949_P_NODE_73563_length_898_cov_2.281508_g61923_i0	PRJNA704949	73563	898	2.281508	20.48794184	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	132	5.66e-31	NR	MAV64732.1	2026760	g61923	i0	38.8	0.611358574610245	183	89	61.1	3	280	828	405	564	MAV64732.1 hypothetical protein [Fidelibacterota bacterium]	diamond	549	132	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
28799085	28799085	PRJNA704949_P_NODE_1344907_length_216_cov_1.137725_g1329569_i0	PRJNA704949	1344907	216	1.137725	2.457486	root	1	Root_unresolved	Root_unresolved	71.6	1.75e-12	NR	MBT5355780.1	2026760	g1329569	i0	54.2	2.66666666666667	59	27	81.9	0	180	4	410	468	MBT5355780.1 hypothetical protein [Fidelibacterota bacterium]	diamond	576	71.6	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29241429	29241429	PRJNA704949_P_NODE_2171949_length_162_cov_0.920354_g2156610_i0	PRJNA704949	2171949	162	0.920354	1.49097348	Pseudomonadati	3379134	Bacteria	Bacteria	79.3	8.75e-16	NR	HQC63464.1	2026760	g2156610	i0	63.5	10.5925925925926	52	19	96.3	0	2	157	5	56	HQC63464.1 glycoside hydrolase family 97 catalytic domain-containing protein [Fidelibacterota bacterium]	diamond	1716	79.3	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
29671995	29671995	PRJNA704949_P_NODE_1155730_length_238_cov_1.100529_g1140394_i0	PRJNA704949	1155730	238	1.100529	2.61925902	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	45.1	0.00551	NR	MEA2076940.1	2026760	g1140394	i0	45.2	1.10924369747899	42	23	52.9	0	14	139	1042	1083	MEA2076940.1 family 10 glycosylhydrolase [Fidelibacterota bacterium]	diamond	264	45.1	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30715197	30715197	PRJNA704949_P_NODE_597494_length_351_cov_1.894040_g582171_i0	PRJNA704949	597494	351	1.89404	6.6480804	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	72	7.44e-13	NR	HRS52082.1	2026760	g582171	i0	38.7	1.97435897435897	111	64	93.2	3	1	327	59	167	HRS52082.1 hypothetical protein [Fidelibacterota bacterium]	diamond	693	72	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30872871	30872871	PRJNA704949_P_NODE_154774_length_653_cov_1.490066_g141247_i0	PRJNA704949	154774	653	1.490066	9.73013098	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	209	2.33e-62	NR	MCH7574702.1	2026760	g141247	i0	54.4	1.8698315467075	204	85	93.7	2	41	652	179	374	MCH7574702.1 hypothetical protein [Fidelibacterota bacterium]	diamond	1221	209	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
30968022	30968022	PRJNA704949_P_NODE_2008034_length_167_cov_0.881356_g1992695_i0	PRJNA704949	2008034	167	0.881356	1.47186452	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	60.5	3.92e-9	NR	MCF7838163.1	2026760	g1992695	i0	53.2	0.844311377245509	47	22	84.4	0	1	141	115	161	MCF7838163.1 transferase [Fidelibacterota bacterium]	diamond	141	60.5	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
31010241	31010241	PRJNA704949_P_NODE_1808854_length_177_cov_1.218750_g1793515_i0	PRJNA704949	1808854	177	1.21875	2.1571875	Pseudomonadati	3379134	Bacteria	Bacteria	55.8	9.26e-9	NR	MBT7199718.1	2026760	g1793515	i0	50	8.32203389830508	50	25	84.7	0	27	176	1	50	MBT7199718.1 NAD-dependent succinate-semialdehyde dehydrogenase [Fidelibacterota bacterium]	diamond	1473	56.2	0.99288256227758	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32043278	32043278	PRJNA704949_P_NODE_665258_length_331_cov_1.985816_g649930_i0	PRJNA704949	665258	331	1.985816	6.57305096	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	47.4	0.00258	NR	MBF89209.1	2026760	g649930	i0	39.8	0.797583081570997	88	36	74.3	4	328	83	1333	1409	MBF89209.1 hypothetical protein [Fidelibacterota bacterium]	diamond	264	47.4	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota bacterium
32675035	32675035	PRJNA704949_P_NODE_1577160_length_194_cov_1.793103_g1561821_i0	PRJNA704949	1577160	194	1.793103	3.47861982	Fidelibacterota bacterium	2026760	Bacteria	Bacteria	52.4	3.8e-7	NR	MCH7618670.1	2026760	g1561821	i0	45.1	0.788659793814433	51	28	78.9	0	192	40	14	64	MCH7618670.1 helix-turn-helix domain-containing protein [Fidelibacterota bacterium]	diamond	153	52.4	1	Bacteria	FCB group	Pseudomonadati	Fidelibacterota	Fidelibacterota 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);;