metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA431371" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA431371" 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
2978710	2978710	PRJNA431371_P_NODE_15123_length_329_cov_0.941406_g15050_i0	PRJNA431371	15123	329	0.941406	3.09722574	Phycisphaera sp.	2030824	Bacteria	Bacteria	296	1.3e-75	NTclustered	gi\|2323351239\|gb\|CP098402.1\|	2030824	g15050	i0	87.037	240.617021276596	270	25	81	9	1	267	3046977	3047239	MAG: Phycisphaera sp. isolate MAG12 chromosome	blastn	79163	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Phycisphaera	Phycisphaera sp.
6805775	6805775	PRJNA431371_P_NODE_14866_length_331_cov_1.434109_g14793_i0	PRJNA431371	14866	331	1.434109	4.74690079	Planctomycetes bacterium MalM25	2527998	Bacteria	Bacteria	65.8	4e-6	NTclustered	gi\|1712524857\|gb\|CP036424.1\|	2527998	g14793	i0	95.238	0.558912386706949	42	1	13	1	289	330	567965	568005	Planctomycetes bacterium MalM25 chromosome	blastn	185	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium MalM25
14457436	14457436	PRJNA431371_P_NODE_7452_length_449_cov_2.510638_g7379_i0	PRJNA431371	7452	449	2.510638	11.27276462	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	516	1.28e-141	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g7379	i0	89.398	204.510022271715	415	37	92	7	32	444	2583640	2584049	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	91825	516	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
19554383	19554383	PRJNA431371_P_NODE_4116_length_575_cov_1.713147_g4043_i0	PRJNA431371	4116	575	1.713147	9.85059525	Stieleria varia	2528005	Bacteria	Bacteria	56.5	0.004	NTclustered	gi\|2720418917\|gb\|CP151726.1\|	2528005	g4043	i0	100	0.0521739130434783	30	0	5	0	257	286	4770120	4770091	Stieleria varia strain Pla52n chromosome, complete genome	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria varia
24039820	24039820	PRJNA431371_P_NODE_29899_length_247_cov_0.885057_g29826_i0	PRJNA431371	29899	247	0.885057	2.18609079	Chlamydia	810	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2160489723\|gb\|CP042714.1\|	813	g29826	i0	100	2.94736842105263	28	0	11	0	36	63	918118	918091	Chlamydia trachomatis strain TC0743::TncL2/tetR-2180 chromosome, complete genome	blastn	728	52.8	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia trachomatis

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