metadata: contig_metadata: 4 rows where analysis = "blastn", bioproject = "PRJNA533623" and tax

4 rows where analysis = "blastn", bioproject = "PRJNA533623" 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
507433	507433	PRJNA533623_P_NODE_9261_length_769_cov_23.105932_g7739_i0	PRJNA533623	9261	769	23.105932	177.68461708	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	1262	0	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g7739	i0	99.567	95.851755526658	693	2	90	1	24	716	2029670	2028979	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	73710	1262	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
8160068	8160068	PRJNA533623_P_NODE_76587_length_203_cov_4.225352_g74806_i0	PRJNA533623	76587	203	4.225352	8.57746456	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	324	3.3999999999999998e-84	NTclustered	gi\|1958006436\|gb\|CP064962.1\|	2030811	g74806	i0	95.567	7.77832512315271	203	8	99	1	1	202	211622	211824	MAG: Candidatus Peregrinibacteria bacterium isolate Aved_18-Q3-R54-62_BAT3C.344 chromosome, complete genome	blastn	1579	324	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota					Candidatus Peregrinibacteria bacterium
11984663	11984663	PRJNA533623_P_NODE_1590_length_1611_cov_10.763226_g1001_i0	PRJNA533623	1590	1611	10.763226	173.39557086	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	1269	0	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g1001	i0	85.609	4.8895096213532	1216	167	75	8	2	1213	1024686	1025897	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	7877	1269	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium Aalborg_AAW-1
18357965	18357965	PRJNA533623_P_NODE_38795_length_352_cov_4.164948_g37021_i0	PRJNA533623	38795	352	4.164948	14.66061696	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	577	4.4399999999999985e-160	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g37021	i0	99.371	122.607954545455	318	2	90	0	18	335	112302	111985	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	43158	577	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae 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);;