metadata: contig_metadata: 14 rows where bioproject = "PRJEB673" and tax

14 rows where bioproject = "PRJEB673" 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
2684951	2684951	PRJEB673_P_NODE_10863_length_168_cov_1.203008_g10514_i0	PRJEB673	10863	168	1.203008	2.02105344	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	255	1e-63	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g10514	i0	94.083	158.380952380952	169	9	100	1	1	168	2003386	2003218	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	26608	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5237506	5237506	PRJEB673_P_NODE_9425_length_197_cov_1.716049_g9076_i0	PRJEB673	9425	197	1.716049	3.38061653	Gemmata massiliana	1210884	Bacteria	Bacteria	303	4.27e-78	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g9076	i0	94.416	34.1269035532995	197	11	100	0	1	197	3634990	3634794	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	6723	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
9062147	9062147	PRJEB673_P_NODE_1228_length_850_cov_8.323926_g1019_i0	PRJEB673	1228	850	8.323926	70.753371	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	1352	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g1019	i0	96.569	279.321176470588	816	28	96	0	1	816	4717234	4716419	Luteolibacter sp. SL250 chromosome	blastn	237423	1352	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
10337986	10337986	PRJEB673_P_NODE_6589_length_338_cov_2.917492_g6240_i0	PRJEB673	6589	338	2.917492	9.86112296	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	508	1.58e-139	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g6240	i0	93.787	102.062130177515	338	21	100	0	1	338	3261715	3261378	Luteolibacter sp. Populi chromosome, complete genome	blastn	34497	508	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
18846973	18846973	PRJEB673_P_NODE_5835_length_364_cov_5.939210_g5486_i0	PRJEB673	5835	364	5.93921	21.6187244	Verrucomicrobiales	48461	Bacteria	Bacteria	468	2.89e-127	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g5486	i0	91.74	392.796703296703	339	24	93	4	1	337	775555	775891	Haloferula helveola CN-1 DNA, complete genome	blastn	142978	470	0.995744680851064	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
27160256	27160256	PRJEB673_P_NODE_4862_length_415_cov_2.021053_g4514_i0	PRJEB673	4862	415	2.021053	8.38736995	Chlamydiales bacterium	2047757	Bacteria	Bacteria	231	1.23e-75	NR	MCP5470421.1	2047757	g4514	i0	81.5	0.975903614457831	135	25	97.6	0	413	9	24	158	MCP5470421.1 hypothetical protein [Chlamydiales bacterium]	diamond	405	231	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
27571201	27571201	PRJEB673_P_NODE_12104_length_156_cov_1.322314_g11755_i0	PRJEB673	12104	156	1.322314	2.06280984	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	60.5	6.49e-9	NR	MDH4372957.1	2026799	g11755	i0	54.9	0.980769230769231	51	23	98.1	0	156	4	552	602	MDH4372957.1 glycosyltransferase [Verrucomicrobiota bacterium]	diamond	153	60.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
30255612	30255612	PRJEB673_P_NODE_4912_length_412_cov_1.920424_g4564_i0	PRJEB673	4912	412	1.920424	7.91214688	Simkania sp.	34094	Bacteria	Bacteria	74.3	5.37e-13	NR	MCB1084310.1	34094	g4564	i0	57.9	0.41504854368932	57	24	41.5	0	410	240	114	170	MCB1084310.1 hypothetical protein [Simkania sp.]	diamond	171	74.3	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania sp.
30539614	30539614	PRJEB673_P_NODE_4733_length_425_cov_2.184615_g4385_i0	PRJEB673	4733	425	2.184615	9.28461375	Chlamydiales bacterium	2047757	Bacteria	Bacteria	159	8.089999999999999e-47	NR	MCP5470420.1	2047757	g4385	i0	75.2	0.910588235294118	129	30	91.1	1	423	37	29	155	MCP5470420.1 ribosomal protein L24e family protein [Chlamydiales bacterium]	diamond	387	159	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
31417369	31417369	PRJEB673_P_NODE_9216_length_206_cov_1.391813_g8867_i0	PRJEB673	9216	206	1.391813	2.86713478	Bacteria	2	Bacteria	Bacteria	55.5	7.25e-7	NR	HVS10494.1	2026780	g8867	i0	51	2.05339805825243	49	24	71.4	0	4	150	91	139	HVS10494.1 FKBP-type peptidyl-prolyl cis-trans isomerase [Planctomycetota bacterium]	diamond	423	55.8	0.99462365591397806	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31796733	31796733	PRJEB673_P_NODE_11317_length_162_cov_1.574803_g10968_i0	PRJEB673	11317	162	1.574803	2.55118086	Pseudomonadati	3379134	Bacteria	Bacteria	80.1	7.81e-16	NR	WP_146661715.1	1936003	g10968	i0	69.6	17.2037037037037	46	14	85.2	0	21	158	109	154	WP_146661715.1 adenosylhomocysteinase [Anaerohalosphaera lusitana]	diamond	2787	80.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Anaerohalosphaeraceae	Anaerohalosphaera	Anaerohalosphaera lusitana
31962250	31962250	PRJEB673_P_NODE_12418_length_154_cov_1.008403_g12069_i0	PRJEB673	12418	154	1.008403	1.55294062	Prosthecobacter sp.	1965333	Bacteria	Bacteria	79	1.22e-15	NR	WP_322282923.1	1965333	g12069	i0	75.5	5.68831168831169	49	12	95.5	0	3	149	265	313	WP_322282923.1 alkene reductase [Prosthecobacter sp.]	diamond	876	79	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.
32057191	32057191	PRJEB673_P_NODE_3698_length_518_cov_1.418219_g3371_i0	PRJEB673	3698	518	1.418219	7.34637442	Verrucomicrobiales bacterium	2026801	Bacteria	Bacteria	131	3.0999999999999996e-32	NR	MBL9134577.1	2026801	g3371	i0	76.5	4.22200772200772	81	19	46.9	0	274	516	363	443	MBL9134577.1 phosphoenolpyruvate carboxykinase (ATP) [Verrucomicrobiales bacterium]	diamond	2187	131	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			Verrucomicrobiales bacterium
32088822	32088822	PRJEB673_P_NODE_1118_length_885_cov_2.136471_g916_i0	PRJEB673	1118	885	2.136471	18.90776835	PVC group bacterium	2056642	Bacteria	Bacteria	63.2	1.16e-8	NR	MCP4648866.1	2056642	g916	i0	45	0.338983050847458	100	55	33.9	0	419	718	1	100	MCP4648866.1 hypothetical protein [PVC group bacterium]	diamond	300	63.2	1	Bacteria	PVC group	Pseudomonadati						PVC group 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);;