metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA816047" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA816047" 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
25728699	25728699	PRJNA816047a_S_NODE_33050_length_360_cov_1.153310_g30390_i0	PRJNA816047	33050	360	1.15331	4.151916	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	52.8	0.034	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g30390	i0	92.308	0.108333333333333	39	0	10	2	26	61	8434915	8434953	Planctomyces sp. SH-PL14, complete genome	blastn	39	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
25740677	25740677	PRJNA816047d_S_NODE_48114_length_317_cov_1.912879_g46279_i0	PRJNA816047	48114	317	1.912879	6.06382643	Thermoguttaceae bacterium	2691551	Bacteria	Bacteria	159	1.7e-34	NTclustered	gi\|2814788363\|emb\|OY780964.2\|	2691551	g46279	i0	85.35	11.8485804416404	157	19	49	4	4	158	1564587	1564741	MAG: Thermoguttaceae bacterium isolate 5d2646e0-01ad-46f9-a460-09296c79865c genome assembly, chromosome: 1	blastn	3756	159	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Thermoguttaceae		Thermoguttaceae bacterium
25742854	25742854	PRJNA816047d_S_NODE_94722_length_253_cov_2.720000_g92887_i0	PRJNA816047	94722	253	2.72	6.8816	Gemmataceae bacterium	2052164	Bacteria	Bacteria	158	4.729999999999999e-34	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g92887	i0	85.065	0.608695652173913	154	23	61	0	27	180	2929075	2929228	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	154	158	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
25866104	25866104	PRJNA816047a_S_NODE_51443_length_293_cov_1.172727_g48783_i0	PRJNA816047	51443	293	1.172727	3.43609011	Planctomycetales bacterium	2053591	Bacteria	Bacteria	52.8	0.027	NTclustered	gi\|2210174292\|gb\|CP060262.1\|	2053591	g48783	i0	100	0.0955631399317406	28	0	10	0	204	231	3594886	3594913	MAG: Planctomycetales bacterium isolate HK-STAS-UBP7_A-1 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales			Planctomycetales bacterium
25876115	25876115	PRJNA816047d_S_NODE_41491_length_336_cov_4.494700_g39656_i0	PRJNA816047	41491	336	4.4947	15.102192	Aureliella sp.	2795609	Bacteria	Bacteria	93.5	1.87e-14	NTclustered	gi\|2626244095\|emb\|OY829846.1\|	2795609	g39656	i0	96.429	19.2083333333333	56	2	17	0	156	211	5751578	5751523	MAG: Aureliella sp. isolate e39ea203-26a8-405f-9782-9267d5c1de48 genome assembly, chromosome: 1	blastn	6454	93.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
26143612	26143612	PRJNA816047b_S_NODE_39917_length_270_cov_1.558376_g37605_i0	PRJNA816047	39917	270	1.558376	4.2076152	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	156	1.83e-33	NTclustered	gi\|1927958621\|gb\|CP054186.1\|	2026777	g37605	i0	81.026	1.17037037037037	195	37	72	0	76	270	2457860	2457666	MAG: Phycisphaeraceae bacterium isolate H1_PLA1 chromosome	blastn	316	156	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
26150177	26150177	PRJNA816047d_S_NODE_69373_length_275_cov_2.774775_g67538_i0	PRJNA816047	69373	275	2.774775	7.63063125	Candidatus Organicella extenuata	2841811	Bacteria	Bacteria	93.5	1.49e-14	NTclustered	gi\|2569232906\|gb\|CP128385.1\|	2841811	g67538	i0	91.176	6.43272727272727	68	6	25	0	158	225	109047	109114	MAG: Candidatus Organicella extenuata isolate MAG_Ga0307966_1000010 chromosome, complete genome	blastn	1769	93.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota				Candidatus Organicella	Candidatus Organicella extenuata
26273883	26273883	PRJNA816047a_S_NODE_42478_length_320_cov_1.870445_g39818_i0	PRJNA816047	42478	320	1.870445	5.985424	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	156	2.22e-33	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g39818	i0	81.72	3.659375	186	34	58	0	1	186	3628622	3628807	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	1171	156	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26282504	26282504	PRJNA816047d_S_NODE_150310_length_215_cov_4.672840_g148475_i0	PRJNA816047	150310	215	4.67284	10.046606	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	62.1	3.15e-5	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g148475	i0	97.222	0.297674418604651	36	1	17	0	43	78	3380873	3380908	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	64	62.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
26421657	26421657	PRJNA816047d_S_NODE_62799_length_286_cov_2.553648_g60964_i0	PRJNA816047	62799	286	2.553648	7.30343328	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	193	1.49e-44	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g60964	i0	83.495	2.06993006993007	206	34	72	0	80	285	4560024	4559819	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	592	193	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
26553311	26553311	PRJNA816047d_S_NODE_104752_length_248_cov_0.994872_g102917_i0	PRJNA816047	104752	248	0.994872	2.46728256	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	174	4.59e-39	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g102917	i0	82.126	80.4838709677419	207	33	83	4	26	230	1816935	1816731	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	19960	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368

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