metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA888821" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA888821" and tax_clade = "Bacteria candidate phyla"

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_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3413718	3413718	PRJNA888821_P_NODE_37623_length_245_cov_0.895349_g37540_i0	PRJNA888821	37623	245	0.895349	2.19360505	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	398	2.47e-106	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g37540	i0	95.935	264.604081632653	246	9	100	1	1	245	964068	964313	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	64828	398	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
8515477	8515477	PRJNA888821_P_NODE_15667_length_310_cov_6.059072_g15585_i0	PRJNA888821	15667	310	6.059072	18.7831232	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	278	4.39e-70	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g15585	i0	100	0.967741935483871	150	0	97	0	1	150	609702	609851	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	300	278	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
8515533	8515533	PRJNA888821_P_NODE_19727_length_310_cov_2.738397_g19645_i0	PRJNA888821	19727	310	2.738397	8.4890307	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	261	4.42e-65	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g19645	i0	98	0.967741935483871	150	3	97	0	161	310	348195	348046	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	300	261	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
11445617	11445617	PRJNA888821_P_NODE_28349_length_277_cov_5.196078_g28267_i0	PRJNA888821	28349	277	5.196078	14.39313606	Candidatus Saccharimonas	1331051	Bacteria	Bacteria	137	6.84e-28	NTclustered	gi\|499052612\|gb\|CP005957.1\|	1332188	g28267	i0	100	9.25270758122744	74	0	27	0	204	277	917609	917536	Candidatus Saccharimonas aalborgensis isolate TM71 chromosome, complete genome	blastn	2563	137	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas aalborgensis
12341691	12341691	PRJNA888821_P_NODE_14370_length_310_cov_7.025316_g14288_i0	PRJNA888821	14370	310	7.025316	21.7784796	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	244	4.4499999999999996e-60	NTclustered	gi\|2621785934\|emb\|OY782392.1\|	2052139	g14288	i0	96	49.2741935483871	150	6	95	0	1	150	426755	426904	MAG: Patescibacteria group bacterium isolate 573f42cd-6ce4-4b95-a45b-0ed028197a55 genome assembly, chromosome: 1	blastn	15275	244	1	Bacteria	Bacteria candidate phyla						Patescibacteria group bacterium
12342154	12342154	PRJNA888821_P_NODE_41750_length_232_cov_13.383648_g41667_i0	PRJNA888821	41750	232	13.383648	31.05006336	uncultured Candidatus Saccharibacteria bacterium	179883	Bacteria	Bacteria	320	5.15e-83	NTclustered	gi\|2874253993\|emb\|OY970318.1\|	179883	g41667	i0	91.453	213.504310344828	234	18	100	1	1	232	473149	473382	MAG: uncultured Candidatus Saccharibacteria bacterium isolate MFD04716.bin.c.3 genome assembly, chromosome: 1	blastn	49533	320	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					uncultured Candidatus Saccharibacteria bacterium
12342312	12342312	PRJNA888821_P_NODE_5110_length_328_cov_28.776471_g5028_i0	PRJNA888821	5110	328	28.776471	94.38682488	Candidatus Binatia bacterium	2838779	Bacteria	Bacteria	311	4.61e-80	NTclustered	gi\|2575803556\|emb\|OY729432.1\|	2838779	g5028	i0	84.084	307.484756097561	333	41	99	8	2	328	2239537	2239211	MAG: Candidatus Binatia bacterium isolate b65fbbe8-1638-4b94-9072-1473f084fbf4 genome assembly, chromosome: 1	blastn	100855	311	1	Bacteria	Bacteria candidate phyla	Candidatus Binatota	Candidatus Binatia				Candidatus Binatia bacterium
16165526	16165526	PRJNA888821_P_NODE_28953_length_274_cov_9.333333_g28871_i0	PRJNA888821	28953	274	9.333333	25.57333242	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	265	2.97e-66	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g28871	i0	87.826	1.91240875912409	230	23	83	2	47	274	628617	628843	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	524	265	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
16544405	16544405	PRJNA888821_P_NODE_36473_length_247_cov_3.258621_g36390_i0	PRJNA888821	36473	247	3.258621	8.04879387	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	148	2.77e-31	NTclustered	gi\|2869833183\|gb\|CP175706.1\|	2093824	g36390	i0	97.701	16.1012145748988	87	1	35	1	29	114	97102	97188	Candidatus Nanosynbacter lyticus strain BB004 chromosome, complete genome	blastn	3977	148	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter lyticus

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