metadata: contig_metadata: 12 rows where bioproject = "PRJNA811725" and tax

12 rows where bioproject = "PRJNA811725" 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
7188363	7188363	PRJNA811725_P_NODE_7366_length_542_cov_16.929638_g7124_i0	PRJNA811725	7366	542	16.929638	91.75863796	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	361	7.79e-95	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g7124	i0	80.625	0.885608856088561	480	81	87	8	60	533	6364637	6365110	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	480	361	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
8462977	8462977	PRJNA811725_P_NODE_27187_length_296_cov_2.869955_g26941_i0	PRJNA811725	27187	296	2.869955	8.4950668	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	78.6	7.4e-15	NR	MBA3314648.1	2026779	g26941	i0	79.6	0.496621621621622	49	10	49.7	0	295	149	243	291	MBA3314648.1 peptide chain release factor N(5)-glutamine methyltransferase [Planctomycetaceae bacterium]	diamond	147	78.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
11013854	11013854	PRJNA811725_P_NODE_23989_length_310_cov_3.691983_g23743_i0	PRJNA811725	23989	310	3.691983	11.4451473	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	106	2.19e-18	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g23743	i0	79.333	0.483870967741935	150	31	48	0	1	150	563494	563345	Luteolibacter sp. SL250 chromosome	blastn	150	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
13563447	13563447	PRJNA811725_P_NODE_1291_length_1104_cov_15.499515_g1165_i0	PRJNA811725	1291	1104	15.499515	171.1146456	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	362	9.069999999999997e-119	NR	MBC7851959.1	2699754	g1165	i0	93.4	0.983695652173913	181	12	49.2	0	1102	560	283	463	MBC7851959.1 lactate utilization protein [Pirellulaceae bacterium]	diamond	1086	362	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
22486803	22486803	PRJNA811725_P_NODE_24398_length_310_cov_2.717300_g24152_i0	PRJNA811725	24398	310	2.7173	8.42363	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	244	4.4499999999999996e-60	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g24152	i0	96.026	65.3806451612903	151	4	97	2	1	150	654719	654570	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	20268	244	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
23762525	23762525	PRJNA811725_P_NODE_26239_length_299_cov_3.725664_g25993_i0	PRJNA811725	26239	299	3.725664	11.13973536	Luteolibacter	518753	Bacteria	Bacteria	102	4.429999999999999e-23	NR	MEO8616039.1	1962973	g25993	i0	91.8	6.88294314381271	49	4	49.2	0	148	2	75	123	MEO8616039.1 thymidine phosphorylase [Luteolibacter sp.]	diamond	2058	103	0.990291262135922	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
27180441	27180441	PRJNA811725_P_NODE_1162_length_1151_cov_4.653061_g1046_i0	PRJNA811725	1162	1151	4.653061	53.55673211	Gemmataceae bacterium	2052164	Bacteria	Bacteria	342	9.05e-111	NR	HYV36243.1	2052164	g1046	i0	65.2	0.659426585577758	253	88	65.9	0	392	1150	1	253	HYV36243.1 efflux RND transporter permease subunit [Gemmataceae bacterium]	diamond	759	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
29075542	29075542	PRJNA811725_P_NODE_30088_length_284_cov_1.270142_g29842_i0	PRJNA811725	30088	284	1.270142	3.60720328	Luteolibacter flavescens	1859460	Bacteria	Bacteria	142	6e-37	NR	WP_264502298.1	1859460	g29842	i0	75.5	2.97887323943662	94	23	99.3	0	2	283	466	559	WP_264502298.1 ATP-binding protein [Luteolibacter flavescens]	diamond	846	142	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter flavescens
30212084	30212084	PRJNA811725_P_NODE_3252_length_774_cov_7.746077_g3045_i0	PRJNA811725	3252	774	7.746077	59.95463598	Gemmataceae bacterium	2052164	Bacteria	Bacteria	70.5	1.07e-9	NR	MFL5339594.1	2052164	g3045	i0	30.2	2.01162790697674	255	137	98.8	8	765	1	384	597	MFL5339594.1 WD40 repeat domain-containing protein [Gemmataceae bacterium]	diamond	1557	70.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30402273	30402273	PRJNA811725_P_NODE_8933_length_494_cov_4.707838_g8689_i0	PRJNA811725	8933	494	4.707838	23.25671972	Gemmataceae bacterium	2052164	Bacteria	Bacteria	239	5.21e-70	NR	HKI33594.1	2052164	g8689	i0	75.5	1.88259109311741	155	38	94.1	0	494	30	484	638	HKI33594.1 DUF3854 domain-containing protein [Gemmataceae bacterium]	diamond	930	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31128163	31128163	PRJNA811725_P_NODE_18755_length_350_cov_1.357401_g18509_i0	PRJNA811725	18755	350	1.357401	4.7509035	Gemmataceae bacterium	2052164	Bacteria	Bacteria	123	7.73e-30	NR	MFL5342006.1	2052164	g18509	i0	52.8	9.70285714285714	108	50	91.7	1	2	322	63	170	MFL5342006.1 protein kinase domain-containing protein [Gemmataceae bacterium]	diamond	3396	123	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
31159720	31159720	PRJNA811725_P_NODE_24295_length_310_cov_2.886076_g24049_i0	PRJNA811725	24295	310	2.886076	8.9468356	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	71.6	3.27e-12	NR	MCC6510033.1	2699754	g24049	i0	84.2	0.367741935483871	38	6	36.8	0	161	274	261	298	MCC6510033.1 dihydrodipicolinate synthase family protein [Pirellulaceae bacterium]	diamond	114	71.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae 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);;