metadata: contig_metadata: 5 rows where bioproject = "PRJNA743294", tax_clade = "PVC group" and tax

5 rows where bioproject = "PRJNA743294", tax_clade = "PVC group" and tax_phylum = "Candidatus Omnitrophota"

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_genus	tax_species
29073921	29073921	PRJNA743294_P_NODE_56288_length_242_cov_0.923077_g55832_i0	PRJNA743294	56288	242	0.923077	2.23384634	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	43.9	0.0138	NR	MBD3296170.1	2035772	g55832	i0	45.3	0.65702479338843	53	20	58.3	3	100	240	84	133	MBD3296170.1 molecular chaperone DnaJ [Candidatus Omnitrophota bacterium]	diamond	159	43.9	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota		Candidatus Omnitrophota bacterium
29641685	29641685	PRJNA743294_P_NODE_1630_length_1110_cov_8.436837_g1378_i0	PRJNA743294	1630	1110	8.436837	93.6488907	Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_	2035772	Bacteria	Bacteria	211	2.02e-58	NR	PIQ88797.1	1974746	g1378	i0	47.3	0.651351351351351	241	123	64.3	2	3	716	322	561	PIQ88797.1 MAG: hypothetical protein COV72_05830 [Candidatus Omnitrophica bacterium CG11_big_fil_rev_8_21_14_0_20_42_13]	diamond	723	211	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota	Candidatus Ghiorseimicrobium	Candidatus Ghiorseimicrobium undicola
29863031	29863031	PRJNA743294_P_NODE_43091_length_260_cov_2.641711_g42635_i0	PRJNA743294	43091	260	2.641711	6.8684486	Omnitrophica WOR_2 bacterium RBG_13_41_1	2035772	Bacteria	Bacteria	50.8	4.97e-5	NR	OGX16586.1	1801849	g42635	i0	45.3	0.738461538461539	64	35	73.8	0	207	16	153	216	OGX16586.1 MAG: hypothetical protein A2166_01545 [Omnitrophica WOR_2 bacterium RBG_13_41_10]	diamond	192	50.8	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota		Omnitrophica WOR_2 bacterium RBG_13_41_10
30905870	30905870	PRJNA743294_P_NODE_58334_length_233_cov_2.987500_g57878_i0	PRJNA743294	58334	233	2.9875	6.960875	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	57.4	2.21e-7	NR	MSR78013.1	2035772	g57878	i0	59.5	0.476394849785408	37	15	47.6	0	231	121	416	452	MSR78013.1 phosphoenolpyruvate carboxykinase (ATP) [Candidatus Omnitrophota bacterium]	diamond	111	57.4	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota		Candidatus Omnitrophota bacterium
31411485	31411485	PRJNA743294_P_NODE_22396_length_345_cov_2.470588_g21940_i0	PRJNA743294	22396	345	2.470588	8.5235286	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	73.6	3.33e-14	NR	MBP7088093.1	2035772	g21940	i0	45.1	3.11304347826087	82	43	70.4	2	273	31	2	82	MBP7088093.1 RNA-binding protein [Candidatus Omnitrophota bacterium]	diamond	1074	73.6	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota		Candidatus Omnitrophota 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);;