metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA453567" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA453567" 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
2992575	2992575	PRJNA453567_P_NODE_6563_length_388_cov_1.723647_g6327_i0	PRJNA453567	6563	388	1.723647	6.68775036	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	52.8	0.037	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g6327	i0	100	0.0721649484536082	28	0	7	0	81	108	6220670	6220697	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
5545505	5545505	PRJNA453567_P_NODE_16345_length_222_cov_1.475676_g16108_i0	PRJNA453567	16345	222	1.475676	3.27600072	Simkania negevensis	83561	Bacteria	Bacteria	147	8.78e-31	NTclustered	gi\|336481279\|emb\|FR872582.1\|	331113	g16108	i0	83.871	1.46846846846847	155	24	70	1	33	187	2204102	2204255	Simkania negevensis Z main chromosome, complete genome	blastn	326	147	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Simkania	Simkania negevensis
6819545	6819545	PRJNA453567_P_NODE_28966_length_163_cov_1.222222_g28729_i0	PRJNA453567	28966	163	1.222222	1.99222186	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	99	1.72e-16	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g28729	i0	83.186	64.7791411042945	113	13	67	6	4	113	4564802	4564911	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	10559	99	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8094934	8094934	PRJNA453567_P_NODE_19587_length_200_cov_1.435583_g19350_i0	PRJNA453567	19587	200	1.435583	2.871166	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	100	6.12e-17	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g19350	i0	88.095	34.79	84	10	42	0	101	184	1643070	1643153	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	6958	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
9369648	9369648	PRJNA453567_P_NODE_15388_length_230_cov_1.497409_g15151_i0	PRJNA453567	15388	230	1.497409	3.4440407	Aquisphaera giovannonii	406548	Bacteria	Bacteria	58.4	4.41e-4	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g15151	i0	100	0.260869565217391	31	0	13	0	77	107	9234949	9234919	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	60	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
11920695	11920695	PRJNA453567_P_NODE_410_length_1652_cov_3.380186_g373_i0	PRJNA453567	410	1652	3.380186	55.84067272	Urbifossiella limnaea	2528023	Bacteria	Bacteria	54.7	0.047	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g373	i0	100	0.0175544794188862	29	0	2	0	1480	1508	6801386	6801358	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
19567660	19567660	PRJNA453567_P_NODE_27376_length_167_cov_1.800000_g27139_i0	PRJNA453567	27376	167	1.8	3.006	Phycisphaeraceae bacterium D3-23	3004190	Bacteria	Bacteria	78.7	2.31e-10	NTclustered	gi\|2727577647\|gb\|CP114179.1\|	3004190	g27139	i0	86.301	0.437125748502994	73	8	43	2	1	72	1008727	1008798	Phycisphaeraceae bacterium D3-23 chromosome, complete genome	blastn	73	78.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium D3-23
20843473	20843473	PRJNA453567_P_NODE_16497_length_221_cov_1.271739_g16260_i0	PRJNA453567	16497	221	1.271739	2.81054319	Candidatus Rhabdochlamydia oedothoracis	2720720	Bacteria	Bacteria	78.7	3.23e-10	NTclustered	gi\|2076407543\|gb\|CP075587.1\|	2720720	g16260	i0	97.778	1.06334841628959	45	1	20	0	177	221	1696219	1696175	Candidatus Rhabdochlamydia oedothoracis isolate W744xW776 chromosome, complete genome	blastn	235	78.7	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Rhabdochlamydiaceae	Candidatus Rhabdochlamydia	Candidatus Rhabdochlamydia oedothoracis

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