metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA572587" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA572587" 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
558931	558931	PRJNA572587_P_NODE_26261_length_218_cov_17.396450_g25933_i0	PRJNA572587	26261	218	17.39645	37.924261	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	281	2.26e-71	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g25933	i0	94.505	148.036697247706	182	10	83	0	2	183	220513	220332	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	32272	281	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
1135900	1135900	PRJNA572587_P_NODE_11601_length_344_cov_17.789831_g11273_i0	PRJNA572587	11601	344	17.789831	61.19701864	Bacteria	2	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g11273	i0	100	0.5	30	0	9	0	8	37	985842	985813	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	172	56.5	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
1834092	1834092	PRJNA572587_P_NODE_13722_length_312_cov_37.692015_g13394_i0	PRJNA572587	13722	312	37.692015	117.5990868	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	318	2.6e-82	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g13394	i0	87.41	0.891025641025641	278	33	88	2	24	299	203580	203857	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	278	318	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota					candidate division SR1 bacterium RAAC1_SR1_1
6239461	6239461	PRJNA572587_P_NODE_16105_length_285_cov_414.216102_g15777_i0	PRJNA572587	16105	285	414.216102	1180.5158907	Candidatus Saccharimonadota	95818	Bacteria	Bacteria	309	1.41e-79	NTclustered	gi\|2070586293\|gb\|CP076101.2\|	1917697	g15777	i0	91.304	142.933333333333	230	15	81	5	29	256	115481	115255	MAG: Candidatus Saccharimonas sp. isolate JCVI_32_bin.49 chromosome, complete genome	blastn	40736	309	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Saccharimonas	Candidatus Saccharimonas sp.
12037839	12037839	PRJNA572587_P_NODE_20090_length_253_cov_1.539216_g19762_i0	PRJNA572587	20090	253	1.539216	3.89421648	uncultured candidate division WYO bacterium	214886	Bacteria	Bacteria	130	1.03e-25	NTclustered	gi\|105990437\|gb\|DQ514168.1\|	214886	g19762	i0	82.468	40.7549407114625	154	21	59	6	1	149	439	591	Uncultured candidate division WYO bacterium clone 500M1_H9 16S ribosomal RNA gene, partial sequence	blastn	10311	130	1	Bacteria	Bacteria candidate phyla						uncultured candidate division WYO bacterium
13312812	13312812	PRJNA572587_P_NODE_24131_length_229_cov_4.016667_g23803_i0	PRJNA572587	24131	229	4.016667	9.19816743	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	351	1.8e-92	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g23803	i0	97.561	106.475982532751	205	5	90	0	24	228	665317	665113	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	24383	351	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
15861565	15861565	PRJNA572587_P_NODE_27613_length_212_cov_14.269939_g27285_i0	PRJNA572587	27613	212	14.269939	30.25227068	Candidatus Nanogingivalaceae bacterium	2725942	Bacteria	Bacteria	224	3.7299999999999996e-54	NTclustered	gi\|2070571752\|gb\|CP072208.2\|	2725942	g27285	i0	91.925	1.5188679245283	161	12	75	1	25	184	47041	46881	MAG: Candidatus Nanogingivalaceae bacterium isolate JCVI_27_bin.3 chromosome, complete genome	blastn	322	224	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Nanosyncoccalia	Candidatus Nanogingivales	Candidatus Nanogingivalaceae		Candidatus Nanogingivalaceae bacterium
20960904	20960904	PRJNA572587_P_NODE_17737_length_270_cov_20.262443_g17409_i0	PRJNA572587	17737	270	20.262443	54.7085961	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	135	2.39e-27	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g17409	i0	91.089	0.666666666666667	101	7	37	2	101	201	38289	38387	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	180	135	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
24785009	24785009	PRJNA572587_P_NODE_22380_length_238_cov_84.195767_g22052_i0	PRJNA572587	22380	238	84.195767	200.38592546	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	276	1.17e-69	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g22052	i0	90.187	67.3865546218487	214	18	89	3	26	238	668341	668130	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	16038	276	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharibacteria bacterium TM7i
24785416	24785416	PRJNA572587_P_NODE_8780_length_406_cov_108.128852_g8453_i0	PRJNA572587	8780	406	108.128852	439.00313912	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	608	1.839999999999999e-169	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g8453	i0	95.989	90.8669950738916	374	15	92	0	32	405	964046	963673	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	36892	608	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria 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);;