metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Absconditibacteriota"

8 rows where analysis = "blastn", bioproject = "PRJNA1148190" and tax_phylum = "Candidatus Absconditibacteriota"

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_species
6672819	6672819	PRJNA1148190_P_NODE_386226_length_289_cov_1.287037_g375053_i0	PRJNA1148190	386226	289	1.287037	3.71953693	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	230	1.1499999999999995e-55	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g375053	i0	83.6	1.05882352941176	250	35	85	5	43	289	973259	973013	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	306	230	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
11775116	11775116	PRJNA1148190_P_NODE_488850_length_269_cov_1.178571_g477677_i0	PRJNA1148190	488850	269	1.178571	3.17035599	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	185	2.3299999999999993e-42	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g477677	i0	79.554	1	269	47	99	7	1	268	830035	829774	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	269	185	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium RAAC1_SR1_1
15602199	15602199	PRJNA1148190_P_NODE_721073_length_244_cov_0.900585_g709900_i0	PRJNA1148190	721073	244	0.900585	2.1974274	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	429	8.699999999999998e-116	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g709900	i0	98.361	1	244	4	100	0	1	244	549371	549128	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	244	429	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
15603319	15603319	PRJNA1148190_P_NODE_81613_length_604_cov_1.632768_g70488_i0	PRJNA1148190	81613	604	1.632768	9.86191872	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	117	2.09e-21	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g70488	i0	80.519	7.08443708609272	154	29	25	1	214	367	512115	512267	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	4279	117	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
19422395	19422395	PRJNA1148190_P_NODE_477716_length_271_cov_1.262626_g466543_i0	PRJNA1148190	477716	271	1.262626	3.42171646	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	122	1.87e-23	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g466543	i0	81.098	1.23985239852399	164	22	61	5	4	167	280443	280289	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	336	122	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
19424576	19424576	PRJNA1148190_P_NODE_641156_length_248_cov_0.880000_g629983_i0	PRJNA1148190	641156	248	0.88	2.1824	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	226	1.2499999999999999e-54	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g629983	i0	83.065	1	248	42	100	0	1	248	979602	979849	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	248	226	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium Aalborg_AAW-1
19425779	19425779	PRJNA1148190_P_NODE_73876_length_644_cov_1.026270_g62773_i0	PRJNA1148190	73876	644	1.02627	6.6091788	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	111	1.04e-19	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g62773	i0	77.778	0.62888198757764	216	24	32	15	364	567	532068	531865	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	405	111	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium RAAC1_SR1_1
21973496	21973496	PRJNA1148190_P_NODE_513438_length_264_cov_1.329843_g502265_i0	PRJNA1148190	513438	264	1.329843	3.51078552	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	143	1.39e-29	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g502265	i0	96.512	0.484848484848485	86	3	33	0	1	86	181205	181120	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	128	143	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota	candidate division SR1 bacterium RAAC1_SR1_1

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);;