metadata: contig_metadata: 26 rows where bioproject = "PRJNA1137393" and tax

26 rows where bioproject = "PRJNA1137393" and tax_phylum = "Armatimonadota"

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_genus	tax_species
1032069	1032069	PRJNA1137393_P_NODE_3521_length_496_cov_1.384787_g3010_i0	PRJNA1137393	3521	496	1.384787	6.86854352	Chthonomonas	1077265	Bacteria	Bacteria	372	3.27e-98	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g3010	i0	80.46	32.1391129032258	522	72	100	20	1	496	1667	1150	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	15941	372	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
1032134	1032134	PRJNA1137393_P_NODE_8701_length_282_cov_2.969957_g8185_i0	PRJNA1137393	8701	282	2.969957	8.37527874	Chthonomonas	1077265	Bacteria	Bacteria	257	5.1400000000000006e-64	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g8185	i0	83.333	254.106382978723	282	43	99	2	4	281	11	292	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	71658	257	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
1559298	1559298	PRJNA1137393_P_NODE_33382_length_176_cov_2.236220_g32866_i0	PRJNA1137393	33382	176	2.23622	3.9357472	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	100	5.23e-17	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g32866	i0	83.186	0.642045454545455	113	15	64	4	12	123	3916307	3916198	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	113	100	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
2835454	2835454	PRJNA1137393_P_NODE_51323_length_167_cov_0.881356_g50807_i0	PRJNA1137393	51323	167	0.881356	1.47186452	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	152	1.3399999999999998e-32	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g50807	i0	91.743	3.16167664670659	109	9	65	0	8	116	1307021	1306913	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	528	152	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
5388062	5388062	PRJNA1137393_P_NODE_8045_length_295_cov_1.081301_g7529_i0	PRJNA1137393	8045	295	1.081301	3.18983795	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	259	1.5e-64	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g7529	i0	83.509	266.583050847458	285	40	95	7	1	281	1304508	1304789	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	78642	259	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
6134874	6134874	PRJNA1137393_P_NODE_15785_length_218_cov_2.639053_g15269_i0	PRJNA1137393	15785	218	2.639053	5.75313554	Fimbriimonas	1005038	Bacteria	Bacteria	300	6.23e-77	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g15269	i0	91.667	71.8532110091743	216	18	99	0	3	218	29133	28918	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	15664	300	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
6662565	6662565	PRJNA1137393_P_NODE_3666_length_484_cov_2.501149_g3154_i0	PRJNA1137393	3666	484	2.501149	12.10556116	Capsulimonas corticalis	2219043	Bacteria	Bacteria	667	0	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g3154	i0	91.546	216.21694214876	485	40	100	1	1	484	594503	594987	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	104649	667	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
8685144	8685144	PRJNA1137393_P_NODE_32647_length_177_cov_2.000000_g32131_i0	PRJNA1137393	32647	177	2	3.54	Chthonomonas	1077265	Bacteria	Bacteria	171	3.96e-38	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g32131	i0	84.066	169.531073446328	182	24	100	4	1	177	733	552	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	30007	171	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
9212750	9212750	PRJNA1137393_P_NODE_4848_length_403_cov_2.661017_g4333_i0	PRJNA1137393	4848	403	2.661017	10.72389851	Capsulimonas corticalis	2219043	Bacteria	Bacteria	470	8.999999999999999e-128	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g4333	i0	93.168	243.54094292804	322	19	79	3	2	320	593568	593889	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	98147	470	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
9960213	9960213	PRJNA1137393_P_NODE_35508_length_173_cov_4.564516_g34992_i0	PRJNA1137393	35508	173	4.564516	7.89661268	Fimbriimonas	1005038	Bacteria	Bacteria	187	3.82e-43	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g34992	i0	89.796	129.849710982659	147	14	85	1	27	173	29518	29663	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	22464	187	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
11763300	11763300	PRJNA1137393_P_NODE_15570_length_219_cov_2.335294_g15054_i0	PRJNA1137393	15570	219	2.335294	5.11429386	Capsulimonas corticalis	2219043	Bacteria	Bacteria	191	3.94e-44	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g15054	i0	86.111	174.7899543379	180	22	81	3	1	178	592866	592688	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	38279	191	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
13785504	13785504	PRJNA1137393_P_NODE_7751_length_301_cov_1.706349_g7235_i0	PRJNA1137393	7751	301	1.706349	5.13611049	Chthonomonas	1077265	Bacteria	Bacteria	385	2.43e-102	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g7235	i0	89.701	240.664451827243	301	31	100	0	1	301	1902	2202	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	72440	385	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
15059707	15059707	PRJNA1137393_P_NODE_13332_length_231_cov_2.736264_g12816_i0	PRJNA1137393	13332	231	2.736264	6.32076984	Chthonomonas	1077265	Bacteria	Bacteria	276	1.13e-69	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g12816	i0	88.312	709.874458874459	231	26	99	1	1	230	2601	2831	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	163981	276	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
15059783	15059783	PRJNA1137393_P_NODE_5652_length_365_cov_5.224684_g5136_i0	PRJNA1137393	5652	365	5.224684	19.0700966	Fimbriimonas	1005038	Bacteria	Bacteria	507	6.15e-139	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g5136	i0	91.781	230.835616438356	365	28	100	1	1	365	28429	28791	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	84255	507	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
19410580	19410580	PRJNA1137393_P_NODE_12896_length_234_cov_2.832432_g12380_i0	PRJNA1137393	12896	234	2.832432	6.62789088	Capsulimonas corticalis	2219043	Bacteria	Bacteria	237	5.3900000000000005e-58	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g12380	i0	90.909	196.846153846154	176	16	75	0	59	234	595251	595426	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	46062	237	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
19410632	19410632	PRJNA1137393_P_NODE_26896_length_186_cov_1.686131_g26380_i0	PRJNA1137393	26896	186	1.686131	3.13620366	Capsulimonas corticalis	2219043	Bacteria	Bacteria	272	1.12e-68	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g26380	i0	93.011	689.021505376344	186	13	100	0	1	186	595560	595375	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	128158	272	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
20686278	20686278	PRJNA1137393_P_NODE_73977_length_160_cov_2.621622_g73461_i0	PRJNA1137393	73977	160	2.621622	4.1945952	Capsulimonas corticalis	2219043	Bacteria	Bacteria	263	5.629999999999999e-66	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g73461	i0	96.25	495.825	160	6	100	0	1	160	593588	593429	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	79332	263	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
21434010	21434010	PRJNA1137393_P_NODE_5777_length_360_cov_3.897106_g5261_i0	PRJNA1137393	5777	360	3.897106	14.0295816	Fimbriimonas	1005038	Bacteria	Bacteria	521	2.16e-143	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g5261	i0	92.798	497.555555555556	361	24	100	2	1	360	26827	27186	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	179120	521	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
21961606	21961606	PRJNA1137393_P_NODE_6318_length_341_cov_1.616438_g5802_i0	PRJNA1137393	6318	341	1.616438	5.51205358	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	366	1.0099999999999999e-96	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g5802	i0	86.471	343.360703812317	340	39	99	7	5	341	3408372	3408037	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	117086	366	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
22708909	22708909	PRJNA1137393_P_NODE_18018_length_209_cov_1.300000_g17502_i0	PRJNA1137393	18018	209	1.3	2.717	Chthonomonas	1077265	Bacteria	Bacteria	222	1.32e-53	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g17502	i0	86.829	90.8325358851675	205	20	95	2	12	209	214	10	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	18984	222	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
28638682	28638682	PRJNA1137393_P_NODE_55687_length_166_cov_0.888889_g55171_i0	PRJNA1137393	55687	166	0.888889	1.47555574	FCB group	1783270	Bacteria	Bacteria	45.4	0.00142	NR	HEY3379101.1	2033014	g55171	i0	64.5	3.90361445783133	31	11	56	0	3	95	371	401	HEY3379101.1 FAD-dependent oxidoreductase [Armatimonadota bacterium]	diamond	648	45.8	0.991266375545852	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29817512	29817512	PRJNA1137393_P_NODE_64411_length_164_cov_0.904348_g63895_i0	PRJNA1137393	64411	164	0.904348	1.48313072	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	56.2	2.19e-7	NR	MBC8066543.1	2682144	g63895	i0	59.2	0.896341463414634	49	20	89.6	0	147	1	1	49	MBC8066543.1 LCP family protein [Fimbriimonadaceae bacterium]	diamond	147	56.2	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
30291966	30291966	PRJNA1137393_P_NODE_43192_length_168_cov_1.596639_g42676_i0	PRJNA1137393	43192	168	1.596639	2.68235352	Armatimonadota bacterium	2033014	Bacteria	Bacteria	102	3.13e-24	NR	MBV9849596.1	2033014	g42676	i0	90.9	0.982142857142857	55	5	98.2	0	165	1	27	81	MBV9849596.1 type II and III secretion system protein [Armatimonadota bacterium]	diamond	165	102	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30860298	30860298	PRJNA1137393_P_NODE_42354_length_169_cov_0.866667_g41838_i0	PRJNA1137393	42354	169	0.866667	1.46466723	Armatimonadota bacterium	2033014	Bacteria	Bacteria	96.7	1.4200000000000002e-21	NR	MBC8140416.1	2033014	g41838	i0	85.7	0.994082840236686	56	8	99.4	0	169	2	751	806	MBC8140416.1 DUF1592 domain-containing protein [Armatimonadota bacterium]	diamond	168	96.7	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
31903612	31903612	PRJNA1137393_P_NODE_55377_length_166_cov_0.888889_g54861_i0	PRJNA1137393	55377	166	0.888889	1.47555574	Capsulimonadaceae bacterium	2953755	Bacteria	Bacteria	67.8	1.95e-11	NR	MDR3709200.1	2953755	g54861	i0	58	0.903614457831325	50	21	90.4	0	16	165	285	334	MDR3709200.1 glycosyltransferase [Capsulimonadaceae bacterium]	diamond	150	67.8	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae		Capsulimonadaceae bacterium
32682998	32682998	PRJNA1137393_P_NODE_33620_length_176_cov_1.543307_g33104_i0	PRJNA1137393	33620	176	1.543307	2.71622032	Bacteria	2	Bacteria	Bacteria	88.6	1.07e-18	NR	MBC8101046.1	2033014	g33104	i0	75	2.89772727272727	56	14	95.5	0	176	9	103	158	MBC8101046.1 glycoside hydrolase family 92 protein [Armatimonadota bacterium]	diamond	510	89	0.995505617977528	Bacteria	Bacillati	Armatimonadota					Armatimonadota 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);;