metadata: contig_metadata: 12 rows where bioproject = "PRJNA603943", tax_clade = "PVC group" and tax

12 rows where bioproject = "PRJNA603943", tax_clade = "PVC group" 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
3127839	3127839	PRJNA603943_P_NODE_2843_length_856_cov_2.212005_g2686_i0	PRJNA603943	2843	856	2.212005	18.9347628	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	1003	0	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g2686	i0	88.098	171.394859813084	857	87	99	11	1	852	2582553	2581707	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	146714	1003	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
9506115	9506115	PRJNA603943_P_NODE_57828_length_248_cov_0.880000_g57636_i0	PRJNA603943	57828	248	0.88	2.1824	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	287	5.649999999999999e-73	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g57636	i0	87.805	1.58064516129032	246	28	99	2	1	245	156010	156254	Planctomyces sp. SH-PL62, complete genome	blastn	392	287	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
15879761	15879761	PRJNA603943_P_NODE_29173_length_332_cov_2.200772_g28981_i0	PRJNA603943	29173	332	2.200772	7.30656304	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	257	6.18e-64	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g28981	i0	80.938	62.0180722891566	341	51	100	13	1	332	193100	193435	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	20590	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
18429301	18429301	PRJNA603943_P_NODE_42975_length_282_cov_1.138756_g42783_i0	PRJNA603943	42975	282	1.138756	3.21129192	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	106	1.97e-18	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g42783	i0	96.825	4.9468085106383	63	2	23	0	3	65	485120	485182	Planctomyces sp. SH-PL62, complete genome	blastn	1395	106	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
18429873	18429873	PRJNA603943_P_NODE_61395_length_246_cov_0.890173_g61203_i0	PRJNA603943	61395	246	0.890173	2.18982558	uncultured Phycisphaerae bacterium	904963	Bacteria	Bacteria	94.7	2.01e-20	NR	CAA9414913.1	904963	g61203	i0	59.8	2	82	33	100	0	246	1	582	663	CAA9414913.1 MAG: hypothetical protein AVDCRST_MAG64-2540, partial [uncultured Phycisphaerae bacterium]	diamond	492	94.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				uncultured Phycisphaerae bacterium
26984992	26984992	PRJNA603943_P_NODE_69262_length_241_cov_0.916667_g69070_i0	PRJNA603943	69262	241	0.916667	2.20916747	Gemmataceae bacterium	2052164	Bacteria	Bacteria	109	1.94e-26	NR	MCX7700058.1	2052164	g69070	i0	82.3	0.771784232365145	62	10	77.2	1	187	2	1	61	MCX7700058.1 prepilin peptidase [Gemmataceae bacterium]	diamond	186	109	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
27219410	27219410	PRJNA603943_P_NODE_56742_length_249_cov_0.875000_g56550_i0	PRJNA603943	56742	249	0.875	2.17875	Pseudomonadati	3379134	Bacteria	Bacteria	63.9	9.39e-10	NR	MBK8915742.1	2052180	g56550	i0	50	3.7710843373494	78	33	86.7	3	219	4	79	156	MBK8915742.1 YkgJ family cysteine cluster protein [Phycisphaerales bacterium]	diamond	939	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
27964319	27964319	PRJNA603943_P_NODE_67705_length_242_cov_0.911243_g67513_i0	PRJNA603943	67705	242	0.911243	2.20520806	Planctomycetia bacterium	2052181	Bacteria	Bacteria	149	6.36e-41	NR	MBI2823964.1	2052181	g67513	i0	86.3	0.991735537190083	80	11	99.2	0	241	2	155	234	MBI2823964.1 Gfo/Idh/MocA family oxidoreductase [Planctomycetia bacterium]	diamond	240	149	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
28122254	28122254	PRJNA603943_P_NODE_69185_length_241_cov_1.267857_g68993_i0	PRJNA603943	69185	241	1.267857	3.05553537	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	45.1	0.00555	NR	MBL8759769.1	2026778	g68993	i0	38.7	0.771784232365145	62	33	71	2	173	3	1164	1225	MBL8759769.1 hypothetical protein [Phycisphaerae bacterium]	diamond	186	45.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae bacterium
29637423	29637423	PRJNA603943_P_NODE_65510_length_244_cov_0.900585_g65318_i0	PRJNA603943	65510	244	0.900585	2.1974274	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	71.6	2.54e-12	NR	MFM9961005.1	2026779	g65318	i0	51.9	2.84016393442623	81	38	99.6	1	2	244	212	291	MFM9961005.1 FHA domain-containing protein [Planctomycetaceae bacterium]	diamond	693	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
29890602	29890602	PRJNA603943_P_NODE_65351_length_244_cov_0.900585_g65159_i0	PRJNA603943	65351	244	0.900585	2.1974274	Gemmataceae bacterium	2052164	Bacteria	Bacteria	68.2	2.96e-11	NR	MCI0460996.1	2052164	g65159	i0	74.4	0.528688524590164	43	11	52.9	0	4	132	269	311	MCI0460996.1 DUF1559 domain-containing protein [Gemmataceae bacterium]	diamond	129	68.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30396355	30396355	PRJNA603943_P_NODE_14853_length_430_cov_1.711485_g14661_i0	PRJNA603943	14853	430	1.711485	7.3593855	Phycisphaerae bacterium	2026778	Bacteria	Bacteria	115	6.380000000000001e-27	NR	MFA6132497.1	2026778	g14661	i0	45.4	0.983720930232558	141	73	97.7	3	429	10	53	190	MFA6132497.1 AAA family ATPase [Phycisphaerae bacterium]	diamond	423	115	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae				Phycisphaerae 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);;