metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA640143" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA640143" 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
1155466	1155466	PRJNA640143_S_NODE_23781_length_181_cov_1.354167_g23571_i0	PRJNA640143	23781	181	1.354167	2.45104227	root	1	Root_unresolved	Root_unresolved	99	1.95e-16	NTclustered	gi\|2240447379\|dbj\|AP025739.1\|	2219043	g23571	i0	91.549	10.4806629834254	71	6	39	0	3	73	595994	595924	Capsulimonas corticalis AX-7 DNA, complete genome	blastn	1897	100	0.99	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Capsulimonadales	Capsulimonadaceae	Capsulimonas	Capsulimonas corticalis
2430605	2430605	PRJNA640143_S_NODE_20202_length_195_cov_12.943038_g19992_i0	PRJNA640143	20202	195	12.943038	25.2389241	Fimbriimonas	1005038	Bacteria	Bacteria	69.4	1.67e-7	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g19992	i0	95.455	59.3897435897436	44	1	22	1	1	43	29569	29612	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	11581	69.4	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
4437337	4437337	PRJNA640143_S_NODE_11024_length_260_cov_1.825112_g10814_i0	PRJNA640143	11024	260	1.825112	4.7452912	uncultured Armatimonadetes bacterium	157466	Bacteria	Bacteria	110	1.39e-19	NTclustered	gi\|2874253971\|emb\|OY970296.1\|	157466	g10814	i0	80.769	10.7115384615385	156	17	57	9	32	180	4214222	4214073	MAG: uncultured Armatimonadetes bacterium isolate MFD04408.bin.1.1 genome assembly, chromosome: 1	blastn	2785	110	1	Bacteria	Bacillati	Armatimonadota					uncultured Armatimonadetes bacterium
8262983	8262983	PRJNA640143_S_NODE_15907_length_219_cov_1.565934_g15697_i0	PRJNA640143	15907	219	1.565934	3.42939546	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	219	1.8099999999999993e-52	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g15697	i0	85.308	4.60730593607306	211	31	96	0	9	219	226820	226610	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	1009	219	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
15183969	15183969	PRJNA640143_S_NODE_32772_length_150_cov_1.699115_g32562_i0	PRJNA640143	32772	150	1.699115	2.5486725	Chthonomonas	1077265	Bacteria	Bacteria	91.6	2.59e-14	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g32562	i0	88.312	1.02666666666667	77	7	51	2	1	76	185	260	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	154	91.6	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
20281918	20281918	PRJNA640143_S_NODE_4976_length_368_cov_35.758308_g4766_i0	PRJNA640143	4976	368	35.758308	131.59057343999999	Fimbriimonas	1005038	Bacteria	Bacteria	296	1.46e-75	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g4766	i0	86.617	190.48097826087	269	34	73	2	67	334	29518	29785	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	70097	296	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);;