metadata: contig_metadata: 6 rows where bioproject = "PRJNA577580" and tax

6 rows where bioproject = "PRJNA577580" and tax_phylum = "Candidatus Latescibacterota"

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_species
4966263	4966263	PRJNA577580_P_NODE_1624_length_711_cov_2.467085_g1550_i0	PRJNA577580	1624	711	2.467085	17.54097435	Pseudomonadati	3379134	Bacteria	Bacteria	207	2.79e-58	NR	OQX85663.1	1970771	g1550	i0	51.6	12.42194092827	217	78	91.6	3	652	2	30	219	OQX85663.1 MAG: selenide, water dikinase SelD [Candidatus Latescibacteria bacterium 4484_7]	diamond	8832	209	0.990430622009569	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacteria bacterium 4484_7
26858528	26858528	PRJNA577580_P_NODE_10181_length_287_cov_2.289720_g10103_i0	PRJNA577580	10181	287	2.28972	6.5714964	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	89.7	1.88e-18	NR	MBS4016029.1	2053570	g10103	i0	44.4	1.93379790940767	90	50	94.1	0	9	278	150	239	MBS4016029.1 molybdopterin-dependent oxidoreductase [Candidatus Latescibacterota bacterium]	diamond	555	89.7	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota bacterium
29890276	29890276	PRJNA577580_P_NODE_31_length_2598_cov_32.195644_g23_i0	PRJNA577580	31	2598	32.195644	836.44283112	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	72	1.02e-8	NR	UCE01914.1	2053570	g23	i0	26.1	0.318706697459584	276	186	31.1	6	191	997	90	354	UCE01914.1 MAG: NF038122 family metalloprotease [Candidatus Latescibacterota bacterium]	diamond	828	72	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota bacterium
31407009	31407009	PRJNA577580_P_NODE_17136_length_227_cov_2.129870_g17058_i0	PRJNA577580	17136	227	2.12987	4.8348049	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	51.2	3.04e-5	NR	UCE02019.1	2053570	g17058	i0	34.2	1.00440528634361	76	49	99.1	1	3	227	93	168	UCE02019.1 MAG: hypothetical protein JSW67_12250 [Candidatus Latescibacterota bacterium]	diamond	228	51.2	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota bacterium
31976167	31976167	PRJNA577580_P_NODE_14598_length_249_cov_0.886364_g14520_i0	PRJNA577580	14598	249	0.886364	2.20704636	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	85.1	4.32e-17	NR	UCE02019.1	2053570	g14520	i0	48.8	2.96385542168675	82	37	98.8	1	247	2	199	275	UCE02019.1 MAG: hypothetical protein JSW67_12250 [Candidatus Latescibacterota bacterium]	diamond	738	85.1	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota bacterium
32577537	32577537	PRJNA577580_P_NODE_39_length_2508_cov_30.780287_g23_i1	PRJNA577580	39	2508	30.780287	771.96959796	Candidatus Latescibacterota bacterium	2053570	Bacteria	Bacteria	72	9.66e-9	NR	UCE01914.1	2053570	g23	i1	26.1	0.330143540669856	276	186	32.2	6	2318	1512	90	354	UCE01914.1 MAG: NF038122 family metalloprotease [Candidatus Latescibacterota bacterium]	diamond	828	72	1	Bacteria	FCB group	Pseudomonadati	Candidatus Latescibacterota	Candidatus Latescibacterota 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);;