metadata: contig_metadata: 18 rows where bioproject = "PRJNA565778" and tax

18 rows where bioproject = "PRJNA565778" 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
1833779	1833779	PRJNA565778_S_NODE_33322_length_189_cov_5.421053_g33026_i0	PRJNA565778	33322	189	5.421053	10.24579017	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	67.6	5.79e-7	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g33026	i0	97.436	0.206349206349206	39	1	21	0	118	156	3833289	3833327	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	39	67.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
1833979	1833979	PRJNA565778_S_NODE_9882_length_345_cov_44.100649_g9586_i0	PRJNA565778	9882	345	44.100649	152.14723905	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	573	5.629999999999999e-159	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g9586	i0	100	0.898550724637681	310	0	90	0	36	345	1597045	1596736	Parachlamydia acanthamoebae UV-7, complete genome	blastn	310	573	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
4385605	4385605	PRJNA565778_S_NODE_15564_length_280_cov_4.777778_g15268_i0	PRJNA565778	15564	280	4.777778	13.3777784	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	195	4.05e-45	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g15268	i0	95.122	40.2142857142857	123	6	44	0	33	155	4040193	4040315	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	11260	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
6239403	6239403	PRJNA565778_S_NODE_4045_length_506_cov_7.268657_g3831_i0	PRJNA565778	4045	506	7.268657	36.77940442	Luteolibacter	518753	Bacteria	Bacteria	455	3.2300000000000004e-123	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g3831	i0	84.829	155.065217391304	468	54	91	14	26	486	276278	276735	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	78463	457	0.99562363238512	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
9486574	9486574	PRJNA565778_S_NODE_21128_length_240_cov_636.866995_g20832_i0	PRJNA565778	21128	240	636.866995	1528.480788	Pirellulales bacterium	2715253	Bacteria	Bacteria	193	1.22e-44	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g20832	i0	83.981	6.55416666666667	206	28	85	4	2	204	313048	312845	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	1573	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
14586938	14586938	PRJNA565778_S_NODE_16192_length_274_cov_388.755274_g15896_i0	PRJNA565778	16192	274	388.755274	1065.18945076	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	285	2.28e-72	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g15896	i0	90.654	324.667883211679	214	20	78	0	22	235	4958815	4958602	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	88959	285	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
19684965	19684965	PRJNA565778_S_NODE_6796_length_408_cov_2.908356_g6522_i0	PRJNA565778	6796	408	2.908356	11.86609248	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	702	0	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g6522	i0	100	0.931372549019608	380	0	93	0	1	380	1910955	1910576	Parachlamydia acanthamoebae UV-7, complete genome	blastn	380	702	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
23510527	23510527	PRJNA565778_S_NODE_16299_length_274_cov_2.303797_g16003_i0	PRJNA565778	16299	274	2.303797	6.31240378	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	496	9.67e-136	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g16003	i0	99.27	1	274	2	100	0	1	274	2776375	2776102	Parachlamydia acanthamoebae UV-7, complete genome	blastn	274	496	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
23510917	23510917	PRJNA565778_S_NODE_9039_length_359_cov_178.478261_g8743_i0	PRJNA565778	9039	359	178.478261	640.73695699	Parachlamydia acanthamoebae	83552	Bacteria	Bacteria	582	9.75e-162	NTclustered	gi\|336478352\|emb\|FR872580.1\|	765952	g8743	i0	99.074	0.902506963788301	324	3	90	0	36	359	2775805	2776128	Parachlamydia acanthamoebae UV-7, complete genome	blastn	324	582	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
27584980	27584980	PRJNA565778_S_NODE_25824_length_217_cov_37.061111_g25528_i0	PRJNA565778	25824	217	37.061111	80.42261087	Parachlamydia sp.	2052048	Bacteria	Bacteria	55.5	8.76e-7	NR	MCE5318139.1	2052048	g25528	i0	48.4	0.857142857142857	62	32	85.7	0	31	216	417	478	MCE5318139.1 ATP-binding protein [Parachlamydia sp.]	diamond	186	55.5	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia sp.
28703822	28703822	PRJNA565778_S_NODE_26267_length_215_cov_151.303371_g25971_i0	PRJNA565778	26267	215	151.303371	325.30224765	Pseudomonadati	3379134	Bacteria	Bacteria	43.9	0.00434	NR	MSU62638.1	2024890	g25971	i0	39.7	1.54883720930233	58	34	80.9	1	176	3	73	129	MSU62638.1 hypothetical protein [Pedosphaera sp.]	diamond	333	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera sp.
28879443	28879443	PRJNA565778_S_NODE_27628_length_210_cov_2.676301_g27332_i0	PRJNA565778	27628	210	2.676301	5.6202321	Planctomycetota bacterium	2026780	Bacteria	Bacteria	75.9	5.25e-14	NR	HRJ77648.1	2026780	g27332	i0	90.2	0.585714285714286	41	4	58.6	0	198	76	774	814	HRJ77648.1 protein DpdF [Planctomycetota bacterium]	diamond	123	75.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29826671	29826671	PRJNA565778_S_NODE_19691_length_249_cov_933.174528_g19395_i0	PRJNA565778	19691	249	933.174528	2323.60457472	Chlamydiales bacterium	2047757	Bacteria	Bacteria	87	3.68e-20	NR	MCE5293497.1	2047757	g19395	i0	52.1	0.879518072289157	73	32	84.3	1	211	2	21	93	MCE5293497.1 hypothetical protein [Chlamydiales bacterium]	diamond	219	87	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales bacterium
29858278	29858278	PRJNA565778_S_NODE_8591_length_368_cov_3.042296_g8295_i0	PRJNA565778	8591	368	3.042296	11.19564928	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	47.8	0.00213	NR	MBY0309332.1	2052180	g8295	i0	56.4	0.448369565217391	55	18	44	2	29	190	22	71	MBY0309332.1 ankyrin repeat domain-containing protein [Phycisphaerales bacterium]	diamond	165	47.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
30616510	30616510	PRJNA565778_S_NODE_13253_length_302_cov_4.328302_g12957_i0	PRJNA565778	13253	302	4.328302	13.07147204	Candidatus Auribacterota bacterium	2093365	Bacteria	Bacteria	73.2	8.7e-13	NR	MBN1521042.1	2093365	g12957	i0	64.3	0.556291390728477	56	19	55.6	1	170	3	1	55	MBN1521042.1 glycosyltransferase [Candidatus Auribacterota bacterium]	diamond	168	73.2	1	Bacteria	PVC group	Pseudomonadati	Candidatus Auribacterota					Candidatus Auribacterota bacterium
31090537	31090537	PRJNA565778_S_NODE_1035_length_835_cov_3.659148_g958_i0	PRJNA565778	1035	835	3.659148	30.5538858	Lentisphaeraceae bacterium	2461380	Bacteria	Bacteria	56.2	7.46e-5	NR	MCM8537330.1	2461380	g958	i0	32.2	1.27904191616766	121	76	42.4	3	357	4	3	120	MCM8537330.1 oligopeptidase A [Lentisphaeraceae bacterium]	diamond	1068	56.2	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae		Lentisphaeraceae bacterium
31862950	31862950	PRJNA565778_S_NODE_37357_length_177_cov_2.507143_g37061_i0	PRJNA565778	37357	177	2.507143	4.43764311	Bacteria	2	Bacteria	Bacteria	85.1	3.51e-19	NR	MCI0458091.1	2052164	g37061	i0	69.2	4.72881355932203	52	16	88.1	0	1	156	83	134	MCI0458091.1 class I SAM-dependent methyltransferase [Gemmataceae bacterium]	diamond	837	85.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
32387397	32387397	PRJNA565778_S_NODE_12719_length_308_cov_6.191882_g12423_i0	PRJNA565778	12719	308	6.191882	19.07099656	Chlamydiales bacterium	2047757	Bacteria	Bacteria	108	3.45e-28	NR	MCE5293497.1	2047757	g12423	i0	51.6	0.886363636363636	91	41	85.7	1	265	2	3	93	MCE5293497.1 hypothetical protein [Chlamydiales bacterium]	diamond	273	108	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			Chlamydiales 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);;