metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA615175" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA615175" 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
595251	595251	PRJNA615175_P_NODE_7901_length_534_cov_3.631236_g7735_i0	PRJNA615175	7901	534	3.631236	19.39080024	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	492	2.61e-134	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g7735	i0	86.1	0.902621722846442	482	37	90	15	34	515	994018	993567	Luteolibacter sp. SL250 chromosome	blastn	482	492	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
1871074	1871074	PRJNA615175_P_NODE_32062_length_245_cov_1.343023_g31894_i0	PRJNA615175	32062	245	1.343023	3.29040635	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	222	1.59e-53	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g31894	i0	86.341	7.55918367346939	205	26	83	2	14	217	3822801	3823004	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	1852	222	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
4422328	4422328	PRJNA615175_P_NODE_13584_length_386_cov_1.476038_g13416_i0	PRJNA615175	13584	386	1.476038	5.69750668	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	305	2.56e-78	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g13416	i0	82.709	23.0077720207254	347	56	89	4	42	386	1498126	1498470	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	8881	305	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
6973169	6973169	PRJNA615175_P_NODE_11886_length_418_cov_2.602899_g11718_i0	PRJNA615175	11886	418	2.602899	10.88011782	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	534	3.279999999999999e-147	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g11718	i0	92.916	0.87799043062201	367	26	88	0	52	418	2425019	2425385	Luteolibacter sp. SL250 chromosome	blastn	367	534	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
8248306	8248306	PRJNA615175_P_NODE_36187_length_222_cov_4.590604_g36019_i0	PRJNA615175	36187	222	4.590604	10.19114088	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	272	1.3899999999999999e-68	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g36019	i0	89.041	0.986486486486487	219	24	99	0	1	219	1162069	1161851	Luteolibacter sp. SL250 chromosome	blastn	219	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
9523114	9523114	PRJNA615175_P_NODE_10828_length_443_cov_1.608108_g10660_i0	PRJNA615175	10828	443	1.608108	7.12391844	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	189	3.13e-43	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g10660	i0	83.582	0.45372460496614	201	33	45	0	1	201	1182189	1182389	Luteolibacter sp. SL250 chromosome	blastn	201	189	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
9523367	9523367	PRJNA615175_P_NODE_23788_length_280_cov_2.318841_g23620_i0	PRJNA615175	23788	280	2.318841	6.4927548	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	364	2.919999999999999e-96	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g23620	i0	89.831	139.864285714286	295	15	100	7	1	280	2621967	2621673	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	39162	364	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
9523677	9523677	PRJNA615175_P_NODE_9628_length_474_cov_8.940150_g9460_i0	PRJNA615175	9628	474	8.94015	42.376311	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	717	0	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g9460	i0	96.145	272.434599156118	441	13	93	4	1	440	1669	1232	Luteolibacter sp. SL250 chromosome	blastn	129134	717	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
10799034	10799034	PRJNA615175_P_NODE_14049_length_379_cov_3.179739_g13881_i0	PRJNA615175	14049	379	3.179739	12.05121081	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	549	1.0499999999999996e-151	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g13881	i0	92.857	86.4300791556728	378	27	99	0	1	378	7629890	7629513	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	32757	549	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata
13349040	13349040	PRJNA615175_P_NODE_20251_length_308_cov_2.400000_g20083_i0	PRJNA615175	20251	308	2.4	7.392	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	257	5.68e-64	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g20083	i0	82.623	50.7857142857143	305	40	97	12	9	307	1831543	1831246	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	15642	257	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
15897626	15897626	PRJNA615175_P_NODE_11953_length_417_cov_1.514535_g11785_i0	PRJNA615175	11953	417	1.514535	6.31561095	Verrucomicrobia bacterium IMCC26134	1637999	Bacteria	Bacteria	673	0	NTclustered	gi\|807238858\|gb\|CP011265.1\|	1637999	g11785	i0	95.714	93.0623501199041	420	15	100	2	1	417	1903891	1903472	Verrucomicrobia bacterium IMCC26134, complete genome	blastn	38807	673	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium IMCC26134
16452560	16452560	PRJNA615175_P_NODE_17813_length_331_cov_4.410853_g17645_i0	PRJNA615175	17813	331	4.410853	14.59992343	Gemmata	113	Bacteria	Bacteria	584	2.4899999999999985e-162	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g17645	i0	98.489	111.111782477341	331	5	100	0	1	331	2941848	2942178	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	36778	584	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
18446735	18446735	PRJNA615175_P_NODE_12155_length_412_cov_2.651917_g11987_i0	PRJNA615175	12155	412	2.651917	10.92589804	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	712	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g11987	i0	97.816	159.468446601942	412	9	100	0	1	412	265	676	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	65701	712	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
19721418	19721418	PRJNA615175_P_NODE_17436_length_335_cov_2.240458_g17268_i0	PRJNA615175	17436	335	2.240458	7.5055343	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	608	1.489999999999999e-169	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g17268	i0	99.403	281.137313432836	335	2	100	0	1	335	4718678	4719012	Luteolibacter sp. SL250 chromosome	blastn	94181	608	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
24821051	24821051	PRJNA615175_P_NODE_17420_length_335_cov_4.354962_g17252_i0	PRJNA615175	17420	335	4.3549620000000004	14.5891227	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	442	1.5999999999999994e-119	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g17252	i0	90.504	202.382089552239	337	29	100	2	1	335	7629543	7629208	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	67798	442	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata

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);;