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

9 rows where analysis = "blastn", bioproject = "PRJEB83711" 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
144604	144604	PRJEB83711_P_NODE_71201_length_246_cov_0.901734_g70935_i0	PRJEB83711	71201	246	0.901734	2.21826564	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	207	4.48e-49	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g70935	i0	82.114	1	246	40	99	4	1	244	3080445	3080688	Luteolibacter sp. SL250 chromosome	blastn	246	207	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
2273517	2273517	PRJEB83711_P_NODE_11022_length_541_cov_8.166667_g10760_i0	PRJEB83711	11022	541	8.166667	44.18166847	Chlamydia	810	Bacteria	Bacteria	998	0	NTclustered	gi\|148537245\|dbj\|AB285329.1\|	83554	g10760	i0	100	99.6765249537893	540	0	99	0	1	540	212	751	Chlamydophila psittaci gene for 16S ribosomal RNA, partial sequence, strain: CPX0308	blastn	53925	998	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
7796345	7796345	PRJEB83711_P_NODE_38387_length_293_cov_1.995455_g38121_i0	PRJEB83711	38387	293	1.995455	5.84668315	Urbifossiella limnaea	2528023	Bacteria	Bacteria	191	5.52e-44	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g38121	i0	90.909	1.4778156996587	143	11	48	2	1	142	5053042	5052901	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	433	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
11202150	11202150	PRJEB83711_P_NODE_71909_length_245_cov_1.668605_g71643_i0	PRJEB83711	71909	245	1.668605	4.08808225	Chlamydia	810	Bacteria	Bacteria	438	1.45e-118	NTclustered	gi\|1796080642\|gb\|CP047319.1\|	83554	g71643	i0	100	93.7224489795918	237	0	97	0	1	237	473127	472891	Chlamydia psittaci strain AMK chromosome, complete genome	blastn	22962	438	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia psittaci
16301026	16301026	PRJEB83711_P_NODE_2093_length_1207_cov_7.482363_g1954_i0	PRJEB83711	2093	1207	7.482363	90.31212141	Chlamydia	810	Bacteria	Bacteria	2218	0	NTclustered	gi\|2414123899\|gb\|OQ058831.1\|	199738	g1954	i0	99.834	100.062966031483	1207	2	100	0	1	1207	1259	2465	Uncultured Chlamydia sp. clone 26-15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	120776	2224	0.997302158273381	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	uncultured Chlamydia sp.
19269932	19269932	PRJEB83711_P_NODE_61376_length_251_cov_0.876404_g61110_i0	PRJEB83711	61376	251	0.876404	2.19977404	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	363	9.249999999999997e-96	NTclustered	gi\|2076441902\|gb\|CP075368.1\|	2026777	g61110	i0	93.117	112.669322709163	247	17	98	0	1	247	2582756	2583002	MAG: Phycisphaeraceae bacterium isolate ACE_PLA2 chromosome	blastn	28280	363	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
20124947	20124947	PRJEB83711_P_NODE_20136_length_395_cov_0.801242_g19870_i0	PRJEB83711	20136	395	0.801242	3.1649059	Candidatus Protochlamydia	282132	Bacteria	Bacteria	531	3.9799999999999996e-146	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g19870	i0	90.977	110.906329113924	399	28	100	7	1	395	1253288	1252894	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	43808	536	0.990671641791045	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
20544386	20544386	PRJEB83711_P_NODE_13577_length_483_cov_1.860976_g13313_i0	PRJEB83711	13577	483	1.860976	8.98851408	Chlamydia poikilotherma	1967783	Bacteria	Bacteria	893	0	NTclustered	gi\|1450436528\|emb\|LS992154.1\|	1967783	g13313	i0	100	99.7184265010352	483	0	100	0	1	483	1005618	1005136	Chlamydia sp. S15-834C isolate S15-834K genome assembly, chromosome: I	blastn	48164	893	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	Chlamydia poikilotherma
21400792	21400792	PRJEB83711_P_NODE_44937_length_277_cov_1.892157_g44671_i0	PRJEB83711	44937	277	1.892157	5.24127489	Chlamydia	810	Bacteria	Bacteria	507	4.53e-139	NTclustered	gi\|2414123899\|gb\|OQ058831.1\|	199738	g44671	i0	99.639	100	277	1	100	0	1	277	2433	2709	Uncultured Chlamydia sp. clone 26-15 16S ribosomal RNA gene, partial sequence; 16S-23S ribosomal RNA intergenic spacer, complete sequence; and 23S ribosomal RNA gene, partial sequence	blastn	27700	507	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales	Chlamydiaceae	Chlamydia	uncultured Chlamydia sp.

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