metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA436017" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA436017" 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_genus	tax_species
8741943	8741943	PRJNA436017_P_NODE_25847_length_160_cov_1.666667_g25549_i0	PRJNA436017	25847	160	1.666667	2.6666672	Bacteria	2	Bacteria	Bacteria	241	2.6400000000000007e-59	NTclustered	gi\|1958075319\|gb\|CP064995.1\|	2026720	g25549	i0	93.75	51	160	10	100	0	1	160	694251	694410	Candidatus Saccharibacteria bacterium isolate Hjor_18-Q3-R7-51_MAXAC.102_uni chromosome, complete genome	blastn	8160	241	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
9358921	9358921	PRJNA436017_P_NODE_24008_length_166_cov_2.666667_g23710_i0	PRJNA436017	24008	166	2.666667	4.42666722	Candidatus Minimicrobia naudis	2841263	Bacteria	Bacteria	139	1.04e-28	NTclustered	gi\|2052595119\|gb\|CP076460.1\|	2841263	g23710	i0	89.815	63.5963855421687	108	11	65	0	9	116	125176	125283	Candidatus Minimicrobia naudis isolate IHU1 chromosome, complete genome	blastn	10557	139	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Minimicrobia	Candidatus Minimicrobia naudis
18282396	18282396	PRJNA436017_P_NODE_21455_length_176_cov_2.431655_g21157_i0	PRJNA436017	21455	176	2.431655	4.2797128	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	303	3.71e-78	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g21157	i0	97.727	122.198863636364	176	4	100	0	1	176	883203	883378	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	21507	303	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota bacterium
18282557	18282557	PRJNA436017_P_NODE_435_length_1289_cov_15.484026_g356_i0	PRJNA436017	435	1289	15.484026	199.58909514	Parcubacteria group bacterium GW2011_GWA1_59_11	1618804	Bacteria	Bacteria	1208	0	NTclustered	gi\|1118703539\|gb\|KX123452.1\|	1618804	g356	i0	85.543	66.041892940263807	1169	154	90	15	4	1164	1162	1	Parcubacteria group bacterium GW2011_GWA1_59_11 16S ribosomal RNA gene, partial sequence	blastn	85128	1208	1	Bacteria	Bacteria candidate phyla			Parcubacteria group bacterium GW2011_GWA1_59_11
24656923	24656923	PRJNA436017_P_NODE_1220_length_850_cov_7.489545_g1040_i0	PRJNA436017	1220	850	7.489545	63.6611325	Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1	1619007	Bacteria	Bacteria	678	0	NTclustered	gi\|837348553\|gb\|CP011209.1\|	1619007	g1040	i0	82.28	283.841176470588	807	122	94	15	50	850	819699	820490	MAG: Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1 chromosome, complete genome	blastn	241265	678	1	Bacteria	Bacteria candidate phyla	Candidatus Wolfeibacteriota		Candidatus Wolfebacteria bacterium GW2011_GWB1_47_1
24657024	24657024	PRJNA436017_P_NODE_17140_length_198_cov_2.968944_g16842_i0	PRJNA436017	17140	198	2.968944	5.87850912	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	261	2.6200000000000002e-65	NTclustered	gi\|1474570736\|gb\|CP023991.1\|	2026720	g16842	i0	90.404	529.383838383838	198	19	100	0	1	198	884192	884389	Candidatus Saccharibacteria bacterium isolate CG19_WC_8_21_14_NA_150_51_44 chromosome, complete genome	blastn	104818	261	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharimonadota 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);;