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

7 rows where analysis = "blastn", bioproject = "PRJEB75017" and tax_clade = "PVC group"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
135318	135318	PRJEB75017_P_NODE_11361_length_276_cov_0.931034_g11232_i0	PRJEB75017	11361	276	0.931034	2.56965384	Phycisphaeraceae bacterium D3-23	3004190	Bacteria	Bacteria	52.8	0.025	NTclustered	gi\|2727577647\|gb\|CP114179.1\|	3004190	g11232	i0	92.105	0.13768115942029	38	1	14	2	1	38	2581670	2581705	Phycisphaeraceae bacterium D3-23 chromosome, complete genome	blastn	38	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium D3-23
2685437	2685437	PRJEB75017_P_NODE_183_length_1635_cov_4.533931_g152_i0	PRJEB75017	183	1635	4.533931	74.12977185	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	2449	0	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g152	i0	93.723	233.458103975535	1641	92	100	10	1	1635	28645	27010	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	381704	2449	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
9062632	9062632	PRJEB75017_P_NODE_17628_length_244_cov_0.912281_g17499_i0	PRJEB75017	17628	244	0.912281	2.22596564	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g17499	i0	100	0.114754098360656	28	0	11	0	68	95	3272398	3272371	Gemmata sp. SH-PL17, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
10338448	10338448	PRJEB75017_P_NODE_4189_length_428_cov_1.740845_g4060_i0	PRJEB75017	4189	428	1.740845	7.4508166	Victivallaceae bacterium	2793042	Bacteria	Bacteria	167	1.4100000000000001e-36	NTclustered	gi\|2621704067\|emb\|OY761536.1\|	2793042	g4060	i0	87.5	221.684579439252	144	18	34	0	232	375	1448355	1448212	MAG: Victivallaceae bacterium isolate e353ef71-700a-4510-b67c-5bed4426050c genome assembly, chromosome: 1	blastn	94881	167	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae		Victivallaceae bacterium
14163721	14163721	PRJEB75017_P_NODE_12812_length_261_cov_1.909574_g12683_i0	PRJEB75017	12812	261	1.909574	4.98398814	Aquisphaera giovannonii	406548	Bacteria	Bacteria	198	2.89e-46	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g12683	i0	81.124	1.8735632183908	249	45	95	2	1	248	4479127	4479374	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	489	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
19260885	19260885	PRJEB75017_P_NODE_10736_length_282_cov_1.119617_g10607_i0	PRJEB75017	10736	282	1.119617	3.15731994	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g10607	i0	96.774	0.109929078014184	31	1	11	0	165	195	782666	782696	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	31	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
19260900	19260900	PRJEB75017_P_NODE_12036_length_269_cov_1.311224_g11907_i0	PRJEB75017	12036	269	1.311224	3.52719256	Akkermansia glycaniphila	1679444	Bacteria	Bacteria	206	1.7899999999999998e-48	NTclustered	gi\|1093279401\|emb\|LT629973.1\|	1679444	g11907	i0	84	88.9739776951673	225	24	81	9	46	264	1727839	1727621	Akkermansia glycaniphila isolate APytT genome assembly, chromosome: I	blastn	23934	206	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia glycaniphila

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