metadata: contig_metadata: 15 rows where bioproject = "PRJNA1041773", tax_kingdom = "Bacillati" and tax

15 rows where bioproject = "PRJNA1041773", 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_species
28077412	28077412	PRJNA1041773_P_NODE_39945_length_335_cov_1.465649_g39612_i0	PRJNA1041773	39945	335	1.465649	4.90992415	Armatimonadia bacterium	2663015	Bacteria	Bacteria	167	2.7499999999999996e-47	NR	MEN6302931.1	2663015	g39612	i0	73.9	0.994029850746269	111	29	99.4	0	1	333	131	241	MEN6302931.1 S49 family peptidase [Armatimonadia bacterium]	diamond	333	167	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
28172173	28172173	PRJNA1041773_P_NODE_55126_length_289_cov_3.208333_g54793_i0	PRJNA1041773	55126	289	3.208333	9.27208237	Armatimonadia bacterium	2663015	Bacteria	Bacteria	139	1.44e-36	NR	MEN6302621.1	2663015	g54793	i0	80	0.882352941176471	85	17	88.2	0	5	259	390	474	MEN6302621.1 DNA polymerase A family protein [Armatimonadia bacterium]	diamond	255	139	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
28330009	28330009	PRJNA1041773_P_NODE_22286_length_440_cov_1.945504_g21956_i0	PRJNA1041773	22286	440	1.945504	8.5602176	Armatimonadia bacterium	2663015	Bacteria	Bacteria	113	3.2900000000000004e-27	NR	MEN6302747.1	2663015	g21956	i0	78.3	0.470454545454545	69	15	47	0	439	233	252	320	MEN6302747.1 SNF2-related protein [Armatimonadia bacterium]	diamond	207	113	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
28456546	28456546	PRJNA1041773_P_NODE_106226_length_218_cov_4.137931_g105893_i0	PRJNA1041773	106226	218	4.137931	9.02068958	Armatimonadia bacterium	2663015	Bacteria	Bacteria	106	3.96e-25	NR	MEN6304865.1	2663015	g105893	i0	76.4	0.990825688073395	72	17	99.1	0	216	1	166	237	MEN6304865.1 phage tail tube protein [Armatimonadia bacterium]	diamond	216	106	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
29088029	29088029	PRJNA1041773_P_NODE_104928_length_229_cov_2.269231_g104595_i0	PRJNA1041773	104928	229	2.269231	5.19653899	Armatimonadia bacterium	2663015	Bacteria	Bacteria	54.3	2.58e-6	NR	MEN6302931.1	2663015	g104595	i0	68.4	0.497816593886463	38	12	49.8	0	114	1	1	38	MEN6302931.1 S49 family peptidase [Armatimonadia bacterium]	diamond	114	54.3	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
29655799	29655799	PRJNA1041773_P_NODE_103630_length_234_cov_2.161491_g103297_i0	PRJNA1041773	103630	234	2.161491	5.05788894	Armatimonadia bacterium	2663015	Bacteria	Bacteria	129	2.65e-33	NR	MEN6302621.1	2663015	g103297	i0	79.2	0.987179487179487	77	16	98.7	0	232	2	193	269	MEN6302621.1 DNA polymerase A family protein [Armatimonadia bacterium]	diamond	231	129	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
30066756	30066756	PRJNA1041773_P_NODE_94812_length_244_cov_0.859649_g94479_i0	PRJNA1041773	94812	244	0.859649	2.09754356	Armatimonadia bacterium	2663015	Bacteria	Bacteria	112	6.810000000000001e-27	NR	MEN6302932.1	2663015	g94479	i0	77.3	0.922131147540984	75	17	92.2	0	18	242	411	485	MEN6302932.1 hypothetical protein [Armatimonadia bacterium]	diamond	225	112	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
30193086	30193086	PRJNA1041773_P_NODE_36892_length_347_cov_1.744526_g36559_i0	PRJNA1041773	36892	347	1.744526	6.05350522	Armatimonadia bacterium	2663015	Bacteria	Bacteria	60.1	1e-7	NR	MEN6305216.1	2663015	g36559	i0	41.2	0.985590778097983	114	64	96	3	337	5	68	181	MEN6305216.1 hypothetical protein [Armatimonadia bacterium]	diamond	342	60.1	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
30856643	30856643	PRJNA1041773_P_NODE_22154_length_441_cov_2.864130_g21824_i0	PRJNA1041773	22154	441	2.86413	12.6308133	Armatimonadia bacterium	2663015	Bacteria	Bacteria	195	9.99e-58	NR	MEN6304240.1	2663015	g21824	i0	68.5	0.993197278911565	146	46	99.3	0	2	439	42	187	MEN6304240.1 hypothetical protein [Armatimonadia bacterium]	diamond	438	195	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
31014664	31014664	PRJNA1041773_P_NODE_60215_length_279_cov_1.951456_g59882_i0	PRJNA1041773	60215	279	1.951456	5.44456224	Armatimonadia bacterium	2663015	Bacteria	Bacteria	111	1.37e-27	NR	MEN6304868.1	2663015	g59882	i0	80	0.698924731182796	65	13	69.9	0	199	5	1	65	MEN6304868.1 hypothetical protein [Armatimonadia bacterium]	diamond	195	111	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
31615417	31615417	PRJNA1041773_P_NODE_28096_length_393_cov_2.584375_g27765_i0	PRJNA1041773	28096	393	2.584375	10.15659375	Armatimonadia bacterium	2663015	Bacteria	Bacteria	126	5.6199999999999996e-34	NR	MEN6302622.1	2663015	g27765	i0	65.9	0.694656488549618	91	31	69.5	0	8	280	75	165	MEN6302622.1 hypothetical protein [Armatimonadia bacterium]	diamond	273	126	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
31836642	31836642	PRJNA1041773_P_NODE_55677_length_288_cov_2.148837_g55344_i0	PRJNA1041773	55677	288	2.148837	6.18865056	Armatimonadia bacterium	2663015	Bacteria	Bacteria	148	5.05e-40	NR	MEN6302932.1	2663015	g55344	i0	74.7	0.989583333333333	95	24	99	0	287	3	267	361	MEN6302932.1 hypothetical protein [Armatimonadia bacterium]	diamond	285	148	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
32343359	32343359	PRJNA1041773_P_NODE_9639_length_662_cov_2.779287_g9315_i0	PRJNA1041773	9639	662	2.779287	18.39887994	Armatimonadia bacterium	2663015	Bacteria	Bacteria	269	4.12e-80	NR	MEN6403862.1	2663015	g9315	i0	68.6	0.996978851963746	220	69	99.7	0	662	3	183	402	MEN6403862.1 phage tail tape measure protein [Armatimonadia bacterium]	diamond	660	269	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
32374861	32374861	PRJNA1041773_P_NODE_31839_length_371_cov_1.812081_g31507_i0	PRJNA1041773	31839	371	1.812081	6.72282051	Armatimonadia bacterium	2663015	Bacteria	Bacteria	56.2	5.47e-7	NR	MEN6302181.1	2663015	g31507	i0	52	0.404312668463612	50	20	37.2	1	133	270	98	147	MEN6302181.1 hypothetical protein [Armatimonadia bacterium]	diamond	150	56.2	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia bacterium
32658745	32658745	PRJNA1041773_P_NODE_95260_length_243_cov_1.564706_g94927_i0	PRJNA1041773	95260	243	1.564706	3.80223558	Armatimonadia bacterium	2663015	Bacteria	Bacteria	93.6	2.44e-22	NR	MEN6304866.1	2663015	g94927	i0	59.4	0.851851851851852	69	28	85.2	0	242	36	66	134	MEN6304866.1 phage tail terminator-like protein [Armatimonadia bacterium]	diamond	207	93.6	1	Bacteria	Bacillati	Armatimonadota	Armatimonadia	Armatimonadia 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);;