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

5 rows where analysis = "blastn", bioproject = "PRJNA1180292" and tax_phylum = "Planctomycetota"

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
1041216	1041216	PRJNA1180292_P_NODE_11421_length_245_cov_0.906977_g11289_i0	PRJNA1180292	11421	245	0.906977	2.22209365	Pseudomonadati	3379134	Bacteria	Bacteria	104	6.02e-18	NTclustered	gi\|1927961636\|gb\|CP054187.1\|	2052181	g11289	i0	81.89	26.269387755102	127	19	51	3	119	243	2184328	2184204	MAG: Planctomycetia bacterium isolate H1_PLA2 chromosome, complete genome	blastn	6436	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
15620693	15620693	PRJNA1180292_P_NODE_8233_length_252_cov_1.206704_g8101_i0	PRJNA1180292	8233	252	1.206704	3.04089408	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	422	1.51e-113	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g8101	i0	96.825	89.9801587301587	252	8	100	0	1	252	3096770	3097021	Pirellula sp. SH-Sr6A, complete genome	blastn	22675	422	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
16894915	16894915	PRJNA1180292_P_NODE_10694_length_247_cov_0.896552_g10562_i0	PRJNA1180292	10694	247	0.896552	2.21448344	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	167	7.64e-37	NTclustered	gi\|2874254109\|emb\|OY970194.1\|	2813034	g10562	i0	82.051	0.789473684210526	195	35	79	0	45	239	3774249	3774443	MAG: Sedimentisphaerales bacterium isolate MFD00905.bin.c.1 genome assembly, chromosome: 1	blastn	195	167	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
18169470	18169470	PRJNA1180292_P_NODE_12375_length_243_cov_0.917647_g12243_i0	PRJNA1180292	12375	243	0.917647	2.22988221	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	239	1.57e-58	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g12243	i0	84.362	53.2633744855967	243	38	100	0	1	243	308179	307937	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	12943	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21994590	21994590	PRJNA1180292_P_NODE_8618_length_252_cov_0.871508_g8486_i0	PRJNA1180292	8618	252	0.871508	2.19620016	Pirellulales bacterium	2715253	Bacteria	Bacteria	115	2.8700000000000003e-21	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g8486	i0	94.595	30.6388888888889	74	4	29	0	38	111	3518901	3518974	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	7721	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales 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);;