metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA395690" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA395690" 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
5515177	5515177	PRJNA395690_P_NODE_11125_length_244_cov_1.446154_g10973_i0	PRJNA395690	11125	244	1.446154	3.52861576	Capsulimonas corticalis	2219043	Bacteria	Bacteria	254	5.62e-63	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g10973	i0	86.695	538.368852459016	233	25	94	6	15	244	592666	592895	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	131362	254	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
7456848	7456848	PRJNA395690_P_NODE_14106_length_217_cov_0.910714_g13954_i0	PRJNA395690	14106	217	0.910714	1.97624938	Bacteria	2	Bacteria	Bacteria	198	2.3299999999999997e-46	NTclustered	gi\|1199098093\|gb\|CP021423.1\|	2004467	g13954	i0	84.36	29.7373271889401	211	24	95	6	1	206	1550684	1550890	Armatimonadetes bacterium Uphvl-Ar1 genome	blastn	6453	198	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Uphvl-Ar1
10615747	10615747	PRJNA395690_P_NODE_8009_length_285_cov_3.788136_g7857_i0	PRJNA395690	8009	285	3.788136	10.7961876	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	279	1.11e-70	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g7857	i0	85.556	357.870175438597	270	36	94	3	19	285	1304760	1304491	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	101993	279	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
12557737	12557737	PRJNA395690_P_NODE_30830_length_165_cov_0.879310_g30678_i0	PRJNA395690	30830	165	0.87931	1.4508615	Fimbriimonas	1005038	Bacteria	Bacteria	241	2.74e-59	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g30678	i0	93.252	453.709090909091	163	11	99	0	1	163	28604	28766	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	74862	241	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
21480812	21480812	PRJNA395690_P_NODE_9537_length_263_cov_1.654206_g9385_i0	PRJNA395690	9537	263	1.654206	4.35056178	Fimbriimonas	1005038	Bacteria	Bacteria	355	1.63e-93	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g9385	i0	91.288	332.467680608365	264	18	99	4	1	262	28511	28251	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	87439	355	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli

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