metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJEB83101" and tax

9 rows where analysis = "blastn", bioproject = "PRJEB83101" 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
2691282	2691282	PRJEB83101_P_NODE_17463_length_446_cov_2.142091_g17160_i0	PRJEB83101	17463	446	2.142091	9.55372586	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	785	0	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g17160	i0	98.43	272.201793721973	446	7	100	0	1	446	220421	220866	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	121402	785	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
3969232	3969232	PRJEB83101_P_NODE_84364_length_243_cov_0.917647_g84059_i0	PRJEB83101	84364	243	0.917647	2.22988221	Candidatus Southlakia epibionticum	3043284	Bacteria	Bacteria	302	1.97e-77	NTclustered	gi\|2516687873\|gb\|CP124550.1\|	3043284	g84059	i0	97.714	1.97119341563786	175	4	100	0	1	175	254810	254636	Candidatus Southlakia epibionticum strain ML1 chromosome, complete genome	blastn	479	302	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Saccharimonadales	Candidatus Saccharimonadaceae	Candidatus Southlakia	Candidatus Southlakia epibionticum
6519366	6519366	PRJEB83101_P_NODE_15786_length_473_cov_1.877500_g15489_i0	PRJEB83101	15786	473	1.8775	8.880575	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	804	0	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g15489	i0	97.269	233.835095137421	476	9	100	4	1	473	221334	220860	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	110604	804	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
7795449	7795449	PRJEB83101_P_NODE_85367_length_242_cov_1.550296_g85062_i0	PRJEB83101	85367	242	1.550296	3.75171632	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	137	5.85e-28	NTclustered	gi\|1958123529\|gb\|CP065016.1\|	2026720	g85062	i0	93.478	11.2148760330579	92	6	38	0	95	186	1044005	1044096	Candidatus Saccharibacteria bacterium isolate Vibo_18-Q3-R45-57_BAT3C.117_fly chromosome, complete genome	blastn	2714	137	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
9070538	9070538	PRJEB83101_P_NODE_90268_length_228_cov_2.341935_g89963_i0	PRJEB83101	90268	228	2.341935	5.3396118	Candidatus Nanosynbacter featherlites	2572088	Bacteria	Bacteria	363	8.269999999999999e-96	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g89963	i0	95.575	16.8552631578947	226	10	99	0	1	226	56856	56631	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	3843	363	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
11620080	11620080	PRJEB83101_P_NODE_30270_length_334_cov_2.957854_g29965_i0	PRJEB83101	30270	334	2.957854	9.87923236	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	427	4.48e-115	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g29965	i0	89.82	170.988023952096	334	32	100	2	1	334	220240	219909	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	57110	427	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
17992915	17992915	PRJEB83101_P_NODE_23275_length_381_cov_4.792208_g22970_i0	PRJEB83101	23275	381	4.792208	18.25831248	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	614	3.6899999999999996e-171	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g22970	i0	95.789	68.8923884514436	380	16	99	0	1	380	800008	799629	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	26248	614	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
19267931	19267931	PRJEB83101_P_NODE_60656_length_259_cov_1.467742_g60351_i0	PRJEB83101	60656	259	1.467742	3.80145178	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	318	2.11e-82	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g60351	i0	88.846	40.7567567567568	260	27	100	2	1	259	547685	547427	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	10556	318	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
20124219	20124219	PRJEB83101_P_NODE_28156_length_346_cov_2.194139_g27851_i0	PRJEB83101	28156	346	2.194139	7.59172094	Candidatus Mycosynbacter	2831665	Bacteria	Bacteria	601	2.5899999999999993e-167	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g27851	i0	97.977	164.554913294798	346	7	100	0	1	346	852444	852099	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	56936	601	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);;