metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA316313" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA316313" 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
8040081	8040081	PRJNA316313_P_NODE_254067_length_187_cov_2.806667_g252681_i0	PRJNA316313	254067	187	2.806667	5.24846729	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	130	7.19e-26	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g252681	i0	97.368	32.5187165775401	76	2	81	0	1	76	3522489	3522414	Luteolibacter sp. SL250 chromosome	blastn	6081	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
9314354	9314354	PRJNA316313_P_NODE_167928_length_187_cov_4.066667_g166542_i0	PRJNA316313	167928	187	4.066667	7.60466729	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	97.1	7.29e-16	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g166542	i0	92.537	1.62032085561497	67	5	36	0	10	76	2961205	2961139	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	303	97.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
10591020	10591020	PRJNA316313_P_NODE_334729_length_186_cov_2.644295_g333343_i0	PRJNA316313	334729	186	2.644295	4.9183887	Synoicihabitans lomoniglobus	2909285	Bacteria	Bacteria	65.8	2.04e-6	NTclustered	gi\|2452067159\|gb\|CP119075.1\|	2909285	g333343	i0	91.667	0.440860215053763	48	3	26	1	112	159	1797254	1797300	Synoicihabitans lomoniglobus strain LMO-M01 chromosome, complete genome	blastn	82	65.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Synoicihabitans	Synoicihabitans lomoniglobus
11864867	11864867	PRJNA316313_P_NODE_14210_length_445_cov_3.634804_g12890_i0	PRJNA316313	14210	445	3.634804	16.1748778	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	117	1.51e-21	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g12890	i0	85.714	0.339325842696629	112	14	25	2	335	445	1237639	1237749	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	151	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
12546136	12546136	PRJNA316313_P_NODE_231870_length_187_cov_3.033333_g230484_i0	PRJNA316313	231870	187	3.033333	5.67233271	Akkermansia	239934	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|2289586829\|dbj\|AP025943.1\|	2946555	g230484	i0	100	4.81283422459893	76	0	80	0	1	76	963281	963356	Akkermansia biwaensis WON2089 DNA, complete genome	blastn	900	141	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia biwaensis
15688934	15688934	PRJNA316313_P_NODE_148333_length_187_cov_4.766667_g146947_i0	PRJNA316313	148333	187	4.766667	8.91366729	Akkermansia muciniphila	239935	Bacteria	Bacteria	141	3.32e-29	NTclustered	gi\|2240218473\|gb\|CP097283.1\|	239935	g146947	i0	100	55.1122994652406	76	0	81	0	112	187	2563762	2563687	Akkermansia muciniphila strain NB2A-8-WC chromosome	blastn	10306	141	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
16964565	16964565	PRJNA316313_P_NODE_320234_length_187_cov_2.240000_g318848_i0	PRJNA316313	320234	187	2.24	4.1888	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	135	1.55e-27	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g318848	i0	98.684	0.812834224598931	76	1	81	0	1	76	3969647	3969722	Luteolibacter sp. SL250 chromosome	blastn	152	135	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
19513257	19513257	PRJNA316313_P_NODE_342316_length_183_cov_3.657534_g340930_i0	PRJNA316313	342316	183	3.657534	6.69328722	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	117	5.45e-22	NTclustered	gi\|2874254065\|emb\|OY970130.1\|	412056	g340930	i0	78.836	7.24590163934426	189	28	100	11	1	183	4707125	4707307	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05705.bin.c.1 genome assembly, chromosome: 1	blastn	1326	117	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
20788535	20788535	PRJNA316313_P_NODE_295217_length_187_cov_2.460000_g293831_i0	PRJNA316313	295217	187	2.46	4.6002	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g293831	i0	100	0.149732620320856	28	0	15	0	128	155	1465697	1465670	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22062598	22062598	PRJNA316313_P_NODE_130958_length_187_cov_6.620000_g129572_i0	PRJNA316313	130958	187	6.62	12.3794	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	52.8	0.016	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g129572	i0	100	0.149732620320856	28	0	15	0	38	65	2320361	2320388	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
23340576	23340576	PRJNA316313_P_NODE_87659_length_215_cov_4.522472_g86273_i0	PRJNA316313	87659	215	4.522472	9.7233148	Haloferula helveola	490095	Bacteria	Bacteria	100	6.67e-17	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g86273	i0	93.939	27.0744186046512	66	4	31	0	18	83	2865103	2865168	Haloferula helveola CN-1 DNA, complete genome	blastn	5821	100	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
24613349	24613349	PRJNA316313_P_NODE_318420_length_187_cov_2.266667_g317034_i0	PRJNA316313	318420	187	2.266667	4.23866729	Actomonas aquatica	2866162	Bacteria	Bacteria	60.2	9.57e-5	NTclustered	gi\|2647674565\|gb\|CP139781.1\|	2866162	g317034	i0	92.683	0.219251336898396	41	3	22	0	4	44	2831933	2831973	Actomonas aquatica strain WL0086 chromosome, complete genome	blastn	41	60.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Actomonas	Actomonas aquatica

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);;