metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA474426" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA474426" 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
2998203	2998203	PRJNA474426_P_NODE_23323_length_204_cov_1.148387_g23118_i0	PRJNA474426	23323	204	1.148387	2.34270948	Caulifigura coniformis	2527983	Bacteria	Bacteria	189	1.2999999999999996e-43	NTclustered	gi\|1712508784\|gb\|CP036271.1\|	2527983	g23118	i0	86.441	171.617647058824	177	19	86	5	1	175	2926760	2926933	Caulifigura coniformis strain Pan44 chromosome	blastn	35010	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Caulifigura	Caulifigura coniformis
4274549	4274549	PRJNA474426_P_NODE_9304_length_354_cov_1.177049_g9099_i0	PRJNA474426	9304	354	1.177049	4.16675346	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	302	3.01e-77	NTclustered	gi\|1958061316\|gb\|CP064987.1\|	2052180	g9099	i0	83.333	377.661016949153	348	36	97	16	12	354	2190485	2190815	Phycisphaerales bacterium isolate Fred_18-Q3-R57-64_MAXAC.330_cln chromosome, complete genome	blastn	133692	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
5551188	5551188	PRJNA474426_P_NODE_35105_length_164_cov_0.895652_g34900_i0	PRJNA474426	35105	164	0.895652	1.46886928	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	150	4.72e-32	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g34900	i0	84.416	2.14634146341463	154	22	93	2	12	164	3435553	3435705	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	352	150	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
6825091	6825091	PRJNA474426_P_NODE_30986_length_171_cov_2.975410_g30781_i0	PRJNA474426	30986	171	2.97541	5.0879511	Luteolibacter sp.	1962973	Bacteria	Bacteria	230	6.1599999999999985e-56	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g30781	i0	93.038	186.923976608187	158	10	92	1	10	166	1009920	1010077	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	31964	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
10651159	10651159	PRJNA474426_P_NODE_22409_length_209_cov_1.275000_g22204_i0	PRJNA474426	22409	209	1.275	2.66475	Luteolibacter sp.	1962973	Bacteria	Bacteria	291	3.57e-74	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g22204	i0	92.195	51.3875598086124	205	16	98	0	3	207	1010216	1010012	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	10740	291	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
14476078	14476078	PRJNA474426_P_NODE_32552_length_167_cov_1.669492_g32347_i0	PRJNA474426	32552	167	1.669492	2.78805164	Synoicihabitans lomoniglobus	2909285	Bacteria	Bacteria	63.9	6.47e-6	NTclustered	gi\|2452067159\|gb\|CP119075.1\|	2909285	g32347	i0	91.304	0.275449101796407	46	4	28	0	6	51	5494494	5494539	Synoicihabitans lomoniglobus strain LMO-M01 chromosome, complete genome	blastn	46	63.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
18299075	18299075	PRJNA474426_P_NODE_31815_length_169_cov_0.866667_g31610_i0	PRJNA474426	31815	169	0.866667	1.46466723	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	165	1.74e-36	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g31610	i0	92.982	24.1360946745562	114	7	67	1	13	125	27215	27328	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	4079	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
22123924	22123924	PRJNA474426_P_NODE_24318_length_198_cov_2.966443_g24113_i0	PRJNA474426	24318	198	2.966443	5.87355714	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2874254109\|emb\|OY970194.1\|	2813034	g24113	i0	100	0.151515151515152	30	0	15	0	82	111	1744381	1744352	MAG: Sedimentisphaerales bacterium isolate MFD00905.bin.c.1 genome assembly, chromosome: 1	blastn	30	56.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
23399800	23399800	PRJNA474426_P_NODE_5859_length_447_cov_1.841709_g5657_i0	PRJNA474426	5859	447	1.841709	8.23243923	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	303	1.08e-77	NTclustered	gi\|2874253690\|emb\|OY969416.1\|	412056	g5657	i0	79.101	1.3489932885906	445	89	99	4	3	445	1044900	1044458	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.1.157 genome assembly, chromosome: 1	blastn	603	303	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;