metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA657343" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA657343" 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
1899892	1899892	PRJNA657343_S_NODE_20122_length_201_cov_3.368421_g20097_i0	PRJNA657343	20122	201	3.368421	6.77052621	Phycisphaera sp.	2030824	Bacteria	Bacteria	237	4.4999999999999996e-58	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g20097	i0	88.06	8.48258706467662	201	23	100	1	1	201	3047330	3047131	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	1705	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
1900206	1900206	PRJNA657343_S_NODE_27662_length_169_cov_5.383333_g27637_i0	PRJNA657343	27662	169	5.383333	9.09783277	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	235	1.31e-57	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g27637	i0	92.169	204.668639053254	166	13	98	0	1	166	192629	192464	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	34589	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
4452108	4452108	PRJNA657343_S_NODE_32884_length_151_cov_5.607843_g32859_i0	PRJNA657343	32884	151	5.607843	8.46784293	Horticoccus luteus	2862869	Bacteria	Bacteria	244	1.89e-60	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g32859	i0	98.561	33.4437086092715	139	1	92	1	1	139	540019	540156	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	5050	244	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
9552485	9552485	PRJNA657343_S_NODE_25028_length_179_cov_1.823077_g25003_i0	PRJNA657343	25028	179	1.823077	3.26330783	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	211	2.36e-50	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g25003	i0	88.268	120.441340782123	179	17	99	4	2	178	655212	655388	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	21559	211	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
14652424	14652424	PRJNA657343_S_NODE_13792_length_244_cov_5.692308_g13767_i0	PRJNA657343	13792	244	5.692308	13.88923152	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	219	2.05e-52	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g13767	i0	84.052	14.827868852459	232	32	94	5	1	230	2190373	2190145	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	3618	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
14653141	14653141	PRJNA657343_S_NODE_31612_length_156_cov_2.457944_g31587_i0	PRJNA657343	31612	156	2.457944	3.83439264	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	206	9.32e-49	NTclustered	gi\|2916415364\|gb\|CP170459.1\|	2026799	g31587	i0	90.446	94.974358974359	157	14	100	1	1	156	2577657	2577813	MAG: Verrucomicrobiota bacterium isolate tig00002468 chromosome, complete genome	blastn	14816	206	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
15189027	15189027	PRJNA657343_S_NODE_28732_length_166_cov_2.350427_g28707_i0	PRJNA657343	28732	166	2.350427	3.90170882	Verrucomicrobiota	74201	Bacteria	Bacteria	182	1.7e-41	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g28707	i0	89.041	31.7710843373494	146	16	88	0	1	146	5152316	5152461	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	5274	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
18475791	18475791	PRJNA657343_S_NODE_15155_length_233_cov_3.320652_g15130_i0	PRJNA657343	15155	233	3.320652	7.73711916	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	335	1.8499999999999992e-87	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g15130	i0	94.47	110.609442060086	217	12	93	0	2	218	2556208	2556424	Lacunisphaera limnophila strain IG16b, complete genome	blastn	25772	335	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
24849770	24849770	PRJNA657343_S_NODE_13160_length_249_cov_30.555000_g13135_i0	PRJNA657343	13160	249	30.555	76.08195	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	307	4.3600000000000006e-79	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g13135	i0	89.243	3.78313253012048	251	20	100	6	1	249	2190130	2190375	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	942	307	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales 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);;