metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA944406" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA944406" 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
3811442	3811442	PRJNA944406_P_NODE_30363_length_281_cov_3.456731_g29404_i0	PRJNA944406	30363	281	3.456731	9.71341411	Fimbriimonas	1005038	Bacteria	Bacteria	335	2.3e-87	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g29404	i0	90.588	328.021352313167	255	21	90	3	1	254	29770	29518	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	92174	335	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
7302757	7302757	PRJNA944406_P_NODE_55366_length_258_cov_1.654054_g54407_i0	PRJNA944406	55366	258	1.654054	4.26745932	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	104	6.39e-18	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g54407	i0	78.882	341.325581395349	161	29	61	5	101	258	1304058	1304216	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	88062	104	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
7637421	7637421	PRJNA944406_P_NODE_111526_length_235_cov_2.296296_g110567_i0	PRJNA944406	111526	235	2.296296	5.3962956	Fimbriimonas	1005038	Bacteria	Bacteria	222	1.52e-53	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g110567	i0	83.966	3.54042553191489	237	33	100	5	1	235	28315	28082	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	832	222	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
7637459	7637459	PRJNA944406_P_NODE_19466_length_298_cov_1.782222_g18507_i0	PRJNA944406	19466	298	1.782222	5.31102156	Fimbriimonas	1005038	Bacteria	Bacteria	351	2.44e-92	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g18507	i0	88.699	176.61744966443	292	28	97	5	1	290	28138	28426	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	52632	351	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
8912201	8912201	PRJNA944406_P_NODE_23527_length_288_cov_1.432558_g22568_i0	PRJNA944406	23527	288	1.432558	4.12576704	Fimbriimonas	1005038	Bacteria	Bacteria	318	2.3799999999999995e-82	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g22568	i0	87.279	245.059027777778	283	30	97	6	1	280	28464	28185	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	70577	318	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
11128087	11128087	PRJNA944406_P_NODE_33569_length_278_cov_2.370732_g32610_i0	PRJNA944406	33569	278	2.370732	6.59063496	Capsulimonas corticalis	2219043	Bacteria	Bacteria	185	2.4199999999999998e-42	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g32610	i0	81.818	2.35251798561151	220	40	79	0	35	254	594299	594080	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	654	185	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
12738860	12738860	PRJNA944406_P_NODE_4710_length_603_cov_2.530189_g3777_i0	PRJNA944406	4710	603	2.530189	15.25703967	Chthonomonas	1077265	Bacteria	Bacteria	529	2.2599999999999993e-145	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g3777	i0	84.229	59.0530679933665	558	72	91	14	54	602	1280	1830	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	35609	529	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
13678711	13678711	PRJNA944406_P_NODE_8591_length_425_cov_3.181818_g7634_i0	PRJNA944406	8591	425	3.181818	13.5227265	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	202	3.839999999999999e-47	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g7634	i0	79.863	46.8823529411765	293	46	67	12	128	411	3914811	3915099	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	19925	202	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
14013450	14013450	PRJNA944406_P_NODE_5251_length_566_cov_1.985801_g4308_i0	PRJNA944406	5251	566	1.985801	11.23963366	Bacteria	2	Bacteria	Bacteria	303	1.4e-77	NTclustered	gi\|2874253701\|emb\|OY969427.1\|	157466	g4308	i0	76.936	233.173144876325	581	105	100	22	1	566	3409103	3409669	MAG: uncultured Armatimonadetes bacterium isolate MFD09671.bin.1.19 genome assembly, chromosome: 1	blastn	131976	303	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
15287369	15287369	PRJNA944406_P_NODE_41972_length_271_cov_1.040404_g41013_i0	PRJNA944406	41972	271	1.040404	2.81949484	Fimbriimonas	1005038	Bacteria	Bacteria	331	2.8500000000000002e-86	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g41013	i0	88.686	10.0553505535055	274	27	100	4	1	271	27957	28229	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	2725	331	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
17836722	17836722	PRJNA944406_P_NODE_12554_length_356_cov_4.932862_g11595_i0	PRJNA944406	12554	356	4.932862	17.56098872	Fimbriimonas	1005038	Bacteria	Bacteria	357	6.38e-94	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g11595	i0	84.874	9.44943820224719	357	51	100	3	1	356	28346	27992	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	3364	357	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
18776742	18776742	PRJNA944406_P_NODE_79875_length_247_cov_2.333333_g78916_i0	PRJNA944406	79875	247	2.333333	5.76333251	Capsulimonas corticalis	2219043	Bacteria	Bacteria	250	7.38e-62	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g78916	i0	85.477	80.4898785425101	241	33	97	2	6	245	594059	593820	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	19881	250	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
20051273	20051273	PRJNA944406_P_NODE_5116_length_575_cov_2.137450_g4175_i0	PRJNA944406	5116	575	2.13745	12.2903375	Capsulimonas corticalis	2219043	Bacteria	Bacteria	472	3.68e-128	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g4175	i0	83.302	339.189565217391	533	68	91	19	53	575	594864	594343	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	195034	472	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
22601277	22601277	PRJNA944406_P_NODE_12558_length_356_cov_3.035336_g11599_i0	PRJNA944406	12558	356	3.035336	10.80579616	Armatimonadetes bacterium Uphvl-Ar2	2004468	Bacteria	Bacteria	520	7.679999999999998e-143	NTclustered	gi\|1199101103\|gb\|CP021424.1\|	2004468	g11599	i0	93.017	186.030898876405	358	21	100	4	1	356	2201670	2202025	Armatimonadetes bacterium Uphvl-Ar2 genome	blastn	66227	520	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar2
22937081	22937081	PRJNA944406_P_NODE_112938_length_227_cov_2.480519_g111979_i0	PRJNA944406	112938	227	2.480519	5.63077813	Fimbriimonas	1005038	Bacteria	Bacteria	364	2.289999999999999e-96	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g111979	i0	95.595	118.898678414097	227	10	100	0	1	227	27129	26903	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	26990	364	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
23876804	23876804	PRJNA944406_P_NODE_16439_length_319_cov_0.902439_g15480_i0	PRJNA944406	16439	319	0.902439	2.87878041	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	189	2.1799999999999998e-43	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g15480	i0	88.608	3.09404388714734	158	14	49	3	164	319	1305365	1305210	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	987	189	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
23877665	23877665	PRJNA944406_P_NODE_8819_length_419_cov_5.026012_g7862_i0	PRJNA944406	8819	419	5.026012	21.05899028	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	313	1.68e-80	NTclustered	gi\|2076452338\|gb\|CP075364.1\|	2682144	g7862	i0	80.896	108.126491646778	424	58	100	12	1	419	669184	668779	MAG: Fimbriimonadaceae bacterium isolate ACE_ARM1 chromosome	blastn	45305	313	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae		Fimbriimonadaceae bacterium
25150363	25150363	PRJNA944406_P_NODE_10820_length_379_cov_2.009804_g9861_i0	PRJNA944406	10820	379	2.009804	7.61715716	Capsulimonas corticalis	2219043	Bacteria	Bacteria	324	6.93e-84	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g9861	i0	83.815	160.802110817942	346	50	91	6	36	379	593402	593061	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	60944	324	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis

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);;