metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJEB83711" and tax

7 rows where analysis = "blastn", bioproject = "PRJEB83711" 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
5246996	5246996	PRJEB83711_P_NODE_56025_length_255_cov_2.450549_g55759_i0	PRJEB83711	56025	255	2.450549	6.24889995	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	202	2.1699999999999998e-47	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g55759	i0	81.707	0.964705882352941	246	42	96	3	11	255	128421	128178	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	246	202	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
5247571	5247571	PRJEB83711_P_NODE_81785_length_228_cov_2.748387_g81519_i0	PRJEB83711	81785	228	2.748387	6.26632236	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	405	1.35e-108	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g81519	i0	98.684	217.083333333333	228	3	100	0	1	228	220455	220682	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	49495	405	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
7796067	7796067	PRJEB83711_P_NODE_26487_length_346_cov_2.923077_g26221_i0	PRJEB83711	26487	346	2.923077	10.11384642	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	449	9.94e-122	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g26221	i0	90.173	167.043352601156	346	32	100	2	1	346	219894	220237	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	57797	449	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
9072158	9072158	PRJEB83711_P_NODE_7748_length_651_cov_2.833910_g7495_i0	PRJEB83711	7748	651	2.83391	18.4487541	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	1072	0	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g7495	i0	96.33	112.242703533026	654	20	100	4	1	651	221028	221680	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	73070	1072	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
10346988	10346988	PRJEB83711_P_NODE_41429_length_285_cov_2.188679_g41163_i0	PRJEB83711	41429	285	2.188679	6.23773515	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	455	1.72e-123	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g41163	i0	95.439	89.540350877193	285	13	100	0	1	285	139230	138946	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	25519	455	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
11623356	11623356	PRJEB83711_P_NODE_79450_length_242_cov_0.923077_g79184_i0	PRJEB83711	79450	242	0.923077	2.23384634	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	292	1.18e-74	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g79184	i0	88.797	3.62809917355372	241	23	98	4	5	242	199073	198834	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	878	292	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota				Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
23950871	23950871	PRJEB83711_P_NODE_23059_length_370_cov_1.575758_g22793_i0	PRJEB83711	23059	370	1.575758	5.8303046	Candidatus Mycosynbacter	2831665	Bacteria	Bacteria	638	2.1199999999999997e-178	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g22793	i0	98.087	160.881081081081	366	7	99	0	5	370	852464	852099	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	59526	643	0.992223950233281	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);;