metadata: contig_metadata: 28 rows where analysis = "diamond", bioproject = "PRJNA1010780" and tax

28 rows where analysis = "diamond", bioproject = "PRJNA1010780" 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
26773893	26773893	PRJNA1010780_S_NODE_1641_length_1935_cov_4.725789_g1454_i0	PRJNA1010780	1641	1935	4.725789	91.44401715	Bacteria	2	Bacteria	Bacteria	146	3.61e-33	NR	OIP63676.1	1805221	g1454	i0	36.8	0.995348837209302	321	183	47.8	9	1838	915	19	332	OIP63676.1 MAG: hypothetical protein AUK34_01090 [Ignavibacteria bacterium CG2_30_36_16]	diamond	1926	146	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium CG2_30_36_16
26876676	26876676	PRJNA1010780_S_NODE_31021_length_257_cov_2.081081_g29732_i0	PRJNA1010780	31021	257	2.081081	5.34837817	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	45.8	0.00378	NR	MBI3585648.1	2049428	g29732	i0	38.2	0.642023346303502	55	34	64.2	0	252	88	2139	2193	MBI3585648.1 hypothetical protein [Ignavibacteriales bacterium]	diamond	165	45.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
26900575	26900575	PRJNA1010780_S_NODE_1521_length_1981_cov_11.309866_g1277_i1	PRJNA1010780	1521	1981	11.309866	224.04844546	Pseudomonadati	3379134	Bacteria	Bacteria	152	6.069999999999998e-35	NR	OIP63676.1	1805221	g1277	i1	32.1	1.68248359414437	365	231	54.4	11	1922	846	38	391	OIP63676.1 MAG: hypothetical protein AUK34_01090 [Ignavibacteria bacterium CG2_30_36_16]	diamond	3333	152	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium CG2_30_36_16
27192510	27192510	PRJNA1010780_S_NODE_42622_length_197_cov_1.703704_g41333_i0	PRJNA1010780	42622	197	1.703704	3.35629688	Ignavibacteria bacterium ADurb.Bin266	1852898	Bacteria	Bacteria	77.8	1.19e-15	NR	OQA69936.1	1852898	g41333	i0	66.1	0.944162436548223	62	20	94.4	1	11	196	11	71	OQA69936.1 MAG: Pyridoxine/pyridoxamine 5'-phosphate oxidase [Ignavibacteria bacterium ADurb.Bin266]	diamond	186	77.8	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteria bacterium ADurb.Bin266
27343397	27343397	PRJNA1010780_S_NODE_5183_length_1191_cov_2.781142_g4670_i0	PRJNA1010780	5183	1191	2.781142	33.12340122	Bacteria	2	Bacteria	Bacteria	170	2.01e-43	NR	OIP63676.1	1805221	g4670	i0	34.2	1.98992443324937	395	225	97.2	12	1158	1	16	384	OIP63676.1 MAG: hypothetical protein AUK34_01090 [Ignavibacteria bacterium CG2_30_36_16]	diamond	2370	170	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium CG2_30_36_16
27438144	27438144	PRJNA1010780_S_NODE_1443_length_2017_cov_11.047427_g1277_i0	PRJNA1010780	1443	2017	11.047427	222.82660259	Pseudomonadati	3379134	Bacteria	Bacteria	152	6.76e-35	NR	OIP63676.1	1805221	g1277	i0	32.1	1.6524541398116	365	231	53.4	11	60	1136	38	391	OIP63676.1 MAG: hypothetical protein AUK34_01090 [Ignavibacteria bacterium CG2_30_36_16]	diamond	3333	152	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium CG2_30_36_16
27540322	27540322	PRJNA1010780_S_NODE_6444_length_1053_cov_3.633595_g5794_i0	PRJNA1010780	6444	1053	3.633595	38.26175535	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	51.6	0.00452	NR	MCC6637103.1	2651163	g5794	i0	26.3	1.08262108262108	190	101	51.3	7	138	677	58	218	MCC6637103.1 caspase family protein [Ignavibacteriaceae bacterium]	diamond	1140	51.6	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
27603570	27603570	PRJNA1010780_S_NODE_46444_length_184_cov_3.167785_g45155_i0	PRJNA1010780	46444	184	3.167785	5.8287244	Ignavibacteriales bacterium	2049428	Bacteria	Bacteria	94.7	3.36e-21	NR	HOP49705.1	2049428	g45155	i0	73.8	2.0054347826087	61	16	99.5	0	184	2	7	67	HOP49705.1 molecular chaperone DnaJ [Ignavibacteriales bacterium]	diamond	369	94.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales		Ignavibacteriales bacterium
27785438	27785438	PRJNA1010780_S_NODE_764_length_2489_cov_10.235941_g656_i0	PRJNA1010780	764	2489	10.235941	254.77257149	Bacteria	2	Bacteria	Bacteria	164	1.33e-38	NR	OIP63676.1	1805221	g656	i0	32.2	0.882282040980313	366	229	43.4	10	2449	1370	34	386	OIP63676.1 MAG: hypothetical protein AUK34_01090 [Ignavibacteria bacterium CG2_30_36_16]	diamond	2196	164	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium CG2_30_36_16
27887356	27887356	PRJNA1010780_S_NODE_22645_length_352_cov_2.309148_g21356_i0	PRJNA1010780	22645	352	2.309148	8.12820096	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	49.7	4.05e-4	NR	MBM2816661.1	2053306	g21356	i0	57.5	0.340909090909091	40	17	34.1	0	347	228	277	316	MBM2816661.1 hypothetical protein [Ignavibacteria bacterium]	diamond	120	49.7	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
27918947	27918947	PRJNA1010780_S_NODE_21405_length_373_cov_4.455621_g20116_i0	PRJNA1010780	21405	373	4.455621	16.61946633	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	45.4	0.00887	NR	HMQ79834.1	2053306	g20116	i0	29.7	0.812332439678284	101	64	75.6	1	329	48	76	176	HMQ79834.1 GNAT family protein [Ignavibacteria bacterium]	diamond	303	45.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
27943175	27943175	PRJNA1010780_S_NODE_10665_length_733_cov_2.660458_g9673_i0	PRJNA1010780	10665	733	2.660458	19.50115714	FCB group	1783270	Bacteria	Bacteria	48.1	0.00316	NR	MBM2817261.1	2053306	g9673	i0	54.5	0.64256480218281	33	15	13.5	0	5	103	5	37	MBM2817261.1 hypothetical protein [Ignavibacteria bacterium]	diamond	471	48.5	0.991752577319588	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
28076800	28076800	PRJNA1010780_S_NODE_23765_length_334_cov_2.357860_g22476_i0	PRJNA1010780	23765	334	2.35786	7.8752524	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	43.5	0.0126	NR	MBI2794329.1	2053306	g22476	i0	30.9	0.844311377245509	94	62	81.7	2	2	274	13	106	MBI2794329.1 adenylate/guanylate cyclase domain-containing protein [Ignavibacteria bacterium]	diamond	282	43.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
28195471	28195471	PRJNA1010780_S_NODE_1586_length_1954_cov_49.720688_g1407_i0	PRJNA1010780	1586	1954	49.720688	971.54224352	Bacteria	2	Bacteria	Bacteria	164	2.34e-39	NR	OIP63676.1	1805221	g1407	i0	34.3	1.12691914022518	367	211	54	10	155	1210	74	425	OIP63676.1 MAG: hypothetical protein AUK34_01090 [Ignavibacteria bacterium CG2_30_36_16]	diamond	2202	164	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium CG2_30_36_16
28424377	28424377	PRJNA1010780_S_NODE_36026_length_225_cov_1.921053_g34737_i0	PRJNA1010780	36026	225	1.921053	4.32236925	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	48.1	3.73e-4	NR	MCX7876282.1	2614255	g34737	i0	43.6	0.733333333333333	55	30	73.3	1	49	213	312	365	MCX7876282.1 D-alanyl-D-alanine carboxypeptidase/D-alanyl-D-alanine-endopeptidase [Melioribacteraceae bacterium]	diamond	165	48.1	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
28606106	28606106	PRJNA1010780_S_NODE_23107_length_344_cov_2.990291_g21818_i0	PRJNA1010780	23107	344	2.990291	10.28660104	Pseudomonadati	3379134	Bacteria	Bacteria	100	9.3e-22	NR	MCB0728534.1	2026749	g21818	i0	48.6	4.00290697674419	111	41	94.2	2	329	6	336	433	MCB0728534.1 FG-GAP repeat protein [Ignavibacteriota bacterium]	diamond	1377	100	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
28645356	28645356	PRJNA1010780_S_NODE_27307_length_290_cov_2.937255_g26018_i0	PRJNA1010780	27307	290	2.937255	8.5180395	Ignavibacteriaceae bacterium	2651163	Bacteria	Bacteria	62.4	7.31e-9	NR	HSD64440.1	2651163	g26018	i0	36.5	0.993103448275862	96	54	99.3	3	290	3	122	210	HSD64440.1 sorbosone dehydrogenase family protein [Ignavibacteriaceae bacterium]	diamond	288	62.4	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
28961204	28961204	PRJNA1010780_S_NODE_11068_length_710_cov_3.802963_g10050_i0	PRJNA1010780	11068	710	3.802963	27.0010373	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	214	1.44e-66	NR	HEX2787349.1	2053306	g10050	i0	50.5	0.777464788732394	184	91	77.7	0	9	560	1	184	HEX2787349.1 DUF899 family protein [Ignavibacteria bacterium]	diamond	552	214	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
29016931	29016931	PRJNA1010780_S_NODE_13528_length_597_cov_3.759786_g12375_i0	PRJNA1010780	13528	597	3.759786	22.44592242	Pseudomonadati	3379134	Bacteria	Bacteria	113	8.36e-28	NR	OGV03533.1	1798447	g12375	i0	40.1	5.66331658291457	157	83	74.9	5	36	482	13	166	OGV03533.1 MAG: hypothetical protein A2330_06670 [Ignavibacteria bacterium RIFOXYB2_FULL_36_7]	diamond	3381	113	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium RIFOXYB2_FULL_36_7
29781872	29781872	PRJNA1010780_S_NODE_26191_length_303_cov_2.089552_g24902_i0	PRJNA1010780	26191	303	2.089552	6.33134256	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	75.5	2.4e-13	NR	MFI5143979.1	2053306	g24902	i0	62.5	3.43564356435644	56	21	55.4	0	1	168	547	602	MFI5143979.1 ABC transporter ATP-binding protein [Ignavibacteria bacterium]	diamond	1041	75.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
29876808	29876808	PRJNA1010780_S_NODE_46531_length_184_cov_2.046980_g45242_i0	PRJNA1010780	46531	184	2.04698	3.7664432	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	58.5	4.41e-8	NR	MBK9331724.1	2053306	g45242	i0	50	1.6304347826087	50	25	81.5	0	155	6	592	641	MBK9331724.1 SDR family NAD(P)-dependent oxidoreductase [Ignavibacteria bacterium]	diamond	300	58.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
30224152	30224152	PRJNA1010780_S_NODE_62392_length_151_cov_2.767241_g61103_i0	PRJNA1010780	62392	151	2.767241	4.17853391	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	63.2	6.65e-10	NR	HRI86226.1	2053306	g61103	i0	67.5	1.58940397350993	40	13	79.5	0	135	16	151	190	HRI86226.1 FG-GAP-like repeat-containing protein [Ignavibacteria bacterium]	diamond	240	63.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
30256099	30256099	PRJNA1010780_S_NODE_25292_length_313_cov_3.179856_g24003_i0	PRJNA1010780	25292	313	3.179856	9.95294928	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	63.2	5.3e-9	NR	MCF8243193.1	2614255	g24003	i0	38	0.881789137380192	92	56	88.2	1	36	311	245	335	MCF8243193.1 MATE family efflux transporter [Melioribacteraceae bacterium]	diamond	276	63.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
30406558	30406558	PRJNA1010780_S_NODE_29753_length_267_cov_1.987069_g28464_i0	PRJNA1010780	29753	267	1.987069	5.30547423	Bacteria	2	Bacteria	Bacteria	85.9	3.34e-17	NR	QKJ99511.1	2026749	g28464	i0	69.4	8.89887640449438	62	19	69.7	0	187	2	609	670	QKJ99511.1 MAG: PAS domain S-box protein [Ignavibacteriota bacterium]	diamond	2376	86.7	0.990772779700115	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota				Ignavibacteriota bacterium
31544115	31544115	PRJNA1010780_S_NODE_59756_length_155_cov_2.666667_g58467_i0	PRJNA1010780	59756	155	2.666667	4.13333385	Pseudomonadati	3379134	Bacteria	Bacteria	56.2	1.92e-7	NR	NUM72479.1	2651163	g58467	i0	53.2	2.8258064516129	47	22	91	0	13	153	92	138	NUM72479.1 phosphodiester glycosidase family protein [Ignavibacteriaceae bacterium]	diamond	438	56.2	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Ignavibacteriaceae	Ignavibacteriaceae bacterium
32216047	32216047	PRJNA1010780_S_NODE_49398_length_176_cov_3.141844_g48109_i0	PRJNA1010780	49398	176	3.141844	5.52964544	Melioribacteraceae bacterium	2614255	Bacteria	Bacteria	60.5	7.37e-9	NR	MBX3009837.1	2614255	g48109	i0	61.4	1.94318181818182	57	21	97.2	1	173	3	103	158	MBX3009837.1 EF-hand domain-containing protein [Melioribacteraceae bacterium]	diamond	342	60.5	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria	Ignavibacteriales	Melioribacteraceae	Melioribacteraceae bacterium
32595641	32595641	PRJNA1010780_S_NODE_56320_length_161_cov_2.706349_g55031_i0	PRJNA1010780	56320	161	2.706349	4.35722189	Ignavibacteria bacterium	2053306	Bacteria	Bacteria	42	0.0231	NR	NLT50021.1	2053306	g55031	i0	50	0.93167701863354	50	22	87.6	1	155	15	31	80	NLT50021.1 T9SS type A sorting domain-containing protein [Ignavibacteria bacterium]	diamond	150	42	1	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria bacterium
32839691	32839691	PRJNA1010780_S_NODE_51440_length_172_cov_1.043796_g50151_i0	PRJNA1010780	51440	172	1.043796	1.79532912	Pseudomonadati	3379134	Bacteria	Bacteria	45.8	3.96e-4	NR	MBM2817261.1	2053306	g50151	i0	57.6	1.7093023255814	33	14	57.6	0	8	106	5	37	MBM2817261.1 hypothetical protein [Ignavibacteria bacterium]	diamond	294	46.2	0.991341991341991	Bacteria	FCB group	Pseudomonadati	Ignavibacteriota	Ignavibacteria			Ignavibacteria 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);;