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

6 rows where analysis = "blastn" and tax_phylum = "Candidatus Delongiibacteriota"

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
364324	364324	PRJNA168635_P_NODE_16701_length_195_cov_88.089041_g16285_i0	PRJNA168635	16701	195	88.089041	171.77362995	Candidatus Delongbacteria bacterium	2044594	Bacteria	Bacteria	121	4.549999999999999e-23	NTclustered	gi\|2621703064\|emb\|OY760505.1\|	2044594	g16285	i0	83.333	34.6461538461538	132	21	67	1	2	132	975997	975866	MAG: Candidatus Delongbacteria bacterium isolate e048cef4-8537-4b4e-84e6-a717ce783c17 genome assembly, chromosome: 1	blastn	6756	121	1	Bacteria	Bacteria candidate phyla	Candidatus Delongiibacteriota	Candidatus Delongbacteria bacterium
477249	477249	PRJNA495391_S_NODE_69181_length_152_cov_1.230769_g68129_i0	PRJNA495391	69181	152	1.230769	1.87076888	Candidatus Delongbacteria bacterium	2044594	Bacteria	Bacteria	104	3.38e-18	NTclustered	gi\|2621703064\|emb\|OY760505.1\|	2044594	g68129	i0	81.203	0.875	133	22	86	3	22	152	1116298	1116167	MAG: Candidatus Delongbacteria bacterium isolate e048cef4-8537-4b4e-84e6-a717ce783c17 genome assembly, chromosome: 1	blastn	133	104	1	Bacteria	Bacteria candidate phyla	Candidatus Delongiibacteriota	Candidatus Delongbacteria bacterium
5705428	5705428	PRJNA630162_P_NODE_153565_length_163_cov_3.947368_g152042_i0	PRJNA630162	153565	163	3.947368	6.43420984	Candidatus Delongbacteria bacterium	2044594	Bacteria	Bacteria	200	4.589999999999999e-47	NTclustered	gi\|2621703064\|emb\|OY760505.1\|	2044594	g152042	i0	89.308	252.110429447853	159	17	98	0	1	159	976286	976444	MAG: Candidatus Delongbacteria bacterium isolate e048cef4-8537-4b4e-84e6-a717ce783c17 genome assembly, chromosome: 1	blastn	41094	200	1	Bacteria	Bacteria candidate phyla	Candidatus Delongiibacteriota	Candidatus Delongbacteria bacterium
10806463	10806463	PRJNA630162_P_NODE_38689_length_286_cov_8.848101_g37166_i0	PRJNA630162	38689	286	8.848101	25.30556886	Candidatus Delongbacteria bacterium	2044594	Bacteria	Bacteria	237	6.8e-58	NTclustered	gi\|2621703064\|emb\|OY760505.1\|	2044594	g37166	i0	82.784	429.688811188811	273	39	94	7	5	274	977573	977840	MAG: Candidatus Delongbacteria bacterium isolate e048cef4-8537-4b4e-84e6-a717ce783c17 genome assembly, chromosome: 1	blastn	122891	237	1	Bacteria	Bacteria candidate phyla	Candidatus Delongiibacteriota	Candidatus Delongbacteria bacterium
18558992	18558992	PRJNA716463_P_NODE_103355_length_248_cov_3.114286_g102938_i0	PRJNA716463	103355	248	3.114286	7.72342928	Candidatus Delongbacteria bacterium	2044594	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2621703064\|emb\|OY760505.1\|	2044594	g102938	i0	100	0.112903225806452	28	0	11	0	157	184	2665405	2665378	MAG: Candidatus Delongbacteria bacterium isolate e048cef4-8537-4b4e-84e6-a717ce783c17 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	Bacteria candidate phyla	Candidatus Delongiibacteriota	Candidatus Delongbacteria bacterium
26324664	26324664	PRJEB14175_P_NODE_270831_length_189_cov_2.640625_g268563_i0	PRJEB14175	270831	189	2.640625	4.99078125	Candidatus Delongbacteria bacterium	2044594	Bacteria	Bacteria	167	5.549999999999999e-37	NTclustered	gi\|2621703064\|emb\|OY760505.1\|	2044594	g268563	i0	83.246	140.687830687831	191	23	97	8	6	189	978787	978599	MAG: Candidatus Delongbacteria bacterium isolate e048cef4-8537-4b4e-84e6-a717ce783c17 genome assembly, chromosome: 1	blastn	26590	167	1	Bacteria	Bacteria candidate phyla	Candidatus Delongiibacteriota	Candidatus Delongbacteria 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);;