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

5 rows where analysis = "blastn", bioproject = "PRJNA1010662" 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
1429699	1429699	PRJNA1010662_P_NODE_4122_length_260_cov_1.213270_g4063_i0	PRJNA1010662	4122	260	1.21327	3.154502	Adhaeretor mobilis	1930276	Bacteria	Bacteria	52.8	0.024	NTclustered	gi\|1712449852\|gb\|CP036263.1\|	1930276	g4063	i0	100	0.107692307692308	28	0	11	0	22	49	3087871	3087844	Adhaeretor mobilis strain HG15A2 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Adhaeretor	Adhaeretor mobilis
1429761	1429761	PRJNA1010662_S_NODE_3602_length_180_cov_0.846715_g3557_i0	PRJNA1010662	3602	180	0.846715	1.524087	Fontisphaera persica	2974023	Bacteria	Bacteria	267	5.009999999999999e-67	NTclustered	gi\|2439237958\|gb\|CP116615.1\|	2974023	g3557	i0	93.785	23.15	177	11	98	0	1	177	3861699	3861875	Fontisphaera persica strain B-154 chromosome, complete genome	blastn	4167	267	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales	Fontisphaeraceae	Fontisphaera	Fontisphaera persica
2705243	2705243	PRJNA1010662_S_NODE_5443_length_151_cov_1.055556_g5398_i0	PRJNA1010662	5443	151	1.055556	1.59388956	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	183	4.19e-42	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g5398	i0	88.816	28.7549668874172	152	14	100	3	1	151	1156379	1156528	Planctomyces sp. SH-PL62, complete genome	blastn	4342	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
7379003	7379003	PRJNA1010662_P_NODE_10686_length_179_cov_2.376923_g10627_i0	PRJNA1010662	10686	179	2.376923	4.25469217	Engelhardtia	139931	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g10627	i0	97.059	0.379888268156425	34	0	18	1	108	140	4357935	4357902	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	68	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
12908541	12908541	PRJNA1010662_P_NODE_14031_length_166_cov_0.888889_g13972_i0	PRJNA1010662	14031	166	0.888889	1.47555574	Alienimonas californiensis	2527989	Bacteria	Bacteria	91.6	2.95e-14	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g13972	i0	96.364	19.2650602409639	55	2	33	0	5	59	3816827	3816881	Alienimonas californiensis strain CA12 chromosome	blastn	3198	91.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis

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