metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA492363" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA492363" 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
25567331	25567331	PRJNA492363_S_NODE_96841_length_203_cov_1.352113_g96020_i0	PRJNA492363	96841	203	1.352113	2.74478939	Lacunisphaera limnophila	1838286	Bacteria	Bacteria	148	2.19e-31	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g96020	i0	80.402	1.98522167487685	199	35	97	4	7	203	1877719	1877523	Lacunisphaera limnophila strain IG16b, complete genome	blastn	403	148	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
25701844	25701844	PRJNA492363_S_NODE_11826_length_283_cov_1.441441_g11005_i0	PRJNA492363	11826	283	1.441441	4.07927803	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	215	3.15e-51	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g11005	i0	85.437	0.72791519434629	206	30	73	0	72	277	3013691	3013486	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	206	215	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25838842	25838842	PRJNA492363_S_NODE_61371_length_228_cov_1.682635_g60550_i0	PRJNA492363	61371	228	1.682635	3.8364078	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	217	6.81e-52	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g60550	i0	87.435	152.188596491228	191	20	83	4	40	228	418094	417906	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	34699	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
25839645	25839645	PRJNA492363_S_NODE_9963_length_305_cov_1.831967_g9142_i0	PRJNA492363	9963	305	1.831967	5.58749935	Candidatus Neptunochlamydia sp. REUL1	3064277	Bacteria	Bacteria	75	6.07e-9	NTclustered	gi\|2578658231\|emb\|OY735137.1\|	3064277	g9142	i0	86.567	0.219672131147541	67	9	22	0	12	78	217021	217087	Candidatus Neptunochlamydia sp. REUL1 isolate 46185 genome assembly, chromosome: 4	blastn	67	75	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Simkaniaceae	Candidatus Neptunichlamydia	Candidatus Neptunichlamydia sp. REUL1
25975610	25975610	PRJNA492363_S_NODE_89804_length_207_cov_0.876712_g88983_i0	PRJNA492363	89804	207	0.876712	1.81479384	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	222	1.3e-53	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g88983	i0	86.321	1.98067632850242	212	20	100	5	1	207	941098	940891	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	410	222	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
26033628	26033628	PRJNA492363_S_NODE_89788_length_207_cov_0.876712_g88967_i0	PRJNA492363	89788	207	0.876712	1.81479384	Opitutaceae	134623	Bacteria	Bacteria	217	6.07e-52	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g88967	i0	85.784	2.1207729468599	204	29	99	0	4	207	1053563	1053360	Lacunisphaera limnophila strain IG16b, complete genome	blastn	439	217	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila
26246335	26246335	PRJNA492363_S_NODE_11246_length_289_cov_1.320175_g10425_i0	PRJNA492363	11246	289	1.320175	3.81530575	Opitutaceae bacterium TAV5	794903	Bacteria	Bacteria	137	7.18e-28	NTclustered	gi\|573471959\|gb\|CP007053.1\|	794903	g10425	i0	83.333	0.692041522491349	150	23	51	1	142	289	3720636	3720487	Opitutaceae bacterium TAV5, complete genome	blastn	200	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium TAV5
26247044	26247044	PRJNA492363_S_NODE_44166_length_235_cov_1.471264_g43345_i0	PRJNA492363	44166	235	1.471264	3.4574704	Opitutus terrae PB9	107709	Bacteria	Bacteria	231	2.5199999999999997e-56	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g43345	i0	86.385	1.85957446808511	213	27	90	2	13	224	3854705	3854494	Opitutus terrae PB90-1, complete genome	blastn	437	231	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
26383915	26383915	PRJNA492363_S_NODE_99111_length_202_cov_0.907801_g98290_i0	PRJNA492363	99111	202	0.907801	1.83375802	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	174	3.6e-39	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g98290	i0	82.178	2.0049504950495	202	36	100	0	1	202	2011613	2011814	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	405	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
26441357	26441357	PRJNA492363_S_NODE_13175_length_272_cov_0.909953_g12354_i0	PRJNA492363	13175	272	0.909953	2.47507216	Gemmata	113	Bacteria	Bacteria	93.5	1.47e-14	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g12354	i0	82.857	1.15808823529412	105	16	38	2	169	272	5311307	5311410	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	315	93.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus

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