metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA874604" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA874604" 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
2127071	2127071	PRJNA874604_P_NODE_35662_length_323_cov_1.232000_g35310_i0	PRJNA874604	35662	323	1.232	3.97936	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	409	1.56e-109	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g35310	i0	89.571	89.7244582043344	326	29	100	5	1	323	3832266	3832589	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	28981	409	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9779582	9779582	PRJNA874604_P_NODE_34828_length_326_cov_1.189723_g34476_i0	PRJNA874604	34828	326	1.189723	3.87849698	Anaerohalosphaeraceae bacterium	2873829	Bacteria	Bacteria	60.2	1.83e-4	NTclustered	gi\|2621717560\|emb\|OY775912.1\|	2873829	g34476	i0	92.857	5.66564417177914	42	2	13	1	199	239	901799	901840	MAG: Anaerohalosphaeraceae bacterium isolate 978f9c3d-91dc-4e11-95ec-8fa255ba7f00 genome assembly, chromosome: 1	blastn	1847	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales	Anaerohalosphaeraceae		Anaerohalosphaeraceae bacterium
12331616	12331616	PRJNA874604_P_NODE_75710_length_249_cov_0.875000_g75358_i0	PRJNA874604	75710	249	0.875	2.17875	Akkermansia muciniphila	239935	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g75358	i0	100	99.9518072289157	249	0	100	0	1	249	2158953	2159201	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	24888	460	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
17429670	17429670	PRJNA874604_P_NODE_20894_length_396_cov_2.993808_g20542_i0	PRJNA874604	20894	396	2.993808	11.85547968	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	453	8.89e-123	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g20542	i0	87.469	66.8181818181818	399	43	100	6	1	396	3833088	3833482	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	26460	453	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21254959	21254959	PRJNA874604_P_NODE_93737_length_243_cov_0.905882_g93385_i0	PRJNA874604	93737	243	0.905882	2.20129326	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	327	3.25e-85	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g93385	i0	90.947	1	243	22	100	0	1	243	3185334	3185576	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	243	327	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
23804221	23804221	PRJNA874604_P_NODE_50659_length_283_cov_1.209524_g50307_i0	PRJNA874604	50659	283	1.209524	3.42295292	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	468	2.19e-127	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g50307	i0	96.466	2.77031802120141	283	10	100	0	1	283	2345841	2346123	Luteolibacter sp. SL250 chromosome	blastn	784	468	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
25078133	25078133	PRJNA874604_P_NODE_53120_length_278_cov_1.502439_g52768_i0	PRJNA874604	53120	278	1.502439	4.17678042	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	411	3.659999999999999e-110	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g52768	i0	93.478	98.5575539568345	276	18	99	0	1	276	2676580	2676855	Opitutaceae bacterium TAV5, complete genome	blastn	27399	411	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
25079007	25079007	PRJNA874604_P_NODE_95420_length_242_cov_0.911243_g95068_i0	PRJNA874604	95420	242	0.911243	2.20520806	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	141	4.52e-29	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g95068	i0	78.205	9.27272727272727	234	42	94	8	12	239	3427749	3427519	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	2244	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae 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);;