metadata: contig_metadata: 10 rows where bioproject = "PRJNA1200128" and tax

10 rows where bioproject = "PRJNA1200128" 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
9254953	9254953	PRJNA1200128_S_NODE_11748_length_240_cov_1.979695_g11639_i0	PRJNA1200128	11748	240	1.979695	4.751268	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	272	1.52e-68	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g11639	i0	88.696	456.216666666667	230	17	94	8	10	235	15746	15522	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	109492	272	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
11805689	11805689	PRJNA1200128_S_NODE_4250_length_335_cov_1.763699_g4141_i0	PRJNA1200128	4250	335	1.763699	5.90839165	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	490	5.65e-134	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g4141	i0	93.155	77.0179104477612	336	20	100	3	1	335	1405303	1404970	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	25801	490	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
14356130	14356130	PRJNA1200128_S_NODE_6312_length_292_cov_1.385542_g6203_i0	PRJNA1200128	6312	292	1.385542	4.04578264	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	198	3.28e-46	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g6203	i0	80.228	1.17808219178082	263	52	90	0	2	264	388424	388686	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	344	198	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
19453120	19453120	PRJNA1200128_S_NODE_25656_length_188_cov_1.751724_g25547_i0	PRJNA1200128	25656	188	1.751724	3.29324112	Nibricoccus sp. IMCC34717	3034021	Bacteria	Bacteria	326	8.6e-85	NTclustered	gi\|2850969968\|gb\|CP119759.1\|	3034021	g25547	i0	97.872	74.4840425531915	188	4	100	0	1	188	1405632	1405819	Nibricoccus sp. IMCC34717 chromosome, complete genome	blastn	14003	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus sp. IMCC34717
19453130	19453130	PRJNA1200128_S_NODE_26636_length_186_cov_1.160839_g26527_i0	PRJNA1200128	26636	186	1.160839	2.15916054	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	193	8.98e-45	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g26527	i0	85.561	363.60752688172	187	24	100	2	1	186	2749580	2749764	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	67631	193	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
27388830	27388830	PRJNA1200128_S_NODE_33103_length_173_cov_1.084615_g32994_i0	PRJNA1200128	33103	173	1.084615	1.87638395	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	40.8	0.0432	NR	PYL54605.1	2026799	g32994	i0	44.4	0.780346820809249	45	24	76.3	1	1	132	26	70	PYL54605.1 MAG: hypothetical protein DMF29_06015 [Verrucomicrobiota bacterium]	diamond	135	40.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
27514948	27514948	PRJNA1200128_S_NODE_28963_length_181_cov_1.021739_g28854_i0	PRJNA1200128	28963	181	1.021739	1.84934759	Pelagicoccus sp. SDUM812	2921790	Bacteria	Bacteria	42.7	0.0161	NR	WP_309019849.1	3041267	g28854	i0	39.2	0.845303867403315	51	31	84.5	0	6	158	34	84	WP_309019849.1 CehA/McbA family metallohydrolase [Pelagicoccus sp. SDUM812003]	diamond	153	42.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Pelagicoccaceae	Pelagicoccus	Pelagicoccus sp. SDUM812003
29914802	29914802	PRJNA1200128_S_NODE_8671_length_264_cov_7.723982_g8562_i0	PRJNA1200128	8671	264	7.723982	20.39131248	Opitutia bacterium	2026771	Bacteria	Bacteria	43.9	0.0189	NR	MBI5425267.1	2026771	g8562	i0	39.7	1.97727272727273	58	29	62.5	2	203	39	299	353	MBI5425267.1 glycoside hydrolase family 2 [Opitutia bacterium]	diamond	522	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium
31558159	31558159	PRJNA1200128_S_NODE_14656_length_224_cov_1.165746_g14547_i0	PRJNA1200128	14656	224	1.165746	2.61127104	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	42.4	0.0394	NR	MDX1951866.1	2026799	g14547	i0	34.8	0.616071428571429	46	30	61.6	0	148	11	226	271	MDX1951866.1 POTRA domain-containing protein [Verrucomicrobiota bacterium]	diamond	138	42.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
32570609	32570609	PRJNA1200128_S_NODE_8079_length_270_cov_3.070485_g7970_i0	PRJNA1200128	8079	270	3.070485	8.2903095	Prosthecobacter sp.	1965333	Bacteria	Bacteria	46.2	0.0031	NR	WP_395745445.1	1965333	g7970	i0	39.7	0.7	63	30	61.1	2	3	167	163	225	WP_395745445.1 O-antigen ligase family protein [Prosthecobacter sp.]	diamond	189	46.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter sp.

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