metadata: contig_metadata: 7 rows where bioproject = "PRJEB25583" and tax

7 rows where bioproject = "PRJEB25583" 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
5125396	5125396	PRJEB25583_P_NODE_4705_length_189_cov_1.309211_g4528_i0	PRJEB25583	4705	189	1.309211	2.47440879	Tepidisphaeraceae bacterium	2876886	Bacteria	Bacteria	294	2.44e-75	NTclustered	gi\|2874253799\|emb\|OY969783.1\|	2876886	g4528	i0	94.709	164.486772486772	189	10	100	0	1	189	2502446	2502634	MAG: Tepidisphaeraceae bacterium isolate MFD04580.bin.c.1 genome assembly, chromosome: 1	blastn	31088	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae		Tepidisphaeraceae bacterium
8949966	8949966	PRJEB25583_P_NODE_1348_length_380_cov_2.763848_g1172_i0	PRJEB25583	1348	380	2.763848	10.5026224	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	571	2.2499999999999996e-158	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g1172	i0	93.75	156.302631578947	384	18	100	6	1	380	3832398	3832779	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	59395	571	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
10225773	10225773	PRJEB25583_P_NODE_7629_length_155_cov_1.669492_g7452_i0	PRJEB25583	7629	155	1.669492	2.5877126	Poriferisphaera corsica	2528020	Bacteria	Bacteria	165	1.57e-36	NTclustered	gi\|1712598971\|gb\|CP036425.1\|	2528020	g7452	i0	90.476	38.7612903225806	126	10	81	2	2	126	3163771	3163895	Poriferisphaera corsica strain KS4 chromosome, complete genome	blastn	6008	165	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Poriferisphaera	Poriferisphaera corsica
11189793	11189793	PRJEB25583_P_NODE_7389_length_157_cov_1.291667_g7212_i0	PRJEB25583	7389	157	1.291667	2.02791719	Isosphaera	127	Bacteria	Bacteria	163	5.74e-36	NTclustered	gi\|470487262\|ref\|NR_076810.1\|	128	g7212	i0	85.987	13.6687898089172	157	17	100	4	1	157	1242	1091	Isosphaera pallida strain IS1B 23S ribosomal RNA gene, complete sequence	blastn	2146	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera pallida
27254298	27254298	PRJEB25583_P_NODE_8143_length_152_cov_1.104348_g7966_i0	PRJEB25583	8143	152	1.104348	1.67860896	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	41.6	0.0273	NR	MBA3761743.1	2201154	g7966	i0	44.9	0.967105263157895	49	25	92.8	1	8	148	141	189	MBA3761743.1 hypothetical protein [Chthoniobacterales bacterium]	diamond	147	41.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
28321591	28321591	PRJEB25583_P_NODE_6266_length_167_cov_1.184615_g6089_i0	PRJEB25583	6266	167	1.184615	1.97830705	PVC group	1783257	Bacteria	Bacteria	95.9	1.66e-22	NR	NHZ84895.1	2052181	g6089	i0	72.2	2.89221556886228	54	15	97	0	166	5	103	156	NHZ84895.1 RNase H superfamily protein [Planctomycetia bacterium]	diamond	483	95.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
30222688	30222688	PRJEB25583_P_NODE_7832_length_154_cov_1.145299_g7655_i0	PRJEB25583	7832	154	1.145299	1.76376046	Verrucomicrobiota bacterium	2026799	Bacteria	Bacteria	85.5	3.53e-18	NR	MEI6194176.1	2026799	g7655	i0	80	0.974025974025974	50	10	97.4	0	152	3	267	316	MEI6194176.1 hypothetical protein [Verrucomicrobiota bacterium]	diamond	150	85.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota 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);;