metadata: contig_metadata: 16 rows where analysis = "diamond", bioproject = "PRJNA674050" and tax

16 rows where analysis = "diamond", bioproject = "PRJNA674050" and tax_phylum = "Chloroflexota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_species
8297122	8297122	PRJNA674050_P_NODE_26747_length_249_cov_1.448864_g26544_i0	PRJNA674050	26747	249	1.448864	3.60767136	Bacillati	1783272	Bacteria	Bacteria	162	9.63e-47	NR	MAS34095.1	2024896	g26544	i0	95.2	3	83	4	100	0	1	249	54	136	MAS34095.1 cyclic nucleotide-binding protein [Anaerolineaceae bacterium]	diamond	747	162	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
27018485	27018485	PRJNA674050_P_NODE_22842_length_252_cov_0.871508_g22639_i0	PRJNA674050	22842	252	0.871508	2.19620016	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	48.9	2.67e-5	NR	MBN2100151.1	2026734	g22639	i0	70.4	0.321428571428571	27	8	32.1	0	5	85	7	33	MBN2100151.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	81	48.9	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
27144564	27144564	PRJNA674050_P_NODE_31862_length_246_cov_0.901734_g31659_i0	PRJNA674050	31862	246	0.901734	2.21826564	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	108	3.1e-25	NR	MEX1252800.1	2026734	g31659	i0	61	1	82	32	100	0	246	1	242	323	MEX1252800.1 ATPase, T2SS/T4P/T4SS family [Dehalococcoidia bacterium]	diamond	246	108	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
27366520	27366520	PRJNA674050_P_NODE_27263_length_249_cov_0.886364_g27060_i0	PRJNA674050	27263	249	0.886364	2.20704636	Chloroflexota bacterium	2026724	Bacteria	Bacteria	88.2	3.58e-18	NR	MEP7289128.1	2026724	g27060	i0	58.9	0.879518072289157	73	30	88	0	219	1	272	344	MEP7289128.1 UDP-N-acetylmuramate--L-alanine ligase [Chloroflexota bacterium]	diamond	219	88.2	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
28471481	28471481	PRJNA674050_P_NODE_22206_length_253_cov_0.866667_g22003_i0	PRJNA674050	22206	253	0.866667	2.19266751	Anaerolineae bacterium	2052143	Bacteria	Bacteria	78.6	1e-14	NR	MBZ0291734.1	2052143	g22003	i0	48.7	0.924901185770751	78	40	92.5	0	3	236	165	242	MBZ0291734.1 PAS domain S-box protein [Anaerolineae bacterium]	diamond	234	78.6	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
28976676	28976676	PRJNA674050_P_NODE_23028_length_252_cov_0.871508_g22825_i0	PRJNA674050	23028	252	0.871508	2.19620016	Chloroflexota bacterium	2026724	Bacteria	Bacteria	50.4	7.86e-5	NR	MCX6050304.1	2026724	g22825	i0	32.1	0.964285714285714	81	55	96.4	0	245	3	265	345	MCX6050304.1 Wzz/FepE/Etk N-terminal domain-containing protein [Chloroflexota bacterium]	diamond	243	50.4	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
29039913	29039913	PRJNA674050_P_NODE_38968_length_242_cov_0.923077_g38765_i0	PRJNA674050	38968	242	0.923077	2.23384634	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	50.4	9.5e-6	NR	MFA5379426.1	2026734	g38765	i0	38	0.880165289256198	71	43	88	1	22	234	17	86	MFA5379426.1 phage head closure protein [Dehalococcoidia bacterium]	diamond	213	50.4	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia			Dehalococcoidia bacterium
29398851	29398851	PRJNA674050_P_NODE_33349_length_245_cov_1.348837_g33146_i0	PRJNA674050	33349	245	1.348837	3.30465065	Bacillati	1783272	Bacteria	Bacteria	128	1.6100000000000002e-33	NR	MBZ0300000.1	2052143	g33146	i0	76.6	1.88571428571429	77	18	94.3	0	1	231	119	195	MBZ0300000.1 UDP-N-acetylglucosamine--N-acetylmuramyl-(pentapeptide) pyrophosphoryl-undecaprenol N-acetylglucosamine transferase [Anaerolineae bacterium]	diamond	462	129	0.992248062015504	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
29430255	29430255	PRJNA674050_P_NODE_28969_length_248_cov_0.885714_g28766_i0	PRJNA674050	28969	248	0.885714	2.19657072	Chloroflexota	200795	Bacteria	Bacteria	124	1.5999999999999998e-32	NR	MCA9967201.1	2073117	g28766	i0	66.3	4.82661290322581	80	27	96.8	0	3	242	4	83	MCA9967201.1 tRNA-dihydrouridine synthase family protein [Anaerolineales bacterium]	diamond	1197	125	0.992	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales		Anaerolineales bacterium
29714293	29714293	PRJNA674050_P_NODE_24470_length_251_cov_0.870787_g24267_i0	PRJNA674050	24470	251	0.870787	2.18567537	Bacteria	2	Bacteria	Bacteria	96.7	1.73e-21	NR	MYA60366.1	2026724	g24267	i0	72.4	2.05577689243028	58	16	69.3	0	3	176	323	380	MYA60366.1 Gfo/Idh/MocA family oxidoreductase [Chloroflexota bacterium]	diamond	516	97.4	0.992813141683778	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30725537	30725537	PRJNA674050_P_NODE_30214_length_247_cov_0.896552_g30011_i0	PRJNA674050	30214	247	0.896552	2.21448344	Bacillati	1783272	Bacteria	Bacteria	124	5.779999999999999e-32	NR	MDP8905305.1	2026724	g30011	i0	73.2	3.01214574898785	82	20	99.6	2	2	247	213	292	MDP8905305.1 hypothetical protein [Chloroflexota bacterium]	diamond	744	124	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
30871601	30871601	PRJNA674050_P_NODE_29854_length_247_cov_1.620690_g29651_i0	PRJNA674050	29854	247	1.62069	4.0031043	Anaerolineae bacterium	2052143	Bacteria	Bacteria	120	8.77e-33	NR	MCI0552902.1	2052143	g29651	i0	74.4	0.995951417004049	82	21	99.6	0	246	1	16	97	MCI0552902.1 SDR family NAD(P)-dependent oxidoreductase [Anaerolineae bacterium]	diamond	246	120	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
30966614	30966614	PRJNA674050_P_NODE_30974_length_247_cov_0.885057_g30771_i0	PRJNA674050	30974	247	0.885057	2.18609079	Chloroflexota bacterium	2026724	Bacteria	Bacteria	88.6	2.66e-18	NR	MCL6650630.1	2026724	g30771	i0	54.4	1.93117408906883	79	36	96	0	3	239	224	302	MCL6650630.1 PAS domain S-box protein [Chloroflexota bacterium]	diamond	477	88.6	1	Bacteria	Bacillati	Chloroflexota				Chloroflexota bacterium
31915046	31915046	PRJNA674050_P_NODE_30877_length_247_cov_0.890805_g30674_i0	PRJNA674050	30877	247	0.890805	2.20028835	Anaerolineae bacterium	2052143	Bacteria	Bacteria	141	8.14e-39	NR	MCC7449544.1	2052143	g30674	i0	88.8	0.97165991902834	80	9	97.2	0	245	6	274	353	MCC7449544.1 ABC transporter substrate-binding protein [Anaerolineae bacterium]	diamond	240	141	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae			Anaerolineae bacterium
32104877	32104877	PRJNA674050_P_NODE_5638_length_341_cov_1.156716_g5435_i0	PRJNA674050	5638	341	1.156716	3.94440156	Anaerolineaceae bacterium	2024896	Bacteria	Bacteria	74.3	9.56e-13	NR	MAS34279.1	2024896	g5435	i0	57.9	0.501466275659824	57	24	50.1	0	176	6	1	57	MAS34279.1 hypothetical protein [Anaerolineaceae bacterium]	diamond	171	74.3	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolineaceae bacterium
32748771	32748771	PRJNA674050_P_NODE_12320_length_287_cov_1.205607_g12117_i0	PRJNA674050	12320	287	1.205607	3.46009209	Bacteria	2	Bacteria	Bacteria	173	3.85e-49	NR	RLC65980.1	2026724	g12117	i0	84.2	7.94425087108014	95	15	99.3	0	286	2	447	541	RLC65980.1 MAG: hypothetical protein DRI48_05765 [Chloroflexota bacterium]	diamond	2280	174	0.994252873563218	Bacteria	Bacillati	Chloroflexota				Chloroflexota 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);;