metadata: contig_metadata: 16 rows where bioproject = "PRJNA379145" and tax

16 rows where bioproject = "PRJNA379145" 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
2349336	2349336	PRJNA379145_P_NODE_36082_length_340_cov_2.110749_g33934_i0	PRJNA379145	36082	340	2.110749	7.1765466	Chthonomonas	1077265	Bacteria	Bacteria	135	3.1e-27	NTclustered	gi\|526641997\|ref\|NR_103994.1\|	454171	g33934	i0	74.652	45.1529411764706	359	66	100	18	1	340	1667	1315	Chthonomonas calidirosea strain T49 23S ribosomal RNA gene, complete sequence	blastn	15352	135	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae	Chthonomonas	Chthonomonas calidirosea
2349394	2349394	PRJNA379145_P_NODE_72162_length_154_cov_1.983471_g70007_i0	PRJNA379145	72162	154	1.983471	3.05454534	Fimbriimonas	1005038	Bacteria	Bacteria	231	1.5099999999999998e-56	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g70007	i0	94.156	145.655844155844	154	5	99	4	3	154	26940	27091	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	22431	231	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
7451967	7451967	PRJNA379145_P_NODE_44746_length_266_cov_1.171674_g42594_i0	PRJNA379145	44746	266	1.171674	3.11665284	Fimbriimonas	1005038	Bacteria	Bacteria	320	6.04e-83	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g42594	i0	88.433	7.54887218045113	268	27	100	4	1	266	29147	28882	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	2008	320	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
8054252	8054252	PRJNA379145_P_NODE_53587_length_215_cov_1.615385_g51433_i0	PRJNA379145	53587	215	1.615385	3.47307775	Bacteria	2	Bacteria	Bacteria	115	8.83e-28	NR	MDE2125976.1	2033014	g51433	i0	78.9	25.7720930232558	71	15	99.1	0	2	214	682	752	MDE2125976.1 methionine synthase [Armatimonadota bacterium]	diamond	5541	116	0.991379310344828	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
8726742	8726742	PRJNA379145_P_NODE_59067_length_192_cov_1.836478_g56913_i0	PRJNA379145	59067	192	1.836478	3.52603776	Fimbriimonas	1005038	Bacteria	Bacteria	237	4.25e-58	NTclustered	gi\|663071213\|gb\|CP007139.1\|	661478	g56913	i0	89.119	31.21875	193	18	100	3	1	192	28775	28585	Fimbriimonas ginsengisoli Gsoil 348, complete genome	blastn	5994	237	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia	Fimbriimonadales	Fimbriimonadaceae	Fimbriimonas	Fimbriimonas ginsengisoli
15703230	15703230	PRJNA379145_P_NODE_11193_length_891_cov_21.381119_g9918_i0	PRJNA379145	11193	891	21.381119	190.50577029	Fimbriimonadia bacterium	2575566	Bacteria	Bacteria	401	4.409999999999999e-138	NR	MCW5933900.1	2575566	g9918	i0	69.6	4.75420875420875	273	83	91.9	0	25	843	16	288	MCW5933900.1 inositol oxygenase [Fimbriimonadia bacterium]	diamond	4236	401	1	Bacteria	Bacillati	Armatimonadota	Fimbriimonadia				Fimbriimonadia bacterium
26694993	26694993	PRJNA379145_P_NODE_37581_length_325_cov_2.027397_g35430_i0	PRJNA379145	37581	325	2.027397	6.58904025	Armatimonadota bacterium	2033014	Bacteria	Bacteria	59.3	7.59e-9	NR	MBW3622636.1	2033014	g35430	i0	51.7	0.553846153846154	60	26	52.6	1	311	141	39	98	MBW3622636.1 Dabb family protein [Armatimonadota bacterium]	diamond	180	59.3	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
27422872	27422872	PRJNA379145_P_NODE_61883_length_182_cov_1.932886_g59729_i0	PRJNA379145	61883	182	1.932886	3.51785252	Armatimonadetes bacterium Cent15-Ar3	1987502	Bacteria	Bacteria	76.3	2.53e-14	NR	OWU64690.1	1987502	g59729	i0	63.8	1.71428571428571	47	17	77.5	0	143	3	100	146	OWU64690.1 MAG: hypothetical protein CBB60_008535, partial [Armatimonadetes bacterium Cent15-Ar3]	diamond	312	76.3	1	Bacteria	Bacillati	Armatimonadota					Armatimonadetes bacterium Cent15-Ar3
27738643	27738643	PRJNA379145_P_NODE_1444_length_2121_cov_4.035441_g1160_i1	PRJNA379145	1444	2121	4.035441	85.59170361	Armatimonadota bacterium	2033014	Bacteria	Bacteria	139	6.04e-34	NR	MDT7897246.1	2033014	g1160	i1	46.5	1.48939179632249	170	87	23.5	2	1243	1740	16	185	MDT7897246.1 macro domain-containing protein [Armatimonadota bacterium]	diamond	3159	139	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
28496326	28496326	PRJNA379145_P_NODE_9887_length_959_cov_2.610151_g8745_i0	PRJNA379145	9887	959	2.610151	25.03134809	Armatimonadota bacterium	2033014	Bacteria	Bacteria	75.9	2.33e-11	NR	MBI2300851.1	2033014	g8745	i0	37.4	0.384775808133472	123	66	37.2	3	573	929	224	339	MBI2300851.1 hypothetical protein [Armatimonadota bacterium]	diamond	369	75.9	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
29965730	29965730	PRJNA379145_P_NODE_6551_length_1188_cov_10.316883_g5140_i1	PRJNA379145	6551	1188	10.316883	122.56457004	Bacillati	1783272	Bacteria	Bacteria	214	2.72e-61	NR	HLK61165.1	2739509	g5140	i1	48.9	3.79545454545455	235	110	56.8	1	149	823	3	237	HLK61165.1 PAS domain-containing protein [Chthonomonadaceae bacterium]	diamond	4509	214	1	Bacteria	Bacillati	Armatimonadota	Chthonomonadia	Chthonomonadales	Chthonomonadaceae		Chthonomonadaceae bacterium
30137718	30137718	PRJNA379145_P_NODE_1372_length_2153_cov_4.000000_g1160_i0	PRJNA379145	1372	2153	4	86.12	Armatimonadota bacterium	2033014	Bacteria	Bacteria	139	6.33e-34	NR	MDT7897246.1	2033014	g1160	i0	46.5	1.46725499303298	170	87	23.1	2	1275	1772	16	185	MDT7897246.1 macro domain-containing protein [Armatimonadota bacterium]	diamond	3159	139	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30218329	30218329	PRJNA379145_P_NODE_46492_length_254_cov_2.361991_g44339_i0	PRJNA379145	46492	254	2.361991	5.99945714	Bacteria	2	Bacteria	Bacteria	44.3	0.0125	NR	HAZ64518.1	2033014	g44339	i0	51.9	1.38188976377953	52	18	59.1	2	25	174	8	54	HAZ64518.1 hypothetical protein [Armatimonadota bacterium]	diamond	351	44.3	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30485690	30485690	PRJNA379145_P_NODE_1593_length_2050_cov_5.250372_g1353_i0	PRJNA379145	1593	2050	5.250372	107.632626	Armatimonadota bacterium	2033014	Bacteria	Bacteria	607	5.599999999999998e-209	NR	MBM3474493.1	2033014	g1353	i0	55.5	7.45024390243902	564	228	82.1	9	242	1924	1	544	MBM3474493.1 hydroxylamine reductase [Armatimonadota bacterium]	diamond	15273	607	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
30485692	30485692	PRJNA379145_P_NODE_16333_length_692_cov_2.106222_g14644_i0	PRJNA379145	16333	692	2.106222	14.57505624	Armatimonadota bacterium	2033014	Bacteria	Bacteria	306	1.27e-98	NR	MBC8100959.1	2033014	g14644	i0	69.5	10.9552023121387	210	64	91	0	690	61	288	497	MBC8100959.1 phytoene desaturase [Armatimonadota bacterium]	diamond	7581	306	1	Bacteria	Bacillati	Armatimonadota					Armatimonadota bacterium
32098067	32098067	PRJNA379145_P_NODE_50098_length_233_cov_1.585000_g47944_i0	PRJNA379145	50098	233	1.585	3.69305	Armatimonadota bacterium	2033014	Bacteria	Bacteria	45.8	0.00262	NR	NPV47813.1	2033014	g47944	i0	61.1	0.463519313304721	36	14	46.4	0	222	115	373	408	NPV47813.1 sulfatase [Armatimonadota bacterium]	diamond	108	45.8	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);;