metadata: contig_metadata: 11 rows where bioproject = "PRJNA928559" and tax

11 rows where bioproject = "PRJNA928559" 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
4733143	4733143	PRJNA928559_P_NODE_98444_length_359_cov_3.073427_g96875_i0	PRJNA928559	98444	359	3.073427	11.03360293	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	414	3.77e-111	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g96875	i0	87.569	1.63231197771588	362	40	100	5	1	359	1625519	1625878	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	586	414	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
9832403	9832403	PRJNA928559_P_NODE_89748_length_376_cov_1.029703_g88179_i0	PRJNA928559	89748	376	1.029703	3.87168328	Fimbriimonas sp.	1936159	Bacteria	Bacteria	516	1.06e-141	NTclustered	gi\|2778022393\|emb\|OZ123194.1\|	1936159	g88179	i0	91.512	163.976063829787	377	28	100	4	1	376	1688888	1688515	MAG: Fimbriimonas sp. isolate MsE-30jul19-LR-01 genome assembly, chromosome: 1	blastn	61655	516	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
12382039	12382039	PRJNA928559_P_NODE_170310_length_268_cov_1.066667_g168741_i0	PRJNA928559	170310	268	1.066667	2.85866756	Armatimonadota bacterium	2033014	Bacteria	Bacteria	230	1.0599999999999998e-55	NTclustered	gi\|2621703062\|emb\|OY760504.1\|	2033014	g168741	i0	82.528	155.014925373134	269	40	100	7	1	268	2411267	2411005	MAG: Armatimonadota bacterium isolate be0b92b7-bbec-405b-9e81-a5dbe9f1ff7a genome assembly, chromosome: 1	blastn	41544	230	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
14931231	14931231	PRJNA928559_P_NODE_197852_length_249_cov_0.886364_g196283_i0	PRJNA928559	197852	249	0.886364	2.20704636	Fimbriimonas ginsengisoli	1005039	Bacteria	Bacteria	100	2.65e-22	NR	WP_025226212.1	1005039	g196283	i0	63.1	1.01204819277108	84	29	98.8	1	246	1	79	162	WP_025226212.1 S-layer homology domain-containing protein [Fimbriimonas ginsengisoli]	diamond	252	100	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
15280645	15280645	PRJNA928559_P_NODE_131392_length_309_cov_5.610169_g129823_i0	PRJNA928559	131392	309	5.610169	17.33542221	Fimbriimonas	1005038	Bacteria	Bacteria	335	2.559999999999999e-87	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g129823	i0	87.586	151.961165048544	290	35	94	1	14	302	29491	29780	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	46956	335	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
16206465	16206465	PRJNA928559_P_NODE_209893_length_244_cov_0.912281_g208324_i0	PRJNA928559	209893	244	0.912281	2.22596564	Fimbriimonas	1005038	Bacteria	Bacteria	104	2.73e-25	NR	WP_227625014.1	1005039	g208324	i0	72.7	1.89344262295082	77	20	94.7	1	1	231	189	264	WP_227625014.1 30S ribosomal protein S2 [Fimbriimonas ginsengisoli]	diamond	462	105	0.990476190476191	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
25129702	25129702	PRJNA928559_P_NODE_216580_length_240_cov_2.491018_g215011_i0	PRJNA928559	216580	240	2.491018	5.9784432	Fimbriimonadales bacterium	2682145	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2314715370\|dbj\|AP024673.1\|	2682145	g215011	i0	94.118	0.141666666666667	34	2	14	0	6	39	2475734	2475701	MAG: Fimbriimonadales bacterium KatS3mg018 DNA, complete genome	blastn	34	52.8	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales			Fimbriimonadales bacterium
27404247	27404247	PRJNA928559_P_NODE_31823_length_582_cov_2.595285_g30293_i0	PRJNA928559	31823	582	2.595285	15.1045587	Armatimonadota bacterium	2033014	Bacteria	Bacteria	47	0.0246	NR	MEW5884319.1	2033014	g30293	i0	24.8	0.706185567010309	137	103	70.6	0	413	3	171	307	MEW5884319.1 PASTA domain-containing protein [Armatimonadota bacterium]	diamond	411	47	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27814784	27814784	PRJNA928559_P_NODE_208704_length_244_cov_1.649123_g207135_i0	PRJNA928559	208704	244	1.649123	4.02386012	Fimbriimonas sp.	1936159	Bacteria	Bacteria	48.9	2.41e-4	NR	MDR3688278.1	1936159	g207135	i0	42.6	2.49590163934426	61	34	73.8	1	241	62	212	272	MDR3688278.1 ankyrin repeat domain-containing protein [Fimbriimonas sp.]	diamond	609	48.9	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas sp.
29298512	29298512	PRJNA928559_P_NODE_144609_length_293_cov_5.954545_g143040_i0	PRJNA928559	144609	293	5.954545	17.44681685	Armatimonadota bacterium	2033014	Bacteria	Bacteria	52.8	9.55e-7	NR	MES2462974.1	2033014	g143040	i0	44.1	0.696245733788396	68	36	67.6	2	259	62	1	68	MES2462974.1 hypothetical protein [Armatimonadota bacterium]	diamond	204	52.8	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29582351	29582351	PRJNA928559_P_NODE_187170_length_253_cov_1.733333_g185601_i0	PRJNA928559	187170	253	1.733333	4.38533249	Armatimonadota bacterium	2033014	Bacteria	Bacteria	130	2.43e-33	NR	MBS1726118.1	2033014	g185601	i0	70.4	2.91699604743083	81	24	96	0	253	11	374	454	MBS1726118.1 MmgE/PrpD family protein [Armatimonadota bacterium]	diamond	738	130	1	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);;