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

5 rows where analysis = "blastn", bioproject = "PRJNA615351" 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
3146501	3146501	PRJNA615351_P_NODE_183003_length_153_cov_2.076271_g168903_i0	PRJNA615351	183003	153	2.076271	3.17669463	Capsulimonas corticalis	2219043	Bacteria	Bacteria	106	9.49e-19	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g168903	i0	79.739	6.45751633986928	153	26	99	5	3	153	592646	592795	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	988	106	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
12074872	12074872	PRJNA615351_P_NODE_139750_length_207_cov_1.075581_g125650_i0	PRJNA615351	139750	207	1.075581	2.22645267	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	193	1.02e-44	NTclustered	gi\|1938770100\|gb\|CP054189.1\|	2739509	g125650	i0	84.158	8.67632850241546	202	28	97	4	1	200	126441	126640	MAG: Chthonomonadaceae bacterium isolate H1_ARM1 chromosome, complete genome	blastn	1796	193	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
17727812	17727812	PRJNA615351_P_NODE_154194_length_184_cov_1.610738_g140094_i0	PRJNA615351	154194	184	1.610738	2.96375792	Fimbriimonas	1005038	Bacteria	Bacteria	291	3.05e-74	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g140094	i0	95.58	129.179347826087	181	8	98	0	1	181	28577	28757	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	23769	291	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
18447555	18447555	PRJNA615351_P_NODE_128575_length_229_cov_1.654639_g114475_i0	PRJNA615351	128575	229	1.654639	3.78912331	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	390	3.81e-104	NTclustered	gi\|396083852\|gb\|JX114367.1\|	157466	g114475	i0	97.38	95.9825327510917	229	6	100	0	1	229	6	234	Uncultured Armatimonadetes bacterium clone SNNP_2012-34 16S ribosomal RNA gene, partial sequence	blastn	21980	390	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
20276367	20276367	PRJNA615351_P_NODE_138496_length_209_cov_1.580460_g124396_i0	PRJNA615351	138496	209	1.58046	3.3031614	Fimbriimonas	1005038	Bacteria	Bacteria	237	4.71e-58	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g124396	i0	87.204	56.5741626794258	211	24	100	3	1	209	29007	29216	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	11824	237	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);;