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

5 rows where analysis = "blastn", bioproject = "PRJNA734348" 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
5821939	5821939	PRJNA734348_P_NODE_47025_length_295_cov_1.270270_g46328_i0	PRJNA734348	47025	295	1.27027	3.7472965	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	121	7.4e-23	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g46328	i0	75.357	0.949152542372881	280	54	92	11	14	283	1625574	1625848	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	280	121	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
7096641	7096641	PRJNA734348_P_NODE_29286_length_359_cov_2.860140_g28591_i0	PRJNA734348	29286	359	2.86014	10.2679026	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	191	6.91e-44	NTclustered	gi\|2874253689\|emb\|OY969415.1\|	157466	g28591	i0	79.443	49.4011142061281	287	46	77	12	1	278	3915093	3914811	MAG: uncultured Armatimonadetes bacterium isolate MFD00905.bin.2.19 genome assembly, chromosome: 1	blastn	17735	191	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
17295719	17295719	PRJNA734348_P_NODE_16014_length_526_cov_2.092715_g15329_i0	PRJNA734348	16014	526	2.092715	11.0076809	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	470	1.2e-127	NTclustered	gi\|2874254000\|emb\|OY970325.1\|	157466	g15329	i0	84.024	164.524714828897	507	62	94	18	5	500	1305780	1306278	MAG: uncultured Armatimonadetes bacterium isolate MFD05942.bin.1.84 genome assembly, chromosome: 1	blastn	86540	470	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
17774636	17774636	PRJNA734348_P_NODE_12374_length_637_cov_6.051418_g11712_i0	PRJNA734348	12374	637	6.051418	38.54753266	Fimbriimonas	1005038	Bacteria	Bacteria	741	0	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g11712	i0	87.893	224.604395604396	636	69	99	7	1	630	27467	26834	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	143073	741	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
18569700	18569700	PRJNA734348_P_NODE_26435_length_379_cov_2.326797_g25740_i0	PRJNA734348	26435	379	2.326797	8.81856063	Chthonomonadaceae bacterium	2739509	Bacteria	Bacteria	276	1.9699999999999999e-69	NTclustered	gi\|1938770100\|gb\|CP054189.1\|	2739509	g25740	i0	86.667	207.701846965699	255	26	66	8	122	372	126391	126641	MAG: Chthonomonadaceae bacterium isolate H1_ARM1 chromosome, complete genome	blastn	78719	276	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae 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);;