metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA827593" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA827593" 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
821470	821470	PRJNA827593_P_NODE_50281_length_282_cov_1.473684_g49982_i0	PRJNA827593	50281	282	1.473684	4.15578888	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	134	9.03e-27	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g49982	i0	84.058	16.7836879432624	138	22	55	0	68	205	6895633	6895496	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	4733	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
821526	821526	PRJNA827593_P_NODE_53401_length_272_cov_1.547739_g53102_i0	PRJNA827593	53401	272	1.547739	4.20985008	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	75	5.3299999999999996e-9	NTclustered	gi\|2874254034\|emb\|OY970359.1\|	904075	g53102	i0	83.75	0.591911764705882	80	11	29	2	186	264	794316	794394	MAG: uncultured Phycisphaerales bacterium isolate MFD01231.bin.c.4 genome assembly, chromosome: 1	blastn	161	75	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
2096483	2096483	PRJNA827593_P_NODE_24402_length_425_cov_2.363636_g24103_i0	PRJNA827593	24402	425	2.363636	10.045453	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	248	4.87e-61	NTclustered	gi\|971149050\|emb\|LN879503.1\|	389348	g24103	i0	94.444	0.381176470588235	162	8	38	1	1	162	94791	94631	Protochlamydia naegleriophila genome assembly PNK1, plasmid : pPNK	blastn	162	248	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila
12300332	12300332	PRJNA827593_P_NODE_33450_length_355_cov_2.184397_g33151_i0	PRJNA827593	33450	355	2.184397	7.75460935	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	167	1.15e-36	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g33151	i0	96.078	0.287323943661972	102	4	29	0	254	355	360201	360302	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	102	167	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae bacterium
12300458	12300458	PRJNA827593_P_NODE_40190_length_320_cov_1.623482_g39891_i0	PRJNA827593	40190	320	1.623482	5.1951424	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	274	5.88e-69	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g39891	i0	84.926	2.646875	272	39	85	2	50	320	3177737	3177467	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	847	274	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
13574465	13574465	PRJNA827593_P_NODE_23291_length_437_cov_1.140110_g22992_i0	PRJNA827593	23291	437	1.14011	4.9822807	Urbifossiella limnaea	2528023	Bacteria	Bacteria	206	3.06e-48	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g22992	i0	79.139	46.9565217391304	302	59	69	3	123	422	7600705	7601004	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	20520	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
13574944	13574944	PRJNA827593_P_NODE_50511_length_281_cov_1.956731_g50212_i0	PRJNA827593	50511	281	1.956731	5.49841411	Congregicoccus parvus	3081749	Bacteria	Bacteria	182	3.17e-41	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g50212	i0	88.158	3.16370106761566	152	18	54	0	78	229	336856	337007	Opitutales bacterium ASA1 DNA, complete genome	blastn	889	182	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
14849013	14849013	PRJNA827593_P_NODE_25212_length_418_cov_1.101449_g24913_i0	PRJNA827593	25212	418	1.101449	4.60405682	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	106	3.04e-18	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g24913	i0	90.244	5.17942583732057	82	6	19	2	28	108	4740831	4740911	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	2165	106	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16124135	16124135	PRJNA827593_P_NODE_57773_length_260_cov_1.235294_g57474_i0	PRJNA827593	57773	260	1.235294	3.2117644	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	172	1.7399999999999999e-38	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g57474	i0	85.455	3.15769230769231	165	24	63	0	96	260	3073880	3074044	Gemmata sp. SH-PL17, complete genome	blastn	821	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
16531001	16531001	PRJNA827593_P_NODE_32493_length_361_cov_1.871528_g32194_i0	PRJNA827593	32493	361	1.871528	6.75621608	Luteolibacter	518753	Bacteria	Bacteria	111	5.57e-20	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g32194	i0	91.463	20.9058171745152	82	6	22	1	234	314	2178768	2178849	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	7547	111	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
17399547	17399547	PRJNA827593_P_NODE_39514_length_323_cov_1.460000_g39215_i0	PRJNA827593	39514	323	1.46	4.7158	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	254	7.75e-63	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g39215	i0	80.997	18.266253869969	321	59	99	2	3	322	670324	670643	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	5900	254	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
19947273	19947273	PRJNA827593_P_NODE_11276_length_656_cov_1.739280_g10984_i0	PRJNA827593	11276	656	1.73928	11.4096768	Urbifossiella limnaea	2528023	Bacteria	Bacteria	124	1.36e-23	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g10984	i0	76.623	2.16920731707317	231	51	35	3	181	409	881071	881300	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	1423	124	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
19948303	19948303	PRJNA827593_P_NODE_69096_length_233_cov_2.081250_g68797_i0	PRJNA827593	69096	233	2.08125	4.8493125	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	265	2.4599999999999996e-66	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g68797	i0	87.124	1.85407725321888	233	30	100	0	1	233	9638146	9637914	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	432	265	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
20354707	20354707	PRJNA827593_P_NODE_35676_length_343_cov_1.070370_g35377_i0	PRJNA827593	35676	343	1.07037	3.6713691	Gemmata	113	Bacteria	Bacteria	276	1.77e-69	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g35377	i0	83.224	38.1661807580175	304	47	88	4	1	302	8126520	8126821	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	13091	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
22498548	22498548	PRJNA827593_P_NODE_7138_length_840_cov_2.696219_g6869_i0	PRJNA827593	7138	840	2.696219	22.6482396	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	130	3.8e-25	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g6869	i0	91.667	10.422619047619	96	5	11	3	304	397	4024516	4024610	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	8755	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
25047536	25047536	PRJNA827593_P_NODE_38600_length_327_cov_2.232283_g38301_i0	PRJNA827593	38600	327	2.232283	7.29956541	Paludisphaera borealis	1387353	Bacteria	Bacteria	52.8	0.031	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g38301	i0	100	0.0856269113149847	28	0	9	0	234	261	2363907	2363934	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
25047929	25047929	PRJNA827593_P_NODE_61900_length_250_cov_0.870056_g61601_i0	PRJNA827593	61900	250	0.870056	2.17514	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	193	1.28e-44	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g61601	i0	82.791	3.78	215	37	90	0	31	245	2576843	2576629	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	945	193	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
25047959	25047959	PRJNA827593_P_NODE_63920_length_247_cov_0.885057_g63621_i0	PRJNA827593	63920	247	0.885057	2.18609079	Alienimonas californiensis	2527989	Bacteria	Bacteria	65.8	2.87e-6	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g63621	i0	85.714	135.056680161943	63	7	26	2	147	209	18503	18563	Alienimonas californiensis strain CA12 chromosome	blastn	33359	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis

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