metadata: contig_metadata: 14 rows where bioproject = "PRJNA1146029" and tax

14 rows where bioproject = "PRJNA1146029" 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
11768946	11768946	PRJNA1146029_P_NODE_910_length_938_cov_3.536416_g706_i0	PRJNA1146029	910	938	3.536416	33.17158208	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	1027	0	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g706	i0	86.723	114.970149253731	949	97	100	21	1	938	2075695	2076625	Gemmatimonas phototrophica strain AP64, complete genome	blastn	107842	1027	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
16867074	16867074	PRJNA1146029_P_NODE_1074_length_865_cov_3.351010_g851_i0	PRJNA1146029	1074	865	3.35101	28.9862365	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	1059	0	NTclustered	gi\|2874253755\|emb\|OY969695.1\|	412054	g851	i0	88.953	505.225433526012	869	81	99	13	1	860	343727	342865	MAG: uncultured Gemmatimonadales bacterium isolate MFD04967.bin.1.34 genome assembly, chromosome: 1	blastn	437020	1059	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
19416276	19416276	PRJNA1146029_P_NODE_4876_length_392_cov_1.811912_g4598_i0	PRJNA1146029	4876	392	1.811912	7.10269504	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	324	7.19e-84	NTclustered	gi\|2874254107\|emb\|OY970192.1\|	412054	g4598	i0	85.669	202.020408163265	314	37	79	8	29	337	2605401	2605711	MAG: uncultured Gemmatimonadales bacterium isolate MFD01721.bin.c.5 genome assembly, chromosome: 1	blastn	79192	324	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
26943924	26943924	PRJNA1146029_P_NODE_19642_length_245_cov_0.895349_g19361_i0	PRJNA1146029	19642	245	0.895349	2.19360505	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	64.7	6.99e-10	NR	MYB59700.1	2026742	g19361	i0	50	1.50612244897959	56	28	68.6	0	193	26	104	159	MYB59700.1 hypothetical protein [Gemmatimonadota bacterium]	diamond	369	64.7	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27312567	27312567	PRJNA1146029_P_NODE_6723_length_342_cov_1.420074_g6445_i0	PRJNA1146029	6723	342	1.420074	4.85665308	FCB group	1783270	Bacteria	Bacteria	55.8	2.19e-7	NR	MBW3553895.1	2026742	g6445	i0	70.3	1.55263157894737	37	11	32.5	0	113	3	1	37	MBW3553895.1 YciI family protein [Gemmatimonadota bacterium]	diamond	531	55.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota					Gemmatimonadota bacterium
27671020	27671020	PRJNA1146029_P_NODE_21044_length_243_cov_0.905882_g20763_i0	PRJNA1146029	21044	243	0.905882	2.20129326	Longimicrobiaceae bacterium	3047548	Bacteria	Bacteria	70.9	4.56e-12	NR	HET8654550.1	3047548	g20763	i0	45.2	5.06172839506173	84	41	97.5	2	241	5	541	624	HET8654550.1 PAS domain S-box protein [Longimicrobiaceae bacterium]	diamond	1230	70.9	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae		Longimicrobiaceae bacterium
28965523	28965523	PRJNA1146029_P_NODE_21548_length_242_cov_0.911243_g21267_i0	PRJNA1146029	21548	242	0.911243	2.20520806	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	110	1.7e-26	NR	HKH92334.1	2026741	g21267	i0	63.8	1.98347107438017	80	29	99.2	0	242	3	302	381	HKH92334.1 FkbM family methyltransferase [Gemmatimonadaceae bacterium]	diamond	480	110	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
29722852	29722852	PRJNA1146029_P_NODE_9110_length_301_cov_1.877193_g8829_i0	PRJNA1146029	9110	301	1.877193	5.65035093	Longimicrobiales bacterium	2910168	Bacteria	Bacteria	52.8	1.95e-5	NR	HEX9108450.1	2910168	g8829	i0	41.7	1.78405315614618	96	42	95.7	3	289	2	5	86	HEX9108450.1 hypothetical protein [Longimicrobiales bacterium]	diamond	537	52.8	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales			Longimicrobiales bacterium
30102007	30102007	PRJNA1146029_P_NODE_12132_length_277_cov_1.504902_g11851_i0	PRJNA1146029	12132	277	1.504902	4.16857854	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	86.3	2.83e-17	NR	HTS89589.1	2448054	g11851	i0	54.7	2.29602888086643	75	34	81.2	0	276	52	167	241	HTS89589.1 hypothetical protein [Gemmatimonadales bacterium]	diamond	636	86.3	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
30481366	30481366	PRJNA1146029_P_NODE_22573_length_228_cov_2.464516_g22291_i0	PRJNA1146029	22573	228	2.464516	5.61909648	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	73.6	3.84e-13	NR	MBC7788861.1	2026741	g22291	i0	52	2.96052631578947	75	35	97.4	1	3	224	14	88	MBC7788861.1 MASE1 domain-containing protein [Gemmatimonadaceae bacterium]	diamond	675	73.6	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30955474	30955474	PRJNA1146029_P_NODE_8654_length_309_cov_1.724576_g8373_i0	PRJNA1146029	8654	309	1.724576	5.32893984	Gemmatimonadaceae bacterium	2026741	Bacteria	Bacteria	115	2.32e-27	NR	HEX5409501.1	2026741	g8373	i0	56.6	2.93203883495146	99	40	93.2	2	301	14	571	669	HEX5409501.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	906	115	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
32157165	32157165	PRJNA1146029_P_NODE_15318_length_255_cov_1.642857_g15037_i0	PRJNA1146029	15318	255	1.642857	4.18928535	Longimicrobium sp.	2029185	Bacteria	Bacteria	125	3.95e-35	NR	HEX2203269.1	2029185	g15037	i0	72.8	1.90588235294118	81	22	95.3	0	244	2	1	81	HEX2203269.1 cupredoxin domain-containing protein [Longimicrobium sp.]	diamond	486	125	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
32473605	32473605	PRJNA1146029_P_NODE_21759_length_242_cov_0.875740_g21478_i0	PRJNA1146029	21759	242	0.87574	2.1192908	Gemmatimonadales bacterium	2448054	Bacteria	Bacteria	80.5	4.37e-16	NR	HLQ58877.1	2448054	g21478	i0	52.8	0.892561983471074	72	34	89.3	0	14	229	166	237	HLQ58877.1 alpha/beta hydrolase [Gemmatimonadales bacterium]	diamond	216	80.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			Gemmatimonadales bacterium
32662588	32662588	PRJNA1146029_P_NODE_14820_length_259_cov_1.026882_g14539_i0	PRJNA1146029	14820	259	1.026882	2.65962438	Gemmatimonadota bacterium	2026742	Bacteria	Bacteria	43.1	0.0326	NR	MXX55686.1	2026742	g14539	i0	35.8	1.22779922779923	53	29	61.4	1	95	253	329	376	MXX55686.1 threonine synthase [Gemmatimonadota bacterium]	diamond	318	43.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);;