metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA1195374" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA1195374" 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
322020	322020	PRJNA1195374_P_NODE_63561_length_270_cov_1.563452_g63217_i0	PRJNA1195374	63561	270	1.563452	4.2213204	Rohdeia mirabilis	2528008	Bacteria	Bacteria	211	3.86e-50	NTclustered	gi\|1712658140\|gb\|CP036290.1\|	2528008	g63217	i0	81.319	73.8592592592593	273	40	99	10	2	270	3049841	3050106	Planctomycetes bacterium Pla163 chromosome, complete genome	blastn	19942	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Rohdeia	Rohdeia mirabilis
2872597	2872597	PRJNA1195374_P_NODE_50383_length_310_cov_0.890295_g50039_i0	PRJNA1195374	50383	310	0.890295	2.7599145	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	52.8	0.029	NTclustered	gi\|1702190059\|gb\|CP030884.1\|	2026779	g50039	i0	100	0.0903225806451613	28	0	9	0	271	298	2714139	2714112	Planctomycetaceae bacterium isolate ECT2AJA-110-A chromosome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
7975303	7975303	PRJNA1195374_P_NODE_6007_length_864_cov_2.830594_g5729_i0	PRJNA1195374	6007	864	2.830594	24.45633216	Limnoglobus roseus	2598579	Bacteria	Bacteria	58.4	0.002	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g5729	i0	100	0.0358796296296296	31	0	4	0	778	808	7374488	7374518	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	31	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
9249361	9249361	PRJNA1195374_P_NODE_34768_length_382_cov_1.203883_g34424_i0	PRJNA1195374	34768	382	1.203883	4.59883306	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	65.8	4.68e-6	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g34424	i0	93.333	0.426701570680628	45	2	12	1	214	257	4350052	4350008	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	163	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
9249678	9249678	PRJNA1195374_P_NODE_5028_length_928_cov_3.557895_g4768_i0	PRJNA1195374	5028	928	3.557895	33.0172656	Planctomycetales bacterium ZRK34	2723666	Bacteria	Bacteria	54.7	0.026	NTclustered	gi\|1898316769\|gb\|CP050848.1\|	2723666	g4768	i0	100	0.03125	29	0	3	0	669	697	2922813	2922785	Planctomycetales bacterium ZRK34 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium ZRK34
11800477	11800477	PRJNA1195374_P_NODE_59110_length_282_cov_1.205742_g58766_i0	PRJNA1195374	59110	282	1.205742	3.40019244	Akkermansia glycaniphila	1679444	Bacteria	Bacteria	52.8	0.026	NTclustered	gi\|1093279401\|emb\|LT629973.1\|	1679444	g58766	i0	94.286	0.124113475177305	35	1	12	1	195	229	623048	623081	Akkermansia glycaniphila isolate APytT genome assembly, chromosome: I	blastn	35	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia glycaniphila
15624939	15624939	PRJNA1195374_P_NODE_69713_length_254_cov_0.972376_g69369_i0	PRJNA1195374	69713	254	0.972376	2.46983504	Candidatus Protochlamydia naegleriophila	389348	Bacteria	Bacteria	464	2.4999999999999994e-126	NTclustered	gi\|971146634\|emb\|LN879502.1\|	389348	g69369	i0	99.606	168.070866141732	254	1	100	0	1	254	1250011	1249758	Protochlamydia naegleriophila genome assembly PNK1, chromosome : cPNK	blastn	42690	464	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia naegleriophila

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