metadata: contig_metadata: 11 rows where bioproject = "PRJNA493827" and tax

11 rows where bioproject = "PRJNA493827" and tax_clade = "delta/epsilon subdivisions"

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_class	tax_order	tax_family	tax_genus	tax_species
11949483	11949483	PRJNA493827_P_NODE_160630_length_270_cov_1.563452_g158432_i0	PRJNA493827	160630	270	1.563452	4.2213204	Bacteria	2	Bacteria	Bacteria	78.6	1.32e-14	NR	OGQ53114.1	1797882	g158432	i0	44.9	6.76666666666667	89	47	97.8	2	1	264	73	160	OGQ53114.1 MAG: ATP-dependent DNA helicase RecQ [Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8]	diamond	1827	78.6	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RIFCSPLOWO2_02_FULL_53_8
11951050	11951050	PRJNA493827_P_NODE_233050_length_241_cov_0.916667_g230852_i0	PRJNA493827	233050	241	0.916667	2.20916747	uncultured delta proteobacterium	34034	Bacteria	Bacteria	209	1.22e-49	NTclustered	gi\|2874253659\|emb\|OY969087.1\|	34034	g230852	i0	83.784	0.921161825726141	222	34	92	2	1	221	6129154	6129374	MAG: uncultured delta proteobacterium isolate MFD01721.bin.c.1 genome assembly, chromosome: 1	blastn	222	209	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				uncultured delta proteobacterium
18324029	18324029	PRJNA493827_P_NODE_236255_length_237_cov_2.347561_g234056_i0	PRJNA493827	236255	237	2.347561	5.56371957	Persicimonas caeni	2292766	Bacteria	Bacteria	87.9	5.83e-13	NTclustered	gi\|1695542189\|gb\|CP041186.1\|	2292766	g234056	i0	82.857	2.62025316455696	105	11	53	6	75	175	2181949	2181848	Persicimonas caeni strain YN101 chromosome	blastn	621	87.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni
18325283	18325283	PRJNA493827_P_NODE_68395_length_421_cov_1.241379_g66198_i0	PRJNA493827	68395	421	1.241379	5.22620559	Microvenator marinus	2600177	Bacteria	Bacteria	302	3.6500000000000004e-77	NTclustered	gi\|1722470586\|gb\|CP042467.1\|	2600177	g66198	i0	82.899	131.622327790974	345	50	81	8	1	340	702514	702854	Microvenator marinus strain V1718 chromosome, complete genome	blastn	55413	302	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
27834812	27834812	PRJNA493827_P_NODE_232364_length_241_cov_0.916667_g230166_i0	PRJNA493827	232364	241	0.916667	2.20916747	Deltaproteobacteria bacterium ADurb.Bin2	2026735	Bacteria	Bacteria	95.9	7.25e-21	NR	OQB08498.1	1852869	g230166	i0	53.6	8.43983402489627	84	33	97.1	1	238	5	497	580	OQB08498.1 MAG: Serine/threonine-protein kinase pkn1 [Deltaproteobacteria bacterium ADurb.Bin207]	diamond	2034	95.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium ADurb.Bin207
30013667	30013667	PRJNA493827_P_NODE_149691_length_280_cov_1.115942_g147493_i0	PRJNA493827	149691	280	1.115942	3.1246376	Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14	2013741	Bacteria	Bacteria	68.9	3.58e-11	NR	PKN54244.1	2013741	g147493	i0	52.6	0.835714285714286	78	34	83.6	2	3	236	1424	1498	PKN54244.1 MAG: hypothetical protein CVU56_27610, partial [Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14]	diamond	234	68.9	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium HGW-Deltaproteobacteria-14
30819213	30819213	PRJNA493827_P_NODE_236414_length_236_cov_2.834356_g234215_i0	PRJNA493827	236414	236	2.834356	6.68908016	Bacteria	2	Bacteria	Bacteria	62	4.78e-9	NR	OGP73786.1	1797840	g234215	i0	62.5	3.27966101694915	40	15	50.8	0	1	120	211	250	OGP73786.1 MAG: hypothetical protein A2V86_01420 [Deltaproteobacteria bacterium RBG_16_49_23]	diamond	774	62	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				Deltaproteobacteria bacterium RBG_16_49_23
31435635	31435635	PRJNA493827_P_NODE_58336_length_461_cov_2.340206_g56140_i0	PRJNA493827	58336	461	2.340206	10.78834966	Microvenator marinus	2600177	Bacteria	Bacteria	55.5	1.26e-5	NR	WP_146962556.1	2600177	g56140	i0	56.3	0.31236442516269	48	19	31.2	1	244	101	356	401	WP_146962556.1 hypothetical protein [Microvenator marinus]	diamond	144	55.5	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Microvenatoraceae	Microvenator	Microvenator marinus
32290195	32290195	PRJNA493827_P_NODE_213699_length_245_cov_0.895349_g211501_i0	PRJNA493827	213699	245	0.895349	2.19360505	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	43.1	0.027	NR	MBF0280102.1	2024889	g211501	i0	37.7	0.746938775510204	61	31	66.1	2	9	170	100	160	MBF0280102.1 bifunctional 3,4-dihydroxy-2-butanone-4-phosphate synthase/GTP cyclohydrolase II [SAR324 cluster bacterium]	diamond	183	43.1	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
32416452	32416452	PRJNA493827_P_NODE_157639_length_273_cov_1.185000_g155441_i0	PRJNA493827	157639	273	1.185	3.23505	SAR324 cluster bacterium	2024889	Bacteria	Bacteria	41.2	0.0133	NR	MDP7438704.1	2024889	g155441	i0	57.1	0.307692307692308	28	12	30.8	0	264	181	2	29	MDP7438704.1 membrane-binding protein [SAR324 cluster bacterium]	diamond	84	41.2	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria				SAR324 cluster bacterium
32794714	32794714	PRJNA493827_P_NODE_228360_length_242_cov_0.911243_g226162_i0	PRJNA493827	228360	242	0.911243	2.20520806	Persicimonas caeni	2292766	Bacteria	Bacteria	52	2.05e-5	NR	WP_141199634.1	2292766	g226162	i0	43.6	0.681818181818182	55	16	50.8	2	233	111	288	341	WP_141199634.1 hypothetical protein [Persicimonas caeni]	diamond	165	52	1	Bacteria	delta/epsilon subdivisions	Deltaproteobacteria	Bradymonadales	Bradymonadaceae	Persicimonas	Persicimonas caeni

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