metadata: contig_metadata: 7 rows where bioproject = "PRJNA565584", tax_clade = "PVC group" and tax

7 rows where bioproject = "PRJNA565584", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"

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_species
8210584	8210584	PRJNA565584_P_NODE_76487_length_340_cov_0.973783_g75336_i0	PRJNA565584	76487	340	0.973783	3.3108622	Kiritimatiellaceae bacterium	2026752	Bacteria	Bacteria	186	2.1499999999999994e-54	NR	NOU35501.1	2026752	g75336	i0	82.3	16.9323529411765	113	20	99.7	0	340	2	216	328	NOU35501.1 UDP-glucose 6-dehydrogenase [Kiritimatiellaceae bacterium]	diamond	5757	186	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiellaceae bacterium
20261795	20261795	PRJNA565584_P_NODE_63496_length_373_cov_0.786667_g62345_i0	PRJNA565584	63496	373	0.786667	2.93426791	Kiritimatiellales bacterium	2202731	Bacteria	Bacteria	201	3.5300000000000005e-58	NR	NNJ70716.1	2202731	g62345	i0	79	8.9597855227882	124	26	99.7	0	372	1	401	524	NNJ70716.1 NADP-dependent isocitrate dehydrogenase [Kiritimatiellales bacterium]	diamond	3342	201	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales		Kiritimatiellales bacterium
26858272	26858272	PRJNA565584_P_NODE_208741_length_242_cov_0.911243_g207589_i0	PRJNA565584	208741	242	0.911243	2.20520806	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	49.7	1.25e-4	NR	MBR4613355.1	2212473	g207589	i0	47.5	0.731404958677686	59	31	73.1	0	188	12	288	346	MBR4613355.1 sel1 repeat family protein [Kiritimatiellia bacterium]	diamond	177	49.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
26984404	26984404	PRJNA565584_P_NODE_177462_length_249_cov_0.875000_g176310_i0	PRJNA565584	177462	249	0.875	2.17875	Kiritimatiellaceae bacterium	2026752	Bacteria	Bacteria	50.8	5.33e-5	NR	MAS97467.1	2026752	g176310	i0	40.9	1.59036144578313	66	38	79.5	1	245	48	198	262	MAS97467.1 hypothetical protein [Kiritimatiellaceae bacterium]	diamond	396	50.8	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiellaceae bacterium
28027056	28027056	PRJNA565584_P_NODE_206065_length_243_cov_0.905882_g204913_i0	PRJNA565584	206065	243	0.905882	2.20129326	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	55.8	8.43e-7	NR	MFN2350331.1	2212473	g204913	i0	36.3	0.987654320987654	80	49	98.8	1	241	2	301	378	MFN2350331.1 Gfo/Idh/MocA family protein [Kiritimatiellia bacterium]	diamond	240	55.8	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
29953083	29953083	PRJNA565584_P_NODE_59911_length_384_cov_1.250804_g58760_i0	PRJNA565584	59911	384	1.250804	4.80308736	Kiritimatiellales bacterium	2202731	Bacteria	Bacteria	53.9	1.34e-5	NR	MCF7844224.1	2202731	g58760	i0	36.8	0.59375	76	46	57.8	1	6	227	160	235	MCF7844224.1 hypothetical protein [Kiritimatiellales bacterium]	diamond	228	53.9	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales		Kiritimatiellales bacterium
31975908	31975908	PRJNA565584_P_NODE_177898_length_249_cov_0.875000_g176746_i0	PRJNA565584	177898	249	0.875	2.17875	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	89.7	6.32e-19	NR	MBN1670383.1	2212473	g176746	i0	50.6	1.98795180722892	81	39	96.4	1	245	6	95	175	MBN1670383.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	495	89.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia 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);;