metadata: contig_metadata: 10 rows where bioproject = "PRJNA615351", tax_clade = "PVC group" and tax

10 rows where bioproject = "PRJNA615351", tax_clade = "PVC group" and tax_phylum = "Kiritimatiellota"

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_species
8249062	8249062	PRJNA615351_P_NODE_64207_length_554_cov_2.726397_g50645_i0	PRJNA615351	64207	554	2.726397	15.10423938	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	205	1.1e-60	NR	HMO04141.1	2212473	g50645	i0	62.3	8.18231046931408	151	56	81.8	1	2	454	179	328	HMO04141.1 putrescine aminotransferase [Kiritimatiellia bacterium]	diamond	4533	205	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
27143327	27143327	PRJNA615351_P_NODE_81102_length_418_cov_2.412533_g67057_i0	PRJNA615351	81102	418	2.412533	10.08438794	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	88.2	3.42e-17	NR	MFO7871627.1	2212473	g67057	i0	38.5	2.58373205741627	130	65	93.3	1	2	391	634	748	MFO7871627.1 adenylate/guanylate cyclase domain-containing protein [Kiritimatiellia bacterium]	diamond	1080	88.2	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
27586005	27586005	PRJNA615351_P_NODE_25224_length_1273_cov_2.190630_g16348_i1	PRJNA615351	25224	1273	2.19063	27.8867199	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	84.7	1.66e-13	NR	HNX33266.1	2212473	g16348	i1	29.2	0.612725844461901	260	148	58.2	11	962	222	84	320	HNX33266.1 protein kinase [Kiritimatiellia bacterium]	diamond	780	84.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
29354169	29354169	PRJNA615351_P_NODE_144349_length_199_cov_1.176829_g130249_i0	PRJNA615351	144349	199	1.176829	2.34188971	Pontiellaceae bacterium B12227	3035703	Bacteria	Bacteria	59.7	1.13e-8	NR	MDF7826225.1	3035703	g130249	i0	60.5	1.26633165829146	43	17	64.8	0	179	51	91	133	MDF7826225.1 thioredoxin family protein [Pontiellaceae bacterium B12227]	diamond	252	59.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Pontiellaceae	Pontiellaceae bacterium B12227
29669451	29669451	PRJNA615351_P_NODE_20910_length_1427_cov_18.638649_g6979_i6	PRJNA615351	20910	1427	18.638649	265.97352123	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	70.1	1.19e-8	NR	MDD3544736.1	2212473	g6979	i6	28.7	0.351086194814296	167	105	33.4	5	497	21	306	466	MDD3544736.1 VWA domain-containing protein [Kiritimatiellia bacterium]	diamond	501	70.1	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
30333578	30333578	PRJNA615351_P_NODE_134152_length_217_cov_1.912088_g120052_i0	PRJNA615351	134152	217	1.912088	4.14923096	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	114	1.38e-28	NR	MCZ7591080.1	2212473	g120052	i0	77.1	6.81566820276498	70	16	96.8	0	3	212	42	111	MCZ7591080.1 chorismate synthase [Kiritimatiellia bacterium]	diamond	1479	114	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
31104240	31104240	PRJNA615351_P_NODE_22535_length_1366_cov_3.781367_g2536_i2	PRJNA615351	22535	1366	3.781367	51.65347322	Pseudomonadati	3379134	Bacteria	Bacteria	118	3.7e-24	NR	MBQ9726210.1	2212473	g2536	i2	28.3	3.33601756954612	381	250	80.4	9	9	1106	94	466	MBQ9726210.1 ATP-dependent RNA helicase HrpA [Kiritimatiellia bacterium]	diamond	4557	118	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
31135654	31135654	PRJNA615351_P_NODE_146715_length_195_cov_1.475000_g132615_i0	PRJNA615351	146715	195	1.475	2.87625	Bacteria	2	Bacteria	Bacteria	45.8	0.00161	NR	MBN1673266.1	2212473	g132615	i0	34.5	2.73846153846154	58	38	89.2	0	176	3	832	889	MBN1673266.1 tetratricopeptide repeat protein [Kiritimatiellia bacterium]	diamond	534	46.2	0.991341991341991	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
31882020	31882020	PRJNA615351_P_NODE_40037_length_899_cov_3.721065_g29722_i0	PRJNA615351	40037	899	3.721065	33.45237435	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	52.4	0.00132	NR	MBQ7667048.1	2212473	g29722	i0	31.9	1.02113459399333	119	67	39.7	4	145	501	29	133	MBQ7667048.1 ankyrin repeat domain-containing protein [Kiritimatiellia bacterium]	diamond	918	52.4	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia bacterium
32198435	32198435	PRJNA615351_P_NODE_106438_length_292_cov_3.190661_g92339_i0	PRJNA615351	106438	292	3.190661	9.31673012	Kiritimatiellia bacterium	2212473	Bacteria	Bacteria	59.7	6.92e-8	NR	MBQ2281460.1	2212473	g92339	i0	61.7	12.1232876712329	47	18	48.3	0	143	3	2	48	MBQ2281460.1 ribosome biogenesis GTPase Der [Kiritimatiellia bacterium]	diamond	3540	59.7	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia			Kiritimatiellia 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);;