metadata: contig_metadata: 10 rows where bioproject = "PRJEB673", tax_phylum = "Bdellovibrionota" and tax

10 rows where bioproject = "PRJEB673", tax_phylum = "Bdellovibrionota" and tax_superkingdom = "Bacteria"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
3960990	3960990	PRJEB673_P_NODE_11784_length_158_cov_1.813008_g11435_i0	PRJEB673	11784	158	1.813008	2.86455264	Peredibacter starrii	28202	Bacteria	Bacteria	267	4.2799999999999996e-67	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g11435	i0	98.052	3.8987341772151902	154	2	97	1	5	158	512335	512183	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	616	267	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
10337968	10337968	PRJEB673_P_NODE_4349_length_458_cov_2.449173_g4005_i0	PRJEB673	4349	458	2.449173	11.21721234	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	172	4.32e-52	NR	MCB0369869.1	2053517	g4005	i0	73.1	0.779475982532751	119	29	76	3	457	110	2	120	MCB0369869.1 uL15 family ribosomal protein [Bdellovibrionales bacterium]	diamond	357	172	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
12888519	12888519	PRJEB673_P_NODE_6011_length_358_cov_1.603715_g5662_i0	PRJEB673	6011	358	1.603715	5.7412997	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	96.3	3.06e-23	NR	MCB0369390.1	2053517	g5662	i0	71	1.50837988826816	62	16	50.3	1	191	12	34	95	MCB0369390.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	540	96.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
26653983	26653983	PRJEB673_P_NODE_9421_length_197_cov_1.975309_g9072_i0	PRJEB673	9421	197	1.975309	3.89135873	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	62	6.49e-10	NR	MCB0370127.1	2053517	g9072	i0	92.9	0.426395939086294	28	2	42.6	0	86	3	38	65	MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium]	diamond	84	62	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28013465	28013465	PRJEB673_P_NODE_12385_length_154_cov_1.336134_g12036_i0	PRJEB673	12385	154	1.336134	2.05764636	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	65.5	3.06e-12	NR	MCB0368228.1	2053517	g12036	i0	71.1	0.876623376623377	45	13	87.7	0	1	135	27	71	MCB0368228.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	135	65.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28013467	28013467	PRJEB673_P_NODE_2025_length_682_cov_9.432767_g1762_i0	PRJEB673	2025	682	9.432767	64.33147094	Bacteriovorax sp.	2608087	Bacteria	Bacteria	79.3	4.13e-14	NR	MBP9680184.1	2608087	g1762	i0	47.7	0.488269794721408	111	55	47.9	3	445	119	46	155	MBP9680184.1 hypothetical protein [Bacteriovorax sp.]	diamond	333	79.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Bacteriovorax	Bacteriovorax sp.
29086936	29086936	PRJEB673_P_NODE_11408_length_161_cov_2.190476_g11059_i0	PRJEB673	11408	161	2.190476	3.52666636	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	86.7	5.26e-20	NR	MCB0368309.1	2053517	g11059	i0	79.2	0.987577639751553	53	11	98.8	0	159	1	28	80	MCB0368309.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	159	86.7	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30027062	30027062	PRJEB673_P_NODE_11991_length_157_cov_1.098361_g11642_i0	PRJEB673	11991	157	1.098361	1.72442677	Pseudomonadati	3379134	Bacteria	Bacteria	64.3	8.13e-11	NR	PIP89989.1	1973930	g11642	i0	52	7.49044585987261	50	24	95.5	0	154	5	73	122	PIP89989.1 MAG: thioredoxin peroxidase [Bdellovibrionales bacterium CG22_combo_CG10-13_8_21_14_all_38_13]	diamond	1176	64.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium CG22_combo_CG10-13_8_21_14_all_38_13
30319037	30319037	PRJEB673_P_NODE_6112_length_354_cov_2.507837_g5763_i0	PRJEB673	6112	354	2.507837	8.87774298	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	102	6.19e-25	NR	MCB0370127.1	2053517	g5763	i0	82.8	0.491525423728814	58	10	49.2	0	62	235	30	87	MCB0370127.1 40S ribosomal protein S14 [Bdellovibrionales bacterium]	diamond	174	102	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
30697527	30697527	PRJEB673_P_NODE_4594_length_436_cov_1.855362_g4247_i0	PRJEB673	4594	436	1.855362	8.08937832	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	228	8.73e-74	NR	MCB0369646.1	2053517	g4247	i0	73.5	1.03899082568807	151	33	99.1	1	433	2	6	156	MCB0369646.1 50S ribosomal protein L22 [Bdellovibrionales bacterium]	diamond	453	228	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales 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);;