metadata: contig_metadata: 6 rows where analysis = "blastn", bioproject = "PRJNA382558" and tax

6 rows where analysis = "blastn", bioproject = "PRJNA382558" 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
8058232	8058232	PRJNA382558_S_NODE_487_length_377_cov_8.647059_g483_i0	PRJNA382558	487	377	8.647059	32.59941243	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	243	1.9900000000000002e-59	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g483	i0	79.101	2.04509283819629	378	59	98	16	10	377	3216806	3216439	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	771	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
9333069	9333069	PRJNA382558_S_NODE_7188_length_190_cov_9.124183_g7184_i0	PRJNA382558	7188	190	9.124183	17.3359477	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	122	1.2299999999999997e-23	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g7184	i0	82.27	2.06842105263158	141	25	74	0	50	190	4559686	4559546	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	393	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
11883437	11883437	PRJNA382558_S_NODE_10990_length_168_cov_5.160305_g10986_i0	PRJNA382558	10990	168	5.160305	8.6693124	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	102	1.38e-17	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g10986	i0	90.909	7.20238095238095	77	6	46	1	27	103	4278741	4278816	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	1210	102	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
13158636	13158636	PRJNA382558_S_NODE_3591_length_231_cov_6.432990_g3587_i0	PRJNA382558	3591	231	6.43299	14.8602069	Haloferula helveola	490095	Bacteria	Bacteria	100	7.27e-17	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g3587	i0	93.939	24.9264069264069	66	4	29	0	155	220	2865168	2865103	Haloferula helveola CN-1 DNA, complete genome	blastn	5758	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
20806381	20806381	PRJNA382558_S_NODE_12317_length_162_cov_6.552000_g12313_i0	PRJNA382558	12317	162	6.552	10.61424	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	176	7.67e-40	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g12313	i0	89.286	2.74691358024691	140	15	86	0	1	140	1538869	1538730	Lacunisphaera limnophila strain IG16b, complete genome	blastn	445	176	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
24631178	24631178	PRJNA382558_S_NODE_12280_length_162_cov_7.400000_g12276_i0	PRJNA382558	12280	162	7.4	11.988	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	117	4.71e-22	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g12276	i0	86.667	0.648148148148148	105	14	65	0	57	161	4544451	4544555	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	105	117	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;