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

4 rows where analysis = "blastn", bioproject = "PRJNA399711" 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
25837330	25837330	PRJNA399711_S_NODE_87707_length_162_cov_4.992000_g87565_i0	PRJNA399711	87707	162	4.992	8.08704	Candidatus Altimarinota bacterium	2044595	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2621785413\|emb\|OY781871.1\|	2044595	g87565	i0	100	0.351851851851852	29	0	18	0	39	67	246146	246174	MAG: Candidatus Gracilibacteria bacterium isolate aa87c5ac-7a06-4bd6-af26-82c4354fe085 genome assembly, chromosome: 1	blastn	57	54.7	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Altimarinota bacterium
25973109	25973109	PRJNA399711_S_NODE_73868_length_173_cov_1.551471_g73726_i0	PRJNA399711	73868	173	1.551471	2.68404483	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	209	8.15e-50	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g73726	i0	88.889	107.50289017341	171	17	99	2	1	171	219941	220109	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	18598	209	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
26106176	26106176	PRJNA399711_S_NODE_100557_length_154_cov_18.094017_g100415_i0	PRJNA399711	100557	154	18.094017	27.86478618	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	241	2.51e-59	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g100415	i0	94.805	3	154	8	100	0	1	154	204948	205101	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	462	241	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
26243973	26243973	PRJNA399711_S_NODE_38422_length_219_cov_2.351648_g38280_i0	PRJNA399711	38422	219	2.351648	5.15010912	Candidatus Saccharimonas sp.	1917697	Bacteria	Bacteria	294	2.92e-75	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g38280	i0	91.204	0.986301369863014	216	19	99	0	1	216	54519	54304	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	216	294	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas 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);;