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

10 rows where bioproject = "PRJNA758087" and tax_phylum = "Bdellovibrionota"

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
21604902	21604902	PRJNA758087_P_NODE_27517_length_454_cov_1.414698_g26197_i0	PRJNA758087	27517	454	1.414698	6.42272892	Bdellovibrio	958	Bacteria	Bacteria	374	8.269999999999997e-99	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g26197	i0	83.659	179.055066079295	410	53	89	12	8	409	1676456	1676859	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	81291	374	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
24959928	24959928	PRJNA758087_P_NODE_25840_length_485_cov_16.114078_g24520_i0	PRJNA758087	25840	485	16.114078	78.1532783	Peredibacter starrii	28202	Bacteria	Bacteria	649	0	NTclustered	gi\|2631252187\|gb\|CP139487.1\|	28202	g24520	i0	92.208	98.779381443299	462	31	95	5	26	485	510684	511142	Peredibacter starrii strain A3.12 chromosome, complete genome	blastn	47908	649	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Bacteriovoracaceae	Peredibacter	Peredibacter starrii
26799726	26799726	PRJNA758087_P_NODE_27241_length_459_cov_1.901554_g25921_i0	PRJNA758087	27241	459	1.901554	8.72813286	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	191	1.64e-54	NR	PZP55309.1	349221	g25921	i0	67.2	0.875816993464052	134	44	87.6	0	50	451	453	586	PZP55309.1 MAG: DNA primase [Micavibrio aeruginosavorus]	diamond	402	191	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
26863456	26863456	PRJNA758087_P_NODE_26401_length_475_cov_2.378109_g25081_i0	PRJNA758087	26401	475	2.378109	11.29601775	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	79.3	1.28e-14	NR	HEX4924226.1	2053517	g25081	i0	33.1	1.86947368421053	148	97	93.5	1	446	3	30	175	HEX4924226.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	888	79.3	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales			Bdellovibrionales bacterium
28158631	28158631	PRJNA758087_P_NODE_26285_length_477_cov_2.014851_g24965_i0	PRJNA758087	26285	477	2.014851	9.61083927	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	119	1.06e-30	NR	HEY8278247.1	3034175	g24965	i0	64	0.628930817610063	100	35	62.3	1	447	151	45	144	HEY8278247.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	300	119	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
28284486	28284486	PRJNA758087_P_NODE_32946_length_365_cov_1.582192_g31626_i0	PRJNA758087	32946	365	1.582192	5.7750008	Pseudobdellovibrionaceae bacterium	2026715	Bacteria	Bacteria	213	9.69e-65	NR	NUM58482.1	2026715	g31626	i0	97.3	0.928767123287671	113	3	92.9	0	26	364	276	388	NUM58482.1 HAMP domain-containing histidine kinase [Pseudobdellovibrionaceae bacterium]	diamond	339	213	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae		Pseudobdellovibrionaceae bacterium
28821149	28821149	PRJNA758087_P_NODE_42708_length_246_cov_0.890173_g41388_i0	PRJNA758087	42708	246	0.890173	2.18982558	Micavibrio aeruginosavorus	349221	Bacteria	Bacteria	169	1.4599999999999997e-52	NR	PZP53409.1	349221	g41388	i0	100	0.963414634146341	79	0	96.3	0	246	10	46	124	PZP53409.1 MAG: hypothetical protein DI586_11075 [Micavibrio aeruginosavorus]	diamond	237	169	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Micavibrio	Micavibrio aeruginosavorus
29011280	29011280	PRJNA758087_P_NODE_33608_length_356_cov_1.137809_g32288_i0	PRJNA758087	33608	356	1.137809	4.05060004	Bdellovibrionota bacterium	3034175	Bacteria	Bacteria	91.7	6.73e-20	NR	MEK7355518.1	3034175	g32288	i0	52.5	1.34831460674157	80	38	67.4	0	355	116	47	126	MEK7355518.1 hypothetical protein [Bdellovibrionota bacterium]	diamond	480	91.7	1	Bacteria	Pseudomonadati	Bdellovibrionota					Bdellovibrionota bacterium
31126833	31126833	PRJNA758087_P_NODE_43715_length_241_cov_0.916667_g42395_i0	PRJNA758087	43715	241	0.916667	2.20916747	Bdellovibrio sp.	28201	Bacteria	Bacteria	141	3.169999999999999e-38	NR	MEN0057673.1	28201	g42395	i0	83.8	2.98755186721992	80	13	99.6	0	1	240	39	118	MEN0057673.1 MFS transporter [Bdellovibrio sp.]	diamond	720	141	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp.
31886174	31886174	PRJNA758087_P_NODE_21217_length_584_cov_17.729941_g19905_i0	PRJNA758087	21217	584	17.729941	103.54285544	Bdellovibrionales bacterium	2053517	Bacteria	Bacteria	69.3	1.3099999999999999e-10	NR	NUM88240.1	2053517	g19905	i0	61.8	0.282534246575342	55	21	28.3	0	222	58	1	55	NUM88240.1 hypothetical protein [Bdellovibrionales bacterium]	diamond	165	69.3	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);;