metadata: contig_metadata: 25 rows where bioproject = "PRJNA983838" and tax

25 rows where bioproject = "PRJNA983838" and tax_clade = "PVC group"

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
7343272	7343272	PRJNA983838_P_NODE_62626_length_360_cov_1.087108_g60259_i0	PRJNA983838	62626	360	1.087108	3.9135888	Luteolibacter luteus	2728835	Bacteria	Bacteria	654	0	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g60259	i0	99.444	194.488888888889	360	2	100	0	1	360	3804234	3803875	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	70016	654	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
7649378	7649378	PRJNA983838_P_NODE_118326_length_242_cov_1.597633_g115959_i0	PRJNA983838	118326	242	1.597633	3.86627186	Planctomycetia	203683	Bacteria	Bacteria	387	5.26e-103	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g115959	i0	95.473	223.268595041322	243	9	100	2	1	242	122392	122633	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	54031	387	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
10200119	10200119	PRJNA983838_P_NODE_98368_length_262_cov_2.523810_g96001_i0	PRJNA983838	98368	262	2.52381	6.6123822	Verrucomicrobiaceae	203557	Bacteria	Bacteria	481	2.57e-131	NTclustered	gi\|1969670428\|gb\|MW553372.1\|	670166	g96001	i0	100	100.797709923664	260	0	99	0	1	260	168	427	Uncultured Haloferula sp. clone 49 16S ribosomal RNA gene, partial sequence	blastn	26409	484	0.993801652892562	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	uncultured Haloferula sp.
11168012	11168012	PRJNA983838_P_NODE_105789_length_252_cov_0.871508_g103422_i0	PRJNA983838	105789	252	0.871508	2.19620016	Lacunisphaera sp.	1961806	Bacteria	Bacteria	122	2.8799999999999997e-30	NR	HEY0864123.1	1961806	g103422	i0	70.2	1.98809523809524	84	24	98.8	1	250	2	519	602	HEY0864123.1 CHASE3 domain-containing protein [Lacunisphaera sp.]	diamond	501	122	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera sp.
12443747	12443747	PRJNA983838_P_NODE_104370_length_253_cov_0.866667_g102003_i0	PRJNA983838	104370	253	0.866667	2.19266751	Gemmataceae bacterium	2052164	Bacteria	Bacteria	172	1.8099999999999994e-48	NR	MBX9626678.1	2052164	g102003	i0	100	0.99604743083004	84	0	99.6	0	1	252	93	176	MBX9626678.1 HDOD domain-containing protein [Gemmataceae bacterium]	diamond	252	172	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
17542738	17542738	PRJNA983838_P_NODE_119474_length_241_cov_2.315476_g117107_i0	PRJNA983838	119474	241	2.315476	5.58029716	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	418	1.8599999999999995e-112	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g117107	i0	97.925	289.141078838174	241	5	100	0	1	241	1320153	1319913	Luteolibacter sp. Populi chromosome, complete genome	blastn	69683	418	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
17543419	17543419	PRJNA983838_P_NODE_66254_length_344_cov_3.324723_g63887_i0	PRJNA983838	66254	344	3.324723	11.43704712	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	387	7.849999999999998e-103	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g63887	i0	87.834	162.607558139535	337	32	96	7	1	329	7050921	7050586	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	55937	387	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
17543719	17543719	PRJNA983838_P_NODE_84054_length_290_cov_1.437788_g81687_i0	PRJNA983838	84054	290	1.437788	4.1695852	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	353	6.57e-93	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g81687	i0	88.66	1.00344827586207	291	31	100	2	1	290	722518	722807	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	291	353	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
18817785	18817785	PRJNA983838_P_NODE_98735_length_262_cov_1.396825_g96368_i0	PRJNA983838	98735	262	1.396825	3.6596815	Luteolibacter	518753	Bacteria	Bacteria	128	4.219999999999999e-32	NR	MDP3851236.1	1962973	g96368	i0	90	6.46946564885496	70	7	80.2	0	260	51	828	897	MDP3851236.1 DEAD/DEAH box helicase [Luteolibacter sp.]	diamond	1695	129	0.992248062015504	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
21673701	21673701	PRJNA983838_P_NODE_118937_length_242_cov_0.923077_g116570_i0	PRJNA983838	118937	242	0.923077	2.23384634	Gemmataceae bacterium	2052164	Bacteria	Bacteria	147	4.24e-39	NR	MSR54156.1	2052164	g116570	i0	88.8	2.97520661157025	80	9	99.2	0	240	1	278	357	MSR54156.1 aconitate hydratase AcnA [Gemmataceae bacterium]	diamond	720	147	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
22643188	22643188	PRJNA983838_P_NODE_97638_length_264_cov_1.188482_g95271_i0	PRJNA983838	97638	264	1.188482	3.13759248	Akkermansia muciniphila	239935	Bacteria	Bacteria	477	3.359999999999999e-130	NTclustered	gi\|1554474302\|gb\|CP025823.1\|	239935	g95271	i0	99.242	91.9810606060606	264	2	100	0	1	264	785200	784937	Akkermansia muciniphila strain EB-AMDK-7 chromosome, complete genome	blastn	24283	477	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
27311060	27311060	PRJNA983838_P_NODE_80343_length_299_cov_2.022124_g77976_i0	PRJNA983838	80343	299	2.022124	6.04615076	Opitutaceae bacterium	2006848	Bacteria	Bacteria	85.9	1.48e-18	NR	HKB90181.1	2006848	g77976	i0	46.5	1.0133779264214	101	51	99.3	2	298	2	64	163	HKB90181.1 shikimate kinase [Opitutaceae bacterium]	diamond	303	85.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
28706254	28706254	PRJNA983838_P_NODE_90487_length_277_cov_1.348039_g88120_i0	PRJNA983838	90487	277	1.348039	3.73406803	Verrucomicrobiota	74201	Bacteria	Bacteria	162	8.04e-47	NR	MFA6544388.1	2052186	g88120	i0	82.4	2.95667870036101	91	16	98.6	0	275	3	84	174	MFA6544388.1 sialidase family protein [Limisphaerales bacterium]	diamond	819	163	0.993865030674847	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Limisphaerales			Limisphaerales bacterium
29868423	29868423	PRJNA983838_P_NODE_106071_length_252_cov_0.871508_g103704_i0	PRJNA983838	106071	252	0.871508	2.19620016	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	44.3	0.012	NR	MEW5895405.1	2035772	g103704	i0	31.3	0.988095238095238	83	50	90.5	1	238	11	1043	1125	MEW5895405.1 PAS domain-containing protein [Candidatus Omnitrophota bacterium]	diamond	249	44.3	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
30253784	30253784	PRJNA983838_P_NODE_85772_length_286_cov_2.159624_g83405_i0	PRJNA983838	85772	286	2.159624	6.17652464	Bacteria	2	Bacteria	Bacteria	111	5.880000000000001e-27	NR	MEM6568911.1	2026780	g83405	i0	54.7	14.8216783216783	95	43	99.7	0	285	1	211	305	MEM6568911.1 alkene reductase [Planctomycetota bacterium]	diamond	4239	112	0.991071428571429	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
30437356	30437356	PRJNA983838_P_NODE_100873_length_258_cov_2.108108_g98506_i0	PRJNA983838	100873	258	2.108108	5.43891864	Candidatus Omnitrophota bacterium	2035772	Bacteria	Bacteria	146	8.879999999999998e-43	NR	MBU3758371.1	2035772	g98506	i0	98.8	0.988372093023256	85	1	98.8	0	257	3	50	134	MBU3758371.1 dicarboxylate/amino acid:cation symporter [Candidatus Omnitrophota bacterium]	diamond	255	146	1	Bacteria	PVC group	Pseudomonadati	Candidatus Omnitrophota					Candidatus Omnitrophota bacterium
30753058	30753058	PRJNA983838_P_NODE_48354_length_443_cov_2.532432_g45988_i0	PRJNA983838	48354	443	2.532432	11.21867376	Planctomycetaceae bacterium	2026779	Bacteria	Bacteria	120	1.51e-28	NR	MCP4096080.1	2026779	g45988	i0	46.3	0.920993227990971	136	70	90.7	3	442	41	366	500	MCP4096080.1 hypothetical protein [Planctomycetaceae bacterium]	diamond	408	120	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		Planctomycetaceae bacterium
31005787	31005787	PRJNA983838_P_NODE_95314_length_268_cov_1.405128_g92947_i0	PRJNA983838	95314	268	1.405128	3.76574304	Planctomycetota bacterium	2026780	Bacteria	Bacteria	43.9	0.0193	NR	MBN8643811.1	2026780	g92947	i0	32.3	0.694029850746269	62	40	69.4	1	5	190	283	342	MBN8643811.1 radical SAM family heme chaperone HemW [Planctomycetota bacterium]	diamond	186	43.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetota bacterium
31226864	31226864	PRJNA983838_P_NODE_46555_length_457_cov_5.156250_g44189_i0	PRJNA983838	46555	457	5.15625	23.5640625	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	189	3.63e-56	NR	RYD65414.1	2026800	g44189	i0	80.4	0.702407002188184	107	21	70.2	0	2	322	230	336	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	321	189	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32080999	32080999	PRJNA983838_P_NODE_40178_length_517_cov_2.558559_g37817_i0	PRJNA983838	40178	517	2.558559	13.22775003	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	256	2.62e-82	NR	RYD81270.1	2026800	g37817	i0	71	0.940038684719536	162	47	94	0	511	26	177	338	RYD81270.1 MAG: hypothetical protein EOP84_11265, partial [Verrucomicrobiaceae bacterium]	diamond	486	256	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32176211	32176211	PRJNA983838_P_NODE_99898_length_260_cov_1.443850_g97531_i0	PRJNA983838	99898	260	1.44385	3.75401	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	137	2.46e-35	NR	RYD24189.1	2026800	g97531	i0	75.9	2.00769230769231	87	20	99.2	1	259	2	457	543	RYD24189.1 MAG: hypothetical protein EOP88_01205 [Verrucomicrobiaceae bacterium]	diamond	522	137	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32334487	32334487	PRJNA983838_P_NODE_72799_length_321_cov_3.346774_g70432_i0	PRJNA983838	72799	321	3.346774	10.74314454	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	145	3.749999999999999e-40	NR	RYD65414.1	2026800	g70432	i0	71	1	107	29	100	1	321	1	135	239	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	321	145	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32460884	32460884	PRJNA983838_P_NODE_56779_length_388_cov_2.434921_g54412_i0	PRJNA983838	56779	388	2.434921	9.44749348	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	139	4.87e-37	NR	RYD71398.1	2026800	g54412	i0	56.8	0.966494845360825	125	53	95.9	1	15	386	234	358	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	375	139	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
32681392	32681392	PRJNA983838_P_NODE_119460_length_241_cov_2.363095_g117093_i0	PRJNA983838	119460	241	2.363095	5.69505895	Phycisphaerales bacterium	2052180	Bacteria	Bacteria	47	0.00111	NR	HMN94906.1	2052180	g117093	i0	41.2	0.634854771784232	51	29	62.2	1	66	215	13	63	HMN94906.1 ABC transporter permease [Phycisphaerales bacterium]	diamond	153	47	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
32713097	32713097	PRJNA983838_P_NODE_70420_length_329_cov_4.214844_g68053_i0	PRJNA983838	70420	329	4.214844	13.86683676	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	94	3.9e-20	NR	RYD71398.1	2026800	g68053	i0	48.3	0.811550151975684	89	46	81.2	0	15	281	105	193	RYD71398.1 MAG: hypothetical protein EOP84_24945, partial [Verrucomicrobiaceae bacterium]	diamond	267	94	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae 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);;