metadata: contig_metadata: 20 rows where analysis = "diamond", bioproject = "PRJNA1068830" and tax

20 rows where analysis = "diamond", bioproject = "PRJNA1068830" 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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
9110387	9110387	PRJNA1068830_P_NODE_45728_length_326_cov_1.177866_g45025_i0	PRJNA1068830	45728	326	1.177866	3.83984316	Candidatus Thermofonsia Clade 3 bacterium	2364212	Bacteria	Bacteria	209	8.72e-66	NR	PJF46338.1	2364212	g45025	i0	85.2	0.993865030674847	108	16	99.4	0	324	1	90	197	PJF46338.1 MAG: hypothetical protein CUN48_14305, partial [Candidatus Thermofonsia Clade 3 bacterium]	diamond	324	209	1	Bacteria	Candidatus Thermofonsia Clade 3	Bacillati	Chloroflexota	Candidatus Thermofontia				Candidatus Thermofonsia Clade 3 bacterium
11662465	11662465	PRJNA1068830_P_NODE_85530_length_244_cov_0.912281_g84827_i0	PRJNA1068830	85530	244	0.912281	2.22596564	Caldilineales bacterium	2306055	Bacteria	Bacteria	114	2.38e-27	NR	MCS6844150.1	2306055	g84827	i0	81.2	0.848360655737705	69	13	84.8	0	242	36	445	513	MCS6844150.1 penicillin-binding protein 1C [Caldilineales bacterium]	diamond	207	114	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales			Caldilineales bacterium
14211225	14211225	PRJNA1068830_P_NODE_33472_length_391_cov_1.493711_g32769_i0	PRJNA1068830	33472	391	1.493711	5.84041001	Anaerolineae bacterium	2052143	Bacteria	Bacteria	68.9	1.24e-10	NR	MFQ3658943.1	2052143	g32769	i0	54.2	0.552429667519182	72	25	49.9	2	191	385	22	92	MFQ3658943.1 phosphate ABC transporter substrate-binding protein PstS family protein [Anaerolineae bacterium]	diamond	216	68.9	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
15486371	15486371	PRJNA1068830_P_NODE_78933_length_248_cov_2.057143_g78230_i0	PRJNA1068830	78933	248	2.057143	5.10171464	Bellilinea sp.	2838785	Bacteria	Bacteria	146	7.65e-41	NR	MEN4013923.1	2838785	g78230	i0	97.3	0.895161290322581	74	2	89.5	0	2	223	253	326	MEN4013923.1 IS481 family transposase [Bellilinea sp.]	diamond	222	146	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Bellilinea	Bellilinea sp.
26972343	26972343	PRJNA1068830_P_NODE_81382_length_247_cov_0.896552_g80679_i0	PRJNA1068830	81382	247	0.896552	2.21448344	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	43.9	0.0147	NR	MDP2935171.1	2026734	g80679	i0	36.2	0.838056680161943	69	44	83.8	0	223	17	137	205	MDP2935171.1 aspartate-semialdehyde dehydrogenase [Dehalococcoidia bacterium]	diamond	207	43.9	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
27003891	27003891	PRJNA1068830_P_NODE_24502_length_473_cov_2.245000_g23801_i0	PRJNA1068830	24502	473	2.245	10.61885	Chloroflexota bacterium	2026724	Bacteria	Bacteria	286	1.37e-93	NR	MEM7131323.1	2026724	g23801	i0	84.7	3.9830866807611	157	24	99.6	0	3	473	195	351	MEM7131323.1 threonine synthase [Chloroflexota bacterium]	diamond	1884	286	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
27572863	27572863	PRJNA1068830_P_NODE_82804_length_246_cov_0.901734_g82101_i0	PRJNA1068830	82804	246	0.901734	2.21826564	Chloroflexota bacterium	2026724	Bacteria	Bacteria	45.1	0.00551	NR	MDP9250258.1	2026724	g82101	i0	50	0.463414634146341	38	19	46.3	0	92	205	164	201	MDP9250258.1 cytochrome c oxidase assembly protein [Chloroflexota bacterium]	diamond	114	45.1	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
27572864	27572864	PRJNA1068830_P_NODE_83044_length_245_cov_3.040698_g82341_i0	PRJNA1068830	83044	245	3.040698	7.4497101	Dehalogenimonas formicexedens	1839801	Bacteria	Bacteria	84.7	7.72e-19	NR	WP_076004864.1	1839801	g82341	i0	65.2	0.808163265306122	66	21	78.4	1	51	242	4	69	WP_076004864.1 hypothetical protein [Dehalogenimonas formicexedens]	diamond	198	84.7	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia	Dehalococcoidales	Dehalococcoidaceae	Dehalogenimonas	Dehalogenimonas formicexedens
28583377	28583377	PRJNA1068830_P_NODE_14587_length_643_cov_1.657895_g13910_i0	PRJNA1068830	14587	643	1.657895	10.66026485	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	49.3	0.00643	NR	HTK09643.1	2740538	g13910	i0	26.4	0.601866251944012	129	85	55.5	3	570	214	18	146	HTK09643.1 ABC transporter substrate-binding protein [Ktedonobacteraceae bacterium]	diamond	387	49.3	1	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
28898777	28898777	PRJNA1068830_P_NODE_28188_length_433_cov_2.616667_g27485_i0	PRJNA1068830	28188	433	2.616667	11.33016811	Chloroflexota bacterium	2026724	Bacteria	Bacteria	144	8.36e-39	NR	MYD10742.1	2026724	g27485	i0	74	3.95612009237875	96	25	66.5	0	432	145	235	330	MYD10742.1 modification methylase [Chloroflexota bacterium]	diamond	1713	144	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
29151914	29151914	PRJNA1068830_P_NODE_24849_length_469_cov_1.540404_g24148_i0	PRJNA1068830	24849	469	1.540404	7.22449476	Chloroflexota bacterium	2026724	Bacteria	Bacteria	72.8	3.62e-13	NR	MBT7005048.1	2026724	g24148	i0	40.4	0.601279317697228	94	56	60.1	0	287	6	3	96	MBT7005048.1 hypothetical protein [Chloroflexota bacterium]	diamond	282	72.8	1	Bacteria		Bacillati	Chloroflexota					Chloroflexota bacterium
29466943	29466943	PRJNA1068830_P_NODE_12490_length_703_cov_2.123810_g11825_i0	PRJNA1068830	12490	703	2.12381	14.9303843	Anaerolineae bacterium	2052143	Bacteria	Bacteria	122	8.34e-28	NR	MCL4871592.1	2052143	g11825	i0	45.9	0.725462304409673	170	81	70	4	698	207	450	614	MCL4871592.1 fasciclin domain-containing protein [Anaerolineae bacterium]	diamond	510	122	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
29593210	29593210	PRJNA1068830_P_NODE_87290_length_243_cov_0.917647_g86587_i0	PRJNA1068830	87290	243	0.917647	2.22988221	Caldilinea sp.	2293560	Bacteria	Bacteria	165	2.15e-49	NR	MFN3983691.1	2293560	g86587	i0	98.8	1.97530864197531	80	1	98.8	0	3	242	127	206	MFN3983691.1 ATP-binding protein [Caldilinea sp.]	diamond	480	165	1	Bacteria		Bacillati	Chloroflexota	Caldilineae	Caldilineales	Caldilineaceae	Caldilinea	Caldilinea sp.
30595858	30595858	PRJNA1068830_P_NODE_80153_length_248_cov_0.891429_g79450_i0	PRJNA1068830	80153	248	0.891429	2.21074392	Anaerolinea	233189	Bacteria	Bacteria	160	1.19e-43	NR	MBE2231926.1	1872519	g79450	i0	91.5	2.9758064516129	82	7	99.2	0	3	248	745	826	MBE2231926.1 hypothetical protein [Anaerolinea sp.]	diamond	738	160	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Anaerolinea	Anaerolinea sp.
30762534	30762534	PRJNA1068830_P_NODE_84714_length_244_cov_1.824561_g84011_i0	PRJNA1068830	84714	244	1.824561	4.45192884	Bellilinea sp.	2838785	Bacteria	Bacteria	164	9.41e-48	NR	MEN4013923.1	2838785	g84011	i0	100	0.995901639344262	81	0	99.6	0	1	243	92	172	MEN4013923.1 IS481 family transposase [Bellilinea sp.]	diamond	243	164	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Bellilinea	Bellilinea sp.
31291083	31291083	PRJNA1068830_P_NODE_51155_length_306_cov_1.313305_g50452_i0	PRJNA1068830	51155	306	1.313305	4.0187133	PVC group	1783257	Bacteria	Bacteria	61.2	2.45e-8	NR	WP_235845877.1	1936993	g50452	i0	50	1.19607843137255	62	29	60.8	1	305	120	385	444	WP_235845877.1 alpha-galactosidase D [Dictyobacter aurantiacus]	diamond	366	61.6	0.993506493506494	Bacteria		Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Dictyobacteraceae	Dictyobacter	Dictyobacter aurantiacus
31426139	31426139	PRJNA1068830_P_NODE_56556_length_289_cov_2.148148_g55853_i0	PRJNA1068830	56556	289	2.148148	6.20814772	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	43.5	0.0338	NR	HXF50670.1	2026734	g55853	i0	40	0.519031141868512	50	30	51.9	0	82	231	82	131	HXF50670.1 hypothetical protein [Dehalococcoidia bacterium]	diamond	150	43.5	1	Bacteria		Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
32027231	32027231	PRJNA1068830_P_NODE_66158_length_266_cov_1.616580_g65455_i0	PRJNA1068830	66158	266	1.61658	4.3001028	Anaerolineales bacterium	2073117	Bacteria	Bacteria	57	2.65e-8	NR	MFN2233883.1	2073117	g65455	i0	41.3	0.845864661654135	75	44	84.6	0	248	24	3	77	MFN2233883.1 hypothetical protein [Anaerolineales bacterium]	diamond	225	57	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
32565385	32565385	PRJNA1068830_P_NODE_38519_length_360_cov_1.355401_g37816_i0	PRJNA1068830	38519	360	1.355401	4.8794436	Anaerolineae bacterium	2052143	Bacteria	Bacteria	80.5	4.76e-15	NR	MBZ0295834.1	2052143	g37816	i0	39.3	1.88333333333333	112	63	93.3	2	359	24	69	175	MBZ0295834.1 DUF1071 domain-containing protein [Anaerolineae bacterium]	diamond	678	80.5	1	Bacteria		Bacillati	Chloroflexota	Anaerolineae				Anaerolineae bacterium
32650866	32650866	PRJNA1068830_P_NODE_53600_length_298_cov_1.386667_g52897_i0	PRJNA1068830	53600	298	1.386667	4.13226766	Bacteria	2	Bacteria	Bacteria	190	6.309999999999999e-57	NR	MEM7131323.1	2026724	g52897	i0	84.8	5.96979865771812	99	15	99.7	0	1	297	165	263	MEM7131323.1 threonine synthase [Chloroflexota bacterium]	diamond	1779	191	0.994764397905759	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);;