metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA966993" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA966993" 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
942547	942547	PRJNA966993_P_NODE_91121_length_246_cov_0.890173_g90669_i0	PRJNA966993	91121	246	0.890173	2.18982558	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g90669	i0	94.286	0.142276422764228	35	2	14	0	81	115	2657668	2657634	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	35	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
6045768	6045768	PRJNA966993_P_NODE_85405_length_249_cov_1.721591_g84953_i0	PRJNA966993	85405	249	1.721591	4.28676159	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	449	6.840000000000001e-122	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g84953	i0	99.197	133.421686746988	249	2	100	0	1	249	1156967	1157215	Planctomyces sp. SH-PL62, complete genome	blastn	33222	449	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
6045865	6045865	PRJNA966993_P_NODE_94345_length_244_cov_0.900585_g93893_i0	PRJNA966993	94345	244	0.900585	2.1974274	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	255	1.5600000000000001e-63	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g93893	i0	86.066	106.450819672131	244	27	99	4	3	244	267395	267157	Tautonia plasticadhaerens strain ElP chromosome	blastn	25974	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
6369683	6369683	PRJNA966993_P_NODE_33465_length_369_cov_1.641892_g33013_i0	PRJNA966993	33465	369	1.641892	6.05858148	Engelhardtia	139931	Bacteria	Bacteria	56.5	0.003	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g33013	i0	97.059	0.184281842818428	34	0	9	1	103	135	4357935	4357902	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	68	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
7643657	7643657	PRJNA966993_P_NODE_65026_length_277_cov_2.122549_g64574_i0	PRJNA966993	65026	277	2.122549	5.87946073	root	1	Root_unresolved	Root_unresolved	337	6.28e-88	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g64574	i0	89.051	104.13357400722	274	26	98	4	1	272	2666212	2665941	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	28845	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11146061	11146061	PRJNA966993_P_NODE_70609_length_269_cov_1.571429_g70157_i0	PRJNA966993	70609	269	1.571429	4.22714401	Luteolibacter sp.	1962973	Bacteria	Bacteria	470	5.74e-128	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g70157	i0	98.141	282.230483271375	269	5	100	0	1	269	1008818	1009086	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	75920	470	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
12421318	12421318	PRJNA966993_P_NODE_48870_length_310_cov_2.383966_g48418_i0	PRJNA966993	48870	310	2.383966	7.3902946	Gimesia benthica	2608982	Bacteria	Bacteria	84.2	1.03e-11	NTclustered	gi\|1779265081\|gb\|CP043930.1\|	2608982	g48418	i0	96.078	6.97741935483871	51	2	16	0	21	71	2475025	2474975	Gimesia benthica strain E7 chromosome, complete genome	blastn	2163	84.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia benthica
12421553	12421553	PRJNA966993_P_NODE_75750_length_261_cov_1.638298_g75298_i0	PRJNA966993	75750	261	1.638298	4.27595778	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	339	1.63e-88	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g75298	i0	90.038	78.4750957854406	261	26	100	0	1	261	2582603	2582343	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	20482	339	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
12744917	12744917	PRJNA966993_P_NODE_73670_length_264_cov_2.874346_g73218_i0	PRJNA966993	73670	264	2.874346	7.58827344	Bacteria	2	Bacteria	Bacteria	442	1.2199999999999994e-119	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g73218	i0	96.958	141.17803030303	263	8	99	0	1	263	2582176	2581914	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	37271	444	0.995495495495496	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
14019377	14019377	PRJNA966993_P_NODE_42831_length_330_cov_0.898833_g42379_i0	PRJNA966993	42831	330	0.898833	2.9661489	Lacipirellula	2691417	Bacteria	Bacteria	359	1.63e-94	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g42379	i0	89.078	86.7969696969697	293	27	88	4	39	330	5162741	5163029	Lacipirellula parvula PX69 DNA, complete genome	blastn	28643	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
18794202	18794202	PRJNA966993_P_NODE_73835_length_264_cov_1.712042_g73383_i0	PRJNA966993	73835	264	1.712042	4.51979088	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	259	1.32e-64	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g73383	i0	85.328	100.659090909091	259	28	96	8	10	263	1866354	1866607	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	26574	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
18794300	18794300	PRJNA966993_P_NODE_84415_length_250_cov_0.870056_g83963_i0	PRJNA966993	84415	250	0.870056	2.17514	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	291	4.41e-74	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g83963	i0	87.649	39.072	251	29	100	2	1	250	2582901	2583150	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	9768	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20069161	20069161	PRJNA966993_P_NODE_7836_length_747_cov_3.649852_g7443_i0	PRJNA966993	7836	747	3.649852	27.26439444	uncultured Chlamydiales bacterium	174324	Bacteria	Bacteria	54.7	0.021	NTclustered	gi\|2874253712\|emb\|OY969554.1\|	174324	g7443	i0	100	0.0388219544846051	29	0	4	0	242	270	822713	822741	MAG: uncultured Chlamydiales bacterium isolate MFD04540.bin.c.3 genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured Chlamydiales bacterium
22619189	22619189	PRJNA966993_P_NODE_3398_length_1098_cov_3.043902_g3129_i0	PRJNA966993	3398	1098	3.043902	33.42204396	Gimesia aquarii	2527964	Bacteria	Bacteria	54.7	0.031	NTclustered	gi\|1712555625\|gb\|CP037920.1\|	2527964	g3129	i0	100	0.0264116575591985	29	0	3	0	705	733	4316952	4316980	Gimesia aquarii strain V144 chromosome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Gimesia	Gimesia aquarii

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