metadata: contig_metadata: 10 rows where bioproject = "PRJNA764222" and tax

10 rows where bioproject = "PRJNA764222" 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
3296074	3296074	PRJNA764222_S_NODE_3403_length_341_cov_2.258503_g3245_i0	PRJNA764222	3403	341	2.258503	7.70149523	Neochlamydia sp. S13	1353976	Bacteria	Bacteria	377	4.68e-100	NTclustered	gi\|1550189844\|dbj\|AP017977.1\|	1353976	g3245	i0	86.782	103.75366568915	348	34	100	11	1	341	791403	791745	Neochlamydia sp. S13 DNA, complete genome	blastn	35380	377	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia sp. S13
5848430	5848430	PRJNA764222_S_NODE_9385_length_267_cov_2.622727_g9227_i0	PRJNA764222	9385	267	2.622727	7.00268109	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	337	6.019999999999998e-88	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g9227	i0	90.038	73.2134831460674	261	24	98	2	7	267	1727723	1727981	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	19548	337	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
8398042	8398042	PRJNA764222_S_NODE_5347_length_305_cov_2.205426_g5189_i0	PRJNA764222	5347	305	2.205426	6.7265493	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	520	6.479999999999999e-143	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g5189	i0	97.386	157.462295081967	306	6	100	2	1	305	652829	653133	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	48026	520	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
16508602	16508602	PRJNA764222_S_NODE_11833_length_251_cov_1.250000_g11675_i0	PRJNA764222	11833	251	1.25	3.1375	Parachlamydia	83551	Bacteria	Bacteria	279	9.58e-71	NTclustered	gi\|470491594\|ref\|NR_077046.1\|	83552	g11675	i0	86.905	103.211155378486	252	29	99	3	1	250	272	23	Parachlamydia acanthamoebae strain UV-7 23S ribosomal RNA gene, complete sequence	blastn	25906	279	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Parachlamydia	Parachlamydia acanthamoebae
28095496	28095496	PRJNA764222_S_NODE_425_length_1042_cov_80.881407_g335_i0	PRJNA764222	425	1042	80.881407	842.78426094	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	56.2	5.95e-6	NR	MCK4994881.1	2035772	g335	i0	39.7	0.486564299424184	78	43	22.5	1	276	43	1	74	MCK4994881.1 serine--tRNA ligase [Candidatus Omnitrophota bacterium]	diamond	507	56.2	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
28663907	28663907	PRJNA764222_S_NODE_20067_length_209_cov_1.586420_g19909_i0	PRJNA764222	20067	209	1.58642	3.3156178	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0232	NR	MES2437692.1	2026799	g19909	i0	41.2	0.732057416267943	51	30	73.2	0	31	183	40	90	MES2437692.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	153	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29358535	29358535	PRJNA764222_S_NODE_11329_length_254_cov_1.826087_g11171_i0	PRJNA764222	11329	254	1.826087	4.63826098	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	178	7.979999999999998e-56	NR	MBR4257794.1	2212473	g11171	i0	100	0.992125984251969	84	0	99.2	0	3	254	28	111	MBR4257794.1 hypothetical protein [Kiritimatiellia bacterium]	diamond	252	178	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia				Kiritimatiellia bacterium
29421408	29421408	PRJNA764222_S_NODE_13949_length_239_cov_1.635417_g13791_i0	PRJNA764222	13949	239	1.635417	3.90864663	Planctomycetota bacterium	2026780	Bacteria	Bacteria	42.7	0.0339	NR	MFH1616428.1	2026780	g13791	i0	32.7	0.690376569037657	55	37	69	0	215	51	143	197	MFH1616428.1 uroporphyrinogen decarboxylase family protein [Planctomycetota bacterium]	diamond	165	42.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
29651844	29651844	PRJNA764222_S_NODE_9290_length_268_cov_1.859729_g9132_i0	PRJNA764222	9290	268	1.859729	4.98407372	Pseudomonadati	3379134	Bacteria	Bacteria	43.5	0.0262	NR	HKA06075.1	2052164	g9132	i0	50	0.805970149253731	42	18	43.7	1	14	130	214	255	HKA06075.1 aspartate aminotransferase family protein [Gemmataceae bacterium]	diamond	216	43.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
30916095	30916095	PRJNA764222_S_NODE_31954_length_163_cov_4.387931_g31796_i0	PRJNA764222	31954	163	4.387931	7.15232753	Pseudomonadati	3379134	Bacteria	Bacteria	75.9	1.3e-15	NR	MCD8349226.1	2026779	g31796	i0	80	5.79754601226994	45	9	82.8	0	27	161	1	45	MCD8349226.1 nitronate monooxygenase [Planctomycetaceae bacterium]	diamond	945	76.3	0.99475753604194	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae 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);;