metadata: contig_metadata: 8 rows where bioproject = "PRJNA493632", tax_clade = "PVC group" and tax

8 rows where bioproject = "PRJNA493632", tax_clade = "PVC group" and tax_phylum = "Lentisphaerota"

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_species
8756241	8756241	PRJNA493632_P_NODE_548227_length_248_cov_1.702857_g544788_i0	PRJNA493632	548227	248	1.702857	4.22308536	Bacteria	2	Bacteria	Bacteria	224	4.489999999999999e-54	NTclustered	gi\|1995790976\|gb\|CP071032.1\|	1932692	g544788	i0	83.267	76.491935483871	251	35	100	7	1	248	1586988	1587234	Lentisphaerae bacterium strain zth2 chromosome, complete genome	blastn	18970	224	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota bacterium
26760045	26760045	PRJNA493632_P_NODE_621061_length_243_cov_1.811765_g617620_i0	PRJNA493632	621061	243	1.811765	4.40258895	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	44.3	0.0106	NR	MBR4666996.1	2053569	g617620	i0	31.8	0.814814814814815	66	43	81.5	1	46	243	293	356	MBR4666996.1 hypothetical protein [Lentisphaeria bacterium]	diamond	198	44.3	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaeria bacterium
26981779	26981779	PRJNA493632_P_NODE_727582_length_203_cov_5.146154_g724139_i0	PRJNA493632	727582	203	5.146154	10.44669262	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	67	6.08e-11	NR	MDT8389325.1	2053569	g724139	i0	60.3	1.00492610837438	68	19	97.5	3	6	203	73	134	MDT8389325.1 DUF6288 domain-containing protein [Lentisphaeria bacterium]	diamond	204	67	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaeria bacterium
27424509	27424509	PRJNA493632_P_NODE_508063_length_251_cov_0.865169_g504624_i0	PRJNA493632	508063	251	0.865169	2.17157419	Lentisphaerae bacterium ADurb.Bin242	1852900	Bacteria	Bacteria	171	6.05e-48	NR	OQA78049.1	1852900	g504624	i0	91.6	0.99203187250996006	83	7	99.2	0	2	250	557	639	OQA78049.1 MAG: hypothetical protein BWY31_04398 [Lentisphaerae bacterium ADurb.Bin242]	diamond	249	171	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerae bacterium ADurb.Bin242
28339832	28339832	PRJNA493632_P_NODE_261066_length_310_cov_3.843882_g257630_i0	PRJNA493632	261066	310	3.843882	11.9160342	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	87	8.57e-20	NR	HQL09717.1	2053569	g257630	i0	83.9	0.541935483870968	56	2	47.4	1	149	3	3	58	HQL09717.1 hypothetical protein [Lentisphaeria bacterium]	diamond	168	87	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaeria bacterium
29034814	29034814	PRJNA493632_P_NODE_583268_length_246_cov_0.890173_g579827_i0	PRJNA493632	583268	246	0.890173	2.18982558	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	45.4	0.00427	NR	MEI6054638.1	1932692	g579827	i0	39.2	0.621951219512195	51	31	62.2	0	64	216	315	365	MEI6054638.1 radical SAM protein [Lentisphaerota bacterium]	diamond	153	45.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota bacterium
30929603	30929603	PRJNA493632_P_NODE_258014_length_310_cov_10.139241_g254578_i0	PRJNA493632	258014	310	10.139241	31.4316471	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	60.1	6.72e-8	NR	HAR66774.1	2053569	g254578	i0	54.2	2.08064516129032	59	26	57.1	1	2	178	656	713	HAR66774.1 hypothetical protein [Lentisphaeria bacterium]	diamond	645	60.1	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaeria bacterium
31308962	31308962	PRJNA493632_P_NODE_677015_length_235_cov_7.574074_g673574_i0	PRJNA493632	677015	235	7.574074	17.7990739	Lentisphaerota bacterium	1932692	Bacteria	Bacteria	40.4	0.0433	NR	NLC82030.1	1932692	g673574	i0	57.6	0.421276595744681	33	14	42.1	0	41	139	2	34	NLC82030.1 C4-dicarboxylate ABC transporter substrate-binding protein [Lentisphaerota bacterium]	diamond	99	40.4	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota		Lentisphaerota 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);;