metadata: contig_metadata: 13 rows where bioproject = "PRJNA796753" and tax

13 rows where bioproject = "PRJNA796753" and tax_phylum = "Gemmatimonadota"

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_clade	tax_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
24168373	24168373	PRJNA796753_P_NODE_49539_length_244_cov_0.900585_g49227_i0	PRJNA796753	49539	244	0.900585	2.1974274	Pseudomonadati	3379134	Bacteria	Bacteria	73.6	8.39e-14	NR	MFI5209580.1	2448054	g49227	i0	50	6.66393442622951	62	31	76.2	0	243	58	145	206	MFI5209580.1 sterol desaturase family protein [Gemmatimonadales bacterium]	diamond	1626	73.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
26736905	26736905	PRJNA796753_P_NODE_31741_length_274_cov_1.532338_g31429_i0	PRJNA796753	31741	274	1.532338	4.19860612	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	62.8	3.29e-9	NR	MEO7102292.1	2026741	g31429	i0	36.5	1.87226277372263	85	54	93.1	0	256	2	191	275	MEO7102292.1 SDR family oxidoreductase [Gemmatimonadaceae bacterium]	diamond	513	62.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
27085541	27085541	PRJNA796753_P_NODE_31162_length_276_cov_1.384236_g30850_i0	PRJNA796753	31162	276	1.384236	3.82049136	Gemmatirosa sp.	2510638	Bacteria	Bacteria	100	2.5399999999999994e-23	NR	HEY0778131.1	2510638	g30850	i0	93.5	0.5	46	3	50	0	2	139	246	291	HEY0778131.1 signal peptidase I [Gemmatirosa sp.]	diamond	138	100	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatirosa	Gemmatirosa sp.
27433315	27433315	PRJNA796753_P_NODE_15983_length_359_cov_1.076923_g15671_i0	PRJNA796753	15983	359	1.076923	3.86615357	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	143	3.1899999999999997e-37	NR	NNE08319.1	2026742	g15671	i0	55.3	0.952646239554318	114	49	95.3	1	2	343	215	326	NNE08319.1 T9SS type A sorting domain-containing protein [Gemmatimonadota bacterium]	diamond	342	143	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28199787	28199787	PRJNA796753_P_NODE_25686_length_296_cov_1.726457_g25374_i0	PRJNA796753	25686	296	1.726457	5.11031272	FCB group	1783270	Bacteria	Bacteria	67	1.23e-10	NR	MCH7565339.1	2026742	g25374	i0	39.8	3.97297297297297	98	55	99.3	2	295	2	81	174	MCH7565339.1 endo alpha-1,4 polygalactosaminidase [Gemmatimonadota bacterium]	diamond	1176	67	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28547559	28547559	PRJNA796753_P_NODE_4207_length_654_cov_1.595525_g3906_i0	PRJNA796753	4207	654	1.595525	10.4347335	Bacteria	2	Bacteria	Bacteria	228	5.849999999999999e-72	NR	WP_325311220.1	2029185	g3906	i0	55	3.88073394495413	211	92	95.9	2	28	654	2	211	WP_325311220.1 NADPH-dependent F420 reductase [Longimicrobium sp.]	diamond	2538	228	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
28885378	28885378	PRJNA796753_P_NODE_15188_length_366_cov_1.576792_g14876_i0	PRJNA796753	15188	366	1.576792	5.77105872	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	88.2	1.83e-17	NR	MEJ2503434.1	2026742	g14876	i0	50	1.59836065573771	78	34	59.8	1	1	219	86	163	MEJ2503434.1 trypsin-like peptidase domain-containing protein [Gemmatimonadota bacterium]	diamond	585	88.2	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
28980416	28980416	PRJNA796753_P_NODE_28788_length_284_cov_1.445498_g28476_i0	PRJNA796753	28788	284	1.445498	4.10521432	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	92.8	1.17e-19	NR	HEU4628557.1	2026741	g28476	i0	57.3	0.940140845070423	89	38	94	0	267	1	357	445	HEU4628557.1 peptidoglycan DD-metalloendopeptidase family protein [Gemmatimonadaceae bacterium]	diamond	267	92.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30243541	30243541	PRJNA796753_P_NODE_25112_length_300_cov_0.881057_g24800_i0	PRJNA796753	25112	300	0.881057	2.643171	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	47.8	9.21e-4	NR	MBA3495578.1	2448054	g24800	i0	47.5	0.59	59	30	59	1	293	117	7	64	MBA3495578.1 ferritin-like domain-containing protein [Gemmatimonadales bacterium]	diamond	177	47.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30379317	30379317	PRJNA796753_P_NODE_41192_length_250_cov_0.870056_g40880_i0	PRJNA796753	41192	250	0.870056	2.17514	Bacteria	2	Bacteria	Bacteria	70.5	6.99e-12	NR	HEX2723548.1	2026741	g40880	i0	44.2	3.684	77	40	88.8	1	23	244	649	725	HEX2723548.1 protein kinase [Gemmatimonadaceae bacterium]	diamond	921	70.9	0.994358251057828	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31349569	31349569	PRJNA796753_P_NODE_52996_length_242_cov_0.911243_g52684_i0	PRJNA796753	52996	242	0.911243	2.20520806	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	52.8	1.09e-5	NR	HEY5415232.1	2026741	g52684	i0	37.3	1.69834710743802	75	46	91.7	1	236	15	632	706	HEY5415232.1 BTAD domain-containing putative transcriptional regulator [Gemmatimonadaceae bacterium]	diamond	411	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
31507755	31507755	PRJNA796753_P_NODE_14676_length_371_cov_1.989933_g14364_i0	PRJNA796753	14676	371	1.989933	7.38265143	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	72.4	6.19e-12	NR	MCJ7626881.1	2910168	g14364	i0	41.7	0.92991913746630706	115	58	92.2	5	368	27	390	496	MCJ7626881.1 Ig-like domain-containing protein [Longimicrobiales bacterium]	diamond	345	72.4	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
32771979	32771979	PRJNA796753_P_NODE_39660_length_251_cov_0.865169_g39348_i0	PRJNA796753	39660	251	0.865169	2.17157419	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	50.1	1.01e-4	NR	MBT5449633.1	2026742	g39348	i0	62.2	0.442231075697211	37	14	44.2	0	8	118	39	75	MBT5449633.1 SEL1-like repeat protein [Gemmatimonadota bacterium]	diamond	111	50.1	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota 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);;