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

10 rows where analysis = "blastn", bioproject = "PRJNA637328" 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
1155175	1155175	PRJNA637328_P_NODE_6041_length_358_cov_2.271845_g5566_i0	PRJNA637328	6041	358	2.271845	8.1332051	root	1	Root_unresolved	Root_unresolved	187	8.909999999999998e-43	NTclustered	gi\|2916079367\|gb\|CP137543.1\|	83554	g5566	i0	90.714	76.3128491620112	140	13	80	0	1	140	469422	469561	Chlamydia psittaci strain LS-2203 chromosome, complete genome	blastn	27320	187	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
1155187	1155187	PRJNA637328_S_NODE_2401_length_209_cov_1.703488_g2324_i0	PRJNA637328	2401	209	1.703488	3.56028992	Gemmata	113	Bacteria	Bacteria	342	9.709999999999999e-90	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g2324	i0	96.172	115.851674641148	209	8	100	0	1	209	3635600	3635392	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	24213	342	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
3159934	3159934	PRJNA637328_P_NODE_16583_length_251_cov_4.024752_g16106_i0	PRJNA637328	16583	251	4.024752	10.10212752	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	250	7.52e-62	NTclustered	gi\|226525261\|gb\|FJ872372.1\|	156588	g16106	i0	85.366	205.179282868526	246	31	97	5	3	245	11978	11735	Uncultured Verrucomicrobia bacterium clone 106 genomic sequence	blastn	51500	250	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
4983402	4983402	PRJNA637328_S_NODE_3944_length_157_cov_0.975000_g3867_i0	PRJNA637328	3944	157	0.975	1.53075	Verrucomicrobiota	74201	Bacteria	Bacteria	276	7.06e-70	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g3867	i0	98.71	174.191082802548	155	2	99	0	1	155	5154276	5154430	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	27348	276	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
13363361	13363361	PRJNA637328_S_NODE_1931_length_244_cov_1.478261_g1854_i0	PRJNA637328	1931	244	1.478261	3.60695684	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	412	8.759999999999998e-111	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g1854	i0	97.131	40.844262295082	244	7	100	0	1	244	560096	559853	Gemmata sp. SH-PL17, complete genome	blastn	9966	412	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
14638120	14638120	PRJNA637328_S_NODE_1052_length_374_cov_2.192878_g975_i0	PRJNA637328	1052	374	2.192878	8.20136372	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	595	1.3099999999999996e-165	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g975	i0	95.676	604.545454545455	370	16	99	0	1	370	4959490	4959859	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	226100	595	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
15183599	15183599	PRJNA637328_S_NODE_1432_length_303_cov_2.101504_g1355_i0	PRJNA637328	1432	303	2.101504	6.36755712	Gemmataceae	1914233	Bacteria	Bacteria	433	8.63e-117	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g1355	i0	92.409	100.580858085809	303	23	100	0	1	303	1036166	1036468	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	30476	433	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
15183609	15183609	PRJNA637328_S_NODE_3552_length_166_cov_1.186047_g3475_i0	PRJNA637328	3552	166	1.186047	1.96883802	Gemmataceae	1914233	Bacteria	Bacteria	279	5.86e-71	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g3475	i0	96.988	91.1024096385542	166	5	100	0	1	166	3633871	3633706	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	15123	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
16457876	16457876	PRJNA637328_S_NODE_2653_length_197_cov_1.375000_g2576_i0	PRJNA637328	2653	197	1.375	2.70875	Gemmata	113	Bacteria	Bacteria	309	9.17e-80	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g2576	i0	94.924	207.832487309645	197	10	100	0	1	197	3633974	3634170	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	40943	309	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
22286036	22286036	PRJNA637328_P_NODE_12778_length_271_cov_1.256757_g12302_i0	PRJNA637328	12778	271	1.256757	3.40581147	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	233	8.27e-57	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g12302	i0	82.353	135.287822878229	272	44	99	4	2	271	792241	791972	Neochlamydia sp. S13 DNA, complete genome	blastn	36663	233	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13

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