metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB66218" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB66218" 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
132358	132358	PRJEB66218_P_NODE_208621_length_209_cov_0.878378_g206191_i0	PRJEB66218	208621	209	0.878378	1.83581002	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	176	1.04e-39	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g206191	i0	81.991	222.66985645933	211	34	100	4	1	209	1304067	1304275	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	46538	176	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
3544627	3544627	PRJEB66218_P_NODE_121183_length_273_cov_1.575472_g118754_i0	PRJEB66218	121183	273	1.575472	4.30103856	Fimbriimonas	1005038	Bacteria	Bacteria	263	1.06e-65	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g118754	i0	84.42	3.27106227106227	276	34	100	8	1	273	28285	28016	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	893	263	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
3545288	3545288	PRJEB66218_P_NODE_245483_length_194_cov_6.293233_g243051_i0	PRJEB66218	245483	194	6.293233	12.20887202	Fimbriimonas	1005038	Bacteria	Bacteria	233	5.57e-57	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g243051	i0	88.542	91.1288659793814	192	22	99	0	1	192	29580	29771	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	17679	233	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
8648341	8648341	PRJEB66218_P_NODE_86567_length_336_cov_1.236364_g84140_i0	PRJEB66218	86567	336	1.236364	4.15418304	Chthonomonas	1077265	Bacteria	Bacteria	132	3.96e-26	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g84140	i0	80.838	93.9464285714286	167	32	50	0	165	331	1447	1281	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	31566	132	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
9057941	9057941	PRJEB66218_P_NODE_115328_length_281_cov_2.190909_g112899_i0	PRJEB66218	115328	281	2.190909	6.15645429	Armatimonadetes bacterium Uphvl-Ar2	2004468	Bacteria	Bacteria	185	2.4499999999999994e-42	NTclustered	gi\|1199101103\|gb\|CP021424.1\|	2004468	g112899	i0	81.579	51.0711743772242	228	38	80	3	48	273	742400	742625	Armatimonadetes bacterium Uphvl-Ar2 genome	blastn	14351	185	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar2
15022105	15022105	PRJEB66218_P_NODE_141352_length_249_cov_4.010638_g138923_i0	PRJEB66218	141352	249	4.010638	9.98648862	Fimbriimonas	1005038	Bacteria	Bacteria	394	3.25e-105	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g138923	i0	95.181	842.775100401606	249	12	100	0	1	249	26830	27078	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	209851	394	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
15434751	15434751	PRJEB66218_P_NODE_201993_length_210_cov_0.872483_g199563_i0	PRJEB66218	201993	210	0.872483	1.8322143	Capsulimonas corticalis	2219043	Bacteria	Bacteria	82.4	2.35e-11	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g199563	i0	90.323	0.638095238095238	62	6	30	0	119	180	4625113	4625174	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	134	82.4	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
17983942	17983942	PRJEB66218_P_NODE_208375_length_209_cov_0.878378_g205945_i0	PRJEB66218	208375	209	0.878378	1.83581002	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	165	2.26e-36	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g205945	i0	81.395	259.311004784689	215	29	100	9	1	209	1304912	1304703	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	54196	165	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
18845899	18845899	PRJEB66218_P_NODE_146495_length_244_cov_2.737705_g144066_i0	PRJEB66218	146495	244	2.737705	6.6800002	Bacillati	1783272	Bacteria	Bacteria	191	4.47e-44	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g144066	i0	86.034	892.745901639344	179	24	73	1	67	244	1304127	1304305	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	217830	191	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes 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);;