metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Peregrinibacteriota"

5 rows where analysis = "diamond", bioproject = "PRJNA630162" and tax_phylum = "Candidatus Peregrinibacteriota"

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_species
26700791	26700791	PRJNA630162_P_NODE_62381_length_224_cov_1.371429_g60858_i0	PRJNA630162	62381	224	1.371429	3.07200096	Candidatus Peribacteria bacterium RIFCSPLOWO2_	2053688	Bacteria	Bacteria	45.4	4.44e-4	NR	OGJ69802.1	1801929	g60858	i0	54.3	0.616071428571429	46	21	61.6	0	8	145	27	72	OGJ69802.1 MAG: hypothetical protein A3H90_02195 [Candidatus Peribacteria bacterium RIFCSPLOWO2_02_FULL_55_36]	diamond	138	45.4	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium RIFCSPLOWO2_02_FULL_55_36
29606646	29606646	PRJNA630162_P_NODE_58570_length_230_cov_3.596685_g57047_i0	PRJNA630162	58570	230	3.596685	8.2723755	Candidatus Peribacteria bacterium RIFCSPHIGHO2_	2053688	Bacteria	Bacteria	47.4	2.82e-4	NR	OGJ63382.1	1801919	g57047	i0	65	0.521739130434783	40	13	50.9	1	219	103	57	96	OGJ63382.1 MAG: hypothetical protein A3C52_05380 [Candidatus Peribacteria bacterium RIFCSPHIGHO2_02_FULL_51_15]	diamond	120	47.4	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium RIFCSPHIGHO2_02_FULL_51_15
29827810	29827810	PRJNA630162_P_NODE_114651_length_177_cov_1.867188_g113128_i0	PRJNA630162	114651	177	1.867188	3.30492276	Candidatus Peregrinibacteria bacterium	2030811	Bacteria	Bacteria	53.1	2.77e-6	NR	MBN2087622.1	2030811	g113128	i0	39.3	0.949152542372881	56	34	94.9	0	8	175	49	104	MBN2087622.1 hypothetical protein [Candidatus Peregrinibacteria bacterium]	diamond	168	53.1	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota		Candidatus Peregrinibacteria bacterium
30048930	30048930	PRJNA630162_P_NODE_165151_length_159_cov_2.336364_g163628_i0	PRJNA630162	165151	159	2.336364	3.71481876	Candidatus Peribacteria bacterium RIFCSPLOWO2_	2053688	Bacteria	Bacteria	46.6	6.73e-5	NR	OGJ69802.1	1801929	g163628	i0	64.1	0.735849056603774	39	14	73.6	0	122	6	1	39	OGJ69802.1 MAG: hypothetical protein A3H90_02195 [Candidatus Peribacteria bacterium RIFCSPLOWO2_02_FULL_55_36]	diamond	117	46.6	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium RIFCSPLOWO2_02_FULL_55_36
32294179	32294179	PRJNA630162_P_NODE_65499_length_218_cov_3.390533_g63976_i0	PRJNA630162	65499	218	3.390533	7.39136194	Candidatus Peribacteria bacterium RIFCSPHIGHO2_	2053688	Bacteria	Bacteria	84	1.54e-18	NR	OGJ63382.1	1801919	g63976	i0	65.7	0.963302752293578	70	23	95	1	217	11	47	116	OGJ63382.1 MAG: hypothetical protein A3C52_05380 [Candidatus Peribacteria bacterium RIFCSPHIGHO2_02_FULL_51_15]	diamond	210	84	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium RIFCSPHIGHO2_02_FULL_51_15

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