metadata: contig_metadata: 15 rows where bioproject = "PRJNA1174207" and tax

15 rows where bioproject = "PRJNA1174207" 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
4142601	4142601	PRJNA1174207_P_NODE_31084_length_260_cov_1.647059_g30555_i0	PRJNA1174207	31084	260	1.647059	4.2823534	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	283	7.719999999999999e-72	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g30555	i0	86.77	1.91153846153846	257	31	99	1	1	257	2276182	2276435	Gemmatimonas phototrophica strain AP64, complete genome	blastn	497	283	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
6693846	6693846	PRJNA1174207_P_NODE_43766_length_202_cov_4.139535_g43237_i0	PRJNA1174207	43766	202	4.139535	8.3618607	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	174	3.6e-39	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g43237	i0	83.333	61.9108910891089	198	24	97	8	3	197	421056	420865	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	12506	174	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
9968671	9968671	PRJNA1174207_P_NODE_22088_length_303_cov_1.326087_g21559_i0	PRJNA1174207	22088	303	1.326087	4.01804361	Gemmatimonas	173479	Bacteria	Bacteria	477	3.9299999999999986e-130	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g21559	i0	96.842	16.1386138613861	285	9	94	0	1	285	1174	1458	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	4890	477	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
10519556	10519556	PRJNA1174207_P_NODE_43529_length_214_cov_4.780142_g43000_i0	PRJNA1174207	43529	214	4.780142	10.22950388	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	379	7.609999999999999e-101	NTclustered	gi\|2874253789\|emb\|OY969773.1\|	412054	g43000	i0	98.598	162.775700934579	214	3	100	0	1	214	421764	421977	MAG: uncultured Gemmatimonadales bacterium isolate MFD04580.bin.2.49 genome assembly, chromosome: 1	blastn	34834	379	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
11794512	11794512	PRJNA1174207_P_NODE_42470_length_234_cov_2.285714_g41941_i0	PRJNA1174207	42470	234	2.285714	5.34857076	Longimicrobium sp.	2029185	Bacteria	Bacteria	152	1.42e-43	NR	HST57198.1	2029185	g41941	i0	88.5	3	78	9	100	0	1	234	86	163	HST57198.1 nucleotidyltransferase domain-containing protein [Longimicrobium sp.]	diamond	702	152	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.
12519426	12519426	PRJNA1174207_P_NODE_41170_length_241_cov_1.630952_g40641_i0	PRJNA1174207	41170	241	1.630952	3.93059432	Gemmatimonas	173479	Bacteria	Bacteria	339	1.49e-88	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g40641	i0	92.437	69.4730290456432	238	16	99	2	3	240	1477	1712	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	16743	339	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
13069012	13069012	PRJNA1174207_P_NODE_17071_length_346_cov_1.109890_g16542_i0	PRJNA1174207	17071	346	1.10989	3.8402194	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	444	4.62e-120	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g16542	i0	89.943	911.557803468208	348	29	99	5	2	346	802756	803100	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	315399	444	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
13069430	13069430	PRJNA1174207_P_NODE_38891_length_244_cov_1.228070_g38362_i0	PRJNA1174207	38891	244	1.22807	2.9964908	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	307	4.25e-79	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g38362	i0	89.754	69.8319672131148	244	20	100	4	1	244	801156	801394	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	17039	307	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
16343336	16343336	PRJNA1174207_P_NODE_5033_length_761_cov_2.664244_g4542_i0	PRJNA1174207	5033	761	2.664244	20.27489684	Gemmatimonas	173479	Bacteria	Bacteria	1260	0	NTclustered	gi\|470475286\|ref\|NR_076270.1\|	173480	g4542	i0	96.579	253.671484888305	760	26	99	0	2	761	1142	383	Gemmatimonas aurantiaca strain T-27 23S ribosomal RNA gene, complete sequence	blastn	193044	1260	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas aurantiaca
21991962	21991962	PRJNA1174207_P_NODE_13118_length_404_cov_2.595166_g12590_i0	PRJNA1174207	13118	404	2.595166	10.48447064	Gemmatimonas phototrophica	1379270	Bacteria	Bacteria	569	8.649999999999997e-158	NTclustered	gi\|1015602748\|gb\|CP011454.1\|	1379270	g12590	i0	92.118	123.316831683168	406	28	100	4	1	404	2075164	2074761	Gemmatimonas phototrophica strain AP64, complete genome	blastn	49820	569	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas phototrophica
24541598	24541598	PRJNA1174207_P_NODE_27480_length_275_cov_1.524752_g26951_i0	PRJNA1174207	27480	275	1.524752	4.193068	uncultured Gemmatimonadales bacterium	412054	Bacteria	Bacteria	409	1.3e-109	NTclustered	gi\|2874253938\|emb\|OY970263.1\|	412054	g26951	i0	93.773	44.1818181818182	273	16	99	1	3	275	802517	802246	MAG: uncultured Gemmatimonadales bacterium isolate MFD02416.bin.2.26 genome assembly, chromosome: 1	blastn	12150	409	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales			uncultured Gemmatimonadales bacterium
27122625	27122625	PRJNA1174207_P_NODE_42142_length_237_cov_2.414634_g41613_i0	PRJNA1174207	42142	237	2.414634	5.72268258	Bacteria	2	Bacteria	Bacteria	72	1.26e-12	NR	HNV74716.1	2026741	g41613	i0	77.8	1.70886075949367	45	10	57	0	1	135	299	343	HNV74716.1 hypothetical protein [Gemmatimonadaceae bacterium]	diamond	405	72	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
28512467	28512467	PRJNA1174207_P_NODE_43567_length_212_cov_4.856115_g43038_i0	PRJNA1174207	43567	212	4.856115	10.2949638	Gemmatimonadota	142182	Bacteria	Bacteria	41.6	0.0396	NR	HEY5490311.1	2026741	g43038	i0	60	1.31603773584906	30	12	42.5	0	9	98	129	158	HEY5490311.1 hotdog fold domain-containing protein [Gemmatimonadaceae bacterium]	diamond	279	42	0.990476190476191	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae		Gemmatimonadaceae bacterium
30861984	30861984	PRJNA1174207_P_NODE_33414_length_251_cov_0.865169_g32885_i0	PRJNA1174207	33414	251	0.865169	2.17157419	Gemmatimonas sp. UBA7669	1946568	Bacteria	Bacteria	167	2.65e-47	NR	WP_291162769.1	1946568	g32885	i0	93.9	0.9800796812749	82	5	98	0	5	250	177	258	WP_291162769.1 4-alpha-glucanotransferase [Gemmatimonas sp. UBA7669]	diamond	246	167	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Gemmatimonadia	Gemmatimonadales	Gemmatimonadaceae	Gemmatimonas	Gemmatimonas sp. UBA7669
31620694	31620694	PRJNA1174207_P_NODE_24576_length_287_cov_2.794393_g24047_i0	PRJNA1174207	24576	287	2.794393	8.01990791	Longimicrobium sp.	2029185	Bacteria	Bacteria	90.5	1.17e-19	NR	HYR09228.1	2029185	g24047	i0	93.2	0.45993031358885	44	3	46	0	3	134	217	260	HYR09228.1 hypothetical protein [Longimicrobium sp.]	diamond	132	90.5	1	Bacteria	FCB group	Pseudomonadati	Gemmatimonadota	Longimicrobiia	Longimicrobiales	Longimicrobiaceae	Longimicrobium	Longimicrobium sp.

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);;