metadata: contig_metadata: 19 rows where bioproject = "PRJDB9741" and tax

19 rows where bioproject = "PRJDB9741" and tax_phylum = "Verrucomicrobiota"

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
2560674	2560674	PRJDB9741_P_NODE_13803_length_189_cov_1.171429_g13486_i0	PRJDB9741	13803	189	1.171429	2.21400081	uncultured Spartobacteria bacterium	333969	Bacteria	Bacteria	263	6.879999999999999e-66	NTclustered	gi\|409969675\|gb\|JQ701281.1\|	333969	g13486	i0	92.896	96.010582010582	183	9	96	3	9	189	55	235	Uncultured Spartobacteria bacterium clone Flu3_11 16S ribosomal RNA gene, partial sequence	blastn	18146	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				uncultured Spartobacteria bacterium
2560889	2560889	PRJDB9741_P_NODE_4283_length_314_cov_3.509434_g3967_i0	PRJDB9741	4283	314	3.509434	11.01962276	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	390	5.479999999999999e-104	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g3967	i0	94.141	222.162420382166	256	15	82	0	2	257	1349	1094	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	69759	390	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
4809760	4809760	PRJDB9741_P_NODE_304_length_1585_cov_3.732422_g208_i0	PRJDB9741	304	1585	3.732422	59.1588887	Chthoniobacter sp.	2510640	Bacteria	Bacteria	844	2.88e-305	NR	MDR3405335.1	2510640	g208	i0	88.6	0.878233438485804	464	53	87.8	0	61	1452	1	464	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	1392	844	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
7359560	7359560	PRJDB9741_P_NODE_4406_length_309_cov_2.388462_g4090_i0	PRJDB9741	4406	309	2.388462	7.38034758	Prosthecobacter	48463	Bacteria	Bacteria	525	1.4099999999999995e-144	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g4090	i0	97.403	279.912621359223	308	8	99	0	2	309	1794	1487	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	86493	525	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
10213602	10213602	PRJDB9741_P_NODE_10829_length_200_cov_2.761589_g10512_i0	PRJDB9741	10829	200	2.761589	5.523178	Opitutales bacterium	2026772	Bacteria	Bacteria	174	3.55e-39	NTclustered	gi\|2814788334\|emb\|OY762281.2\|	2026772	g10512	i0	82.828	199.695	198	30	98	4	1	196	978371	978176	MAG: Opitutales bacterium isolate 685e4509-010e-4797-9872-a51ee4494a19 genome assembly, chromosome: 1	blastn	39939	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
10213759	10213759	PRJDB9741_P_NODE_34789_length_163_cov_2.456140_g34472_i0	PRJDB9741	34789	163	2.45614	4.0035082	Opitutales bacterium	2026772	Bacteria	Bacteria	183	4.62e-42	NTclustered	gi\|2814788334\|emb\|OY762281.2\|	2026772	g34472	i0	89.116	30.1411042944785	147	16	90	0	1	147	977994	978140	MAG: Opitutales bacterium isolate 685e4509-010e-4797-9872-a51ee4494a19 genome assembly, chromosome: 1	blastn	4913	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
11488912	11488912	PRJDB9741_P_NODE_3110_length_393_cov_3.011628_g2795_i0	PRJDB9741	3110	393	3.011628	11.83569804	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	204	9.809999999999999e-48	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g2795	i0	77.143	7.53180661577608	385	67	95	16	14	387	3920796	3921170	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	2960	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12764516	12764516	PRJDB9741_P_NODE_3191_length_386_cov_2.225519_g2876_i0	PRJDB9741	3191	386	2.225519	8.59050334	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	625	1.7299999999999996e-174	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g2876	i0	95.855	239.422279792746	386	16	100	0	1	386	575	190	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	92417	625	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
15313147	15313147	PRJDB9741_P_NODE_32013_length_165_cov_0.879310_g31696_i0	PRJDB9741	32013	165	0.87931	1.4508615	Luteolibacter sp.	1962973	Bacteria	Bacteria	278	2.09e-70	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g31696	i0	96.97	121.133333333333	165	5	100	0	1	165	1010102	1010266	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	19987	278	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
16284408	16284408	PRJDB9741_P_NODE_11473_length_198_cov_1.731544_g11156_i0	PRJDB9741	11473	198	1.731544	3.42845712	Verrucomicrobiota	74201	Bacteria	Bacteria	357	3.25e-94	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g11156	i0	99.49	110.560606060606	196	1	99	0	2	197	1547	1352	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	21891	359	0.994428969359331	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
19136508	19136508	PRJDB9741_P_NODE_36636_length_163_cov_0.842105_g36319_i0	PRJDB9741	36636	163	0.842105	1.37263115	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	230	5.8499999999999985e-56	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g36319	i0	92.638	117.319018404908	163	7	100	5	1	163	2167752	2167909	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	19123	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
27221947	27221947	PRJDB9741_P_NODE_20083_length_178_cov_1.193798_g19766_i0	PRJDB9741	20083	178	1.193798	2.12496044	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	62	2.42e-9	NR	HEV7404525.1	2811408	g19766	i0	55.2	0.97752808988764	58	26	97.8	0	176	3	586	643	HEV7404525.1 DUF1549 domain-containing protein [Chthoniobacteraceae bacterium]	diamond	174	62	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
27790797	27790797	PRJDB9741_P_NODE_26904_length_167_cov_2.050847_g26587_i0	PRJDB9741	26904	167	2.050847	3.42491449	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	51.6	9.9e-6	NR	MBK8092153.1	2026800	g26587	i0	87.1	0.55688622754491	31	4	55.7	0	75	167	630	660	MBK8092153.1 protein kinase [Verrucomicrobiaceae bacterium]	diamond	93	51.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
28864130	28864130	PRJDB9741_P_NODE_42428_length_154_cov_3.523810_g42111_i0	PRJDB9741	42428	154	3.52381	5.4266674	Opitutaceae bacterium	2006848	Bacteria	Bacteria	40.4	0.0342	NR	HEX3730387.1	2006848	g42111	i0	34.7	0.954545454545455	49	31	95.5	1	8	154	8	55	HEX3730387.1 hypothetical protein [Opitutaceae bacterium]	diamond	147	40.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29053760	29053760	PRJDB9741_P_NODE_13848_length_189_cov_1.107143_g13531_i0	PRJDB9741	13848	189	1.107143	2.09250027	Opitutus sp.	1913982	Bacteria	Bacteria	43.9	0.00709	NR	MBA3849253.1	1913982	g13531	i0	40.7	2.73015873015873	59	35	93.7	0	179	3	325	383	MBA3849253.1 sugar tyrosine-protein kinase [Opitutus sp.]	diamond	516	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp.
30506522	30506522	PRJDB9741_P_NODE_30553_length_166_cov_0.871795_g30236_i0	PRJDB9741	30553	166	0.871795	1.4471797	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	75.1	2.62e-14	NR	MEN9402104.1	2026799	g30236	i0	69.8	1.8433734939759	53	16	95.8	0	161	3	147	199	MEN9402104.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	306	75.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31169729	31169729	PRJDB9741_P_NODE_27595_length_167_cov_0.864407_g27278_i0	PRJDB9741	27595	167	0.864407	1.44355969	Opitutaceae bacterium	2006848	Bacteria	Bacteria	50.1	3.45e-5	NR	HUL54344.1	2006848	g27278	i0	70.4	0.48502994011976	27	8	48.5	0	85	165	8	34	HUL54344.1 phosphoenolpyruvate carboxykinase (GTP) [Opitutaceae bacterium]	diamond	81	50.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
32119056	32119056	PRJDB9741_P_NODE_19518_length_179_cov_1.176923_g19201_i0	PRJDB9741	19518	179	1.176923	2.10669217	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	92.4	1.34e-20	NR	HUR41831.1	2499141	g19201	i0	78	4.94413407821229	59	13	98.9	0	1	177	214	272	HUR41831.1 malate dehydrogenase [Verrucomicrobiia bacterium]	diamond	885	92.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia bacterium
32213926	32213926	PRJDB9741_P_NODE_25318_length_170_cov_1.247934_g25001_i0	PRJDB9741	25318	170	1.247934	2.1214878	Opitutaceae bacterium	2006848	Bacteria	Bacteria	87	3.41e-18	NR	MCE2862490.1	2006848	g25001	i0	69.8	2.82352941176471	53	16	93.5	0	6	164	242	294	MCE2862490.1 sialate O-acetylesterase [Opitutaceae bacterium]	diamond	480	87	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae 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);;