metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA944150" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA944150" 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
923431	923431	PRJNA944150_P_NODE_12261_length_244_cov_1.928205_g12010_i0	PRJNA944150	12261	244	1.928205	4.7048202	Stratiformator vulcanicus	2527980	Bacteria	Bacteria	333	7.019999999999999e-87	NTclustered	gi\|1712491480\|gb\|CP036268.1\|	2527980	g12010	i0	91.393	166.446721311475	244	20	100	1	1	244	3082299	3082541	Stratiformator vulcanicus strain Pan189 chromosome	blastn	40613	333	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Stratiformator	Stratiformator vulcanicus
1259184	1259184	PRJNA944150_P_NODE_46581_length_157_cov_2.481481_g46330_i0	PRJNA944150	46581	157	2.481481	3.89592517	Planctomycetaceae	126	Bacteria	Bacteria	172	9.53e-39	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g46330	i0	87.097	241.56050955414	155	17	99	2	3	157	5362670	5362519	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	37925	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
2534714	2534714	PRJNA944150_P_NODE_18282_length_207_cov_1.291139_g18031_i0	PRJNA944150	18282	207	1.291139	2.67265773	Planctomycetia	203683	Bacteria	Bacteria	244	2.78e-60	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g18031	i0	87.923	110.990338164251	207	25	100	0	1	207	4955331	4955537	Planctomyces sp. SH-PL14, complete genome	blastn	22975	244	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
3474427	3474427	PRJNA944150_P_NODE_34243_length_169_cov_2.350000_g33992_i0	PRJNA944150	34243	169	2.35	3.9715	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	100	4.97e-17	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g33992	i0	80.62	0.763313609467456	129	25	76	0	41	169	6943234	6943362	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	129	100	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
7301577	7301577	PRJNA944150_P_NODE_19986_length_199_cov_2.806667_g19735_i0	PRJNA944150	19986	199	2.806667	5.58526733	Synoicihabitans lomoniglobus	2909285	Bacteria	Bacteria	126	1e-24	NTclustered	gi\|2452067159\|gb\|CP119075.1\|	2909285	g19735	i0	88.462	1.60301507537688	104	12	52	0	1	104	1273807	1273704	Synoicihabitans lomoniglobus strain LMO-M01 chromosome, complete genome	blastn	319	126	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
9851580	9851580	PRJNA944150_P_NODE_23728_length_189_cov_1.228571_g23477_i0	PRJNA944150	23728	189	1.228571	2.32199919	Congregicoccus parvus	3081749	Bacteria	Bacteria	322	1.12e-83	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g23477	i0	97.354	1	189	5	100	0	1	189	2913107	2913295	Opitutales bacterium ASA1 DNA, complete genome	blastn	189	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
11127413	11127413	PRJNA944150_P_NODE_46549_length_157_cov_2.648148_g46298_i0	PRJNA944150	46549	157	2.648148	4.15759236	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	239	9.26e-59	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g46298	i0	94.805	10.3885350318471	154	7	97	1	1	153	1832046	1831893	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	1631	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
12402671	12402671	PRJNA944150_P_NODE_18130_length_208_cov_1.100629_g17879_i0	PRJNA944150	18130	208	1.100629	2.28930832	Stieleria magnilauensis	2527963	Bacteria	Bacteria	52.8	0.018	NTclustered	gi\|1712780605\|gb\|CP036432.1\|	2527963	g17879	i0	100	0.134615384615385	28	0	13	0	34	61	6928282	6928309	Planctomycetes bacterium TBK1r chromosome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria magnilauensis
19110582	19110582	PRJNA944150_P_NODE_46115_length_159_cov_2.109091_g45864_i0	PRJNA944150	46115	159	2.109091	3.35345469	Botrimarina	2795782	Bacteria	Bacteria	202	1.2399999999999998e-47	NTclustered	gi\|1712768844\|gb\|CP036350.1\|	2527962	g45864	i0	89.809	1.9748427672956	157	16	99	0	3	159	751580	751424	Planctomycetes bacterium K2D chromosome, complete genome	blastn	314	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium K2D
20050371	20050371	PRJNA944150_P_NODE_42796_length_162_cov_1.911504_g42545_i0	PRJNA944150	42796	162	1.911504	3.09663648	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	217	4.5199999999999996e-52	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g42545	i0	90.798	5.04320987654321	163	13	100	2	1	162	1832215	1832054	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	817	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
21325556	21325556	PRJNA944150_P_NODE_12557_length_241_cov_1.062500_g12306_i0	PRJNA944150	12557	241	1.0625	2.560625	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	285	1.96e-72	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g12306	i0	88.211	9.53526970954357	246	20	100	9	1	241	2503337	2503578	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	2298	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae 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);;