metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA669701" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA669701" 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
636588	636588	PRJNA669701_P_NODE_93641_length_266_cov_1.362694_g93246_i0	PRJNA669701	93641	266	1.362694	3.62476604	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	130	1.09e-25	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g93246	i0	96.203	44.0789473684211	79	3	30	0	1	79	6122	6044	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	11725	130	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium GW2011_OD1_34_28
3716453	3716453	PRJNA669701_P_NODE_87103_length_273_cov_2.670000_g86708_i0	PRJNA669701	87103	273	2.67	7.2891	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	438	1.6499999999999995e-118	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g86708	i0	95.652	113.739926739927	276	7	100	5	1	273	80247	80520	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	31051	438	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
7013808	7013808	PRJNA669701_P_NODE_129306_length_245_cov_0.895349_g128911_i0	PRJNA669701	129306	245	0.895349	2.19360505	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	453	5.1900000000000006e-123	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g128911	i0	100	1	245	0	100	0	1	245	302541	302297	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	245	453	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
7015084	7015084	PRJNA669701_P_NODE_95006_length_264_cov_2.350785_g94611_i0	PRJNA669701	95006	264	2.350785	6.2060724	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	63.9	1.11e-5	NTclustered	gi\|2108052961\|gb\|CP070757.1\|	2052149	g94611	i0	93.023	0.162878787878788	43	3	16	0	11	53	2414347	2414389	MAG: Candidatus Aminicenantes bacterium isolate bin290 chromosome	blastn	43	63.9	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota					Candidatus Aminicenantes bacterium
22313474	22313474	PRJNA669701_P_NODE_70698_length_294_cov_1.769231_g70303_i0	PRJNA669701	70698	294	1.769231	5.20153914	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	473	4.909999999999999e-129	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g70303	i0	95.608	215.598639455782	296	11	100	2	1	294	850903	851198	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	63386	473	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17

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