metadata: contig_metadata: 8 rows where bioproject = "PRJNA666695", tax_kingdom = "Bacillati" and tax

8 rows where bioproject = "PRJNA666695", tax_kingdom = "Bacillati" 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_species
14661507	14661507	PRJNA666695_S_NODE_48512_length_297_cov_2.824219_g47418_i0	PRJNA666695	48512	297	2.824219	8.38793043	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	122	2.02e-31	NR	MCW5942167.1	2682144	g47418	i0	67.5	6.44444444444444	83	27	83.8	0	296	48	231	313	MCW5942167.1 thioredoxin-disulfide reductase [Fimbriimonadaceae bacterium]	diamond	1914	122	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonadaceae bacterium
27808292	27808292	PRJNA666695_S_NODE_33624_length_341_cov_20.376667_g32530_i0	PRJNA666695	33624	341	20.376667	69.48443447	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	51.2	1.63e-5	NR	MFM9874541.1	2682144	g32530	i0	36.5	0.651026392961877	74	47	65.1	0	9	230	35	108	MFM9874541.1 hypothetical protein [Fimbriimonadaceae bacterium]	diamond	222	51.2	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonadaceae bacterium
28009782	28009782	PRJNA666695_S_NODE_56745_length_279_cov_3.676471_g55651_i0	PRJNA666695	56745	279	3.676471	10.25735409	Bacteria	2	Bacteria	Bacteria	53.5	9.28e-6	NR	HEY3397520.1	2033014	g55651	i0	32.9	2.60215053763441	79	52	83.9	1	272	39	1142	1220	HEY3397520.1 LamG-like jellyroll fold domain-containing protein [Armatimonadota bacterium]	diamond	726	53.9	0.992578849721707	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
29860322	29860322	PRJNA666695_S_NODE_140351_length_184_cov_3.216783_g139257_i0	PRJNA666695	140351	184	3.216783	5.91888072	Armatimonadota bacterium	2033014	Bacteria	Bacteria	68.9	9.89e-12	NR	MCS7223123.1	2033014	g139257	i0	48.3	1.95652173913043	60	31	97.8	0	5	184	846	905	MCS7223123.1 DUF5703 domain-containing protein [Armatimonadota bacterium]	diamond	360	68.9	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
30650038	30650038	PRJNA666695_S_NODE_39893_length_320_cov_4.121864_g38799_i0	PRJNA666695	39893	320	4.121864	13.1899648	Fimbriimonadaceae bacterium	2682144	Bacteria	Bacteria	62.4	1.08e-8	NR	MCW5936212.1	2682144	g38799	i0	35.6	4.5	101	64	93.8	1	319	20	311	411	MCW5936212.1 aspartate aminotransferase family protein [Fimbriimonadaceae bacterium]	diamond	1440	62.4	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonadaceae bacterium
32168185	32168185	PRJNA666695_S_NODE_183778_length_156_cov_3.721739_g182684_i0	PRJNA666695	183778	156	3.721739	5.80591284	Armatimonadota bacterium	2033014	Bacteria	Bacteria	67.4	1.75e-11	NR	NQV17944.1	2033014	g182684	i0	66	1.01923076923077	53	17	100	1	1	156	248	300	NQV17944.1 ornithine cyclodeaminase [Armatimonadota bacterium]	diamond	159	67.4	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
32389494	32389494	PRJNA666695_S_NODE_95119_length_225_cov_1.750000_g94025_i0	PRJNA666695	95119	225	1.75	3.9375	Armatimonadota bacterium	2033014	Bacteria	Bacteria	43.1	0.0216	NR	MER3475155.1	2033014	g94025	i0	45.3	0.853333333333333	64	33	82.7	1	194	9	63	126	MER3475155.1 endonuclease MutS2 [Armatimonadota bacterium]	diamond	192	43.1	1	Bacteria	Bacillati	Armatimonadota				Armatimonadota bacterium
32622701	32622701	PRJNA666695_S_NODE_99140_length_220_cov_5.078212_g98046_i0	PRJNA666695	99140	220	5.078212	11.1720664	Bacillati	1783272	Bacteria	Bacteria	48.9	1.9e-4	NR	MEN6358181.1	2033014	g98046	i0	44.8	2.68636363636364	58	31	79.1	1	219	46	634	690	MEN6358181.1 S8 family serine peptidase [Armatimonadota bacterium]	diamond	591	49.3	0.991886409736308	Bacteria	Bacillati	Armatimonadota				Armatimonadota 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);;