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

10 rows where bioproject = "PRJNA950981", 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
6366563	6366563	PRJNA950981_P_NODE_12465_length_291_cov_1.431193_g12289_i0	PRJNA950981	12465	291	1.431193	4.16477163	Pseudobdellovibrio	2862745	Bacteria	Bacteria	368	2.36e-97	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g12289	i0	89.619	143.604810996564	289	30	99	0	3	291	18	306	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	41789	368	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
11466286	11466286	PRJNA950981_P_NODE_3529_length_511_cov_1.805936_g3354_i0	PRJNA950981	3529	511	1.805936	9.22833296	Bdellovibrio	958	Bacteria	Bacteria	654	0	NTclustered	gi\|2800948966\|gb\|CP168973.1\|	959	g3354	i0	89.675	196.234833659491	523	40	100	10	1	511	1677606	1677086	Bdellovibrio bacteriovorus strain HK2 chromosome, complete genome	blastn	100276	660	0.990909090909091	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
17839908	17839908	PRJNA950981_P_NODE_14894_length_267_cov_1.608247_g14718_i0	PRJNA950981	14894	267	1.608247	4.29401949	Pseudobdellovibrio	2862745	Bacteria	Bacteria	159	1.4e-34	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g14718	i0	78.092	87.5505617977528	283	41	100	13	1	267	1377	1654	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	23376	159	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
20060507	20060507	PRJNA950981_P_NODE_19996_length_245_cov_1.813953_g19820_i0	PRJNA950981	19996	245	1.813953	4.44418485	Bdellovibrio sp. NC01	2220073	Bacteria	Bacteria	169	2.1e-37	NTclustered	gi\|1700686220\|gb\|CP030034.1\|	2220073	g19820	i0	79.92	87.6040816326531	249	34	95	7	13	245	861476	861724	Bdellovibrio sp. NC01 chromosome, complete genome	blastn	21463	169	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. NC01
22610820	22610820	PRJNA950981_P_NODE_12778_length_288_cov_0.851163_g12602_i0	PRJNA950981	12778	288	0.851163	2.45134944	Bdellovibrio sp. HCB337	3394358	Bacteria	Bacteria	344	3.929999999999999e-90	NTclustered	gi\|2895525383\|gb\|CP178621.1\|	3394358	g12602	i0	88.276	281.326388888889	290	30	100	4	1	288	3447719	3448006	Bdellovibrio sp. HCB337 chromosome, complete genome	blastn	81022	344	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio sp. HCB337
24214122	24214122	PRJNA950981_P_NODE_2719_length_579_cov_2.332016_g2546_i0	PRJNA950981	2719	579	2.332016	13.50237264	Pseudobdellovibrio	2862745	Bacteria	Bacteria	957	0	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g2546	i0	96.398	195.113989637306	583	17	100	2	1	579	504	1086	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	112971	957	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
24214129	24214129	PRJNA950981_P_NODE_9759_length_325_cov_1.210317_g9583_i0	PRJNA950981	9759	325	1.210317	3.93353025	Pseudobdellovibrio	2862745	Bacteria	Bacteria	448	3.3299999999999996e-121	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g9583	i0	91.489	106.504615384615	329	22	100	6	1	325	413	87	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	34614	448	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
25489042	25489042	PRJNA950981_P_NODE_3660_length_502_cov_1.794872_g3485_i0	PRJNA950981	3660	502	1.794872	9.01025744	Pseudobdellovibrio	2862745	Bacteria	Bacteria	811	0	NTclustered	gi\|507148233\|ref\|NR_103040.1\|	453816	g3485	i0	95.817	91.6653386454183	502	21	100	0	1	502	1724	1223	Bdellovibrio exovorus strain JSS 23S ribosomal RNA gene, complete sequence	blastn	46016	811	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Pseudobdellovibrio	Pseudobdellovibrio exovorus
26746855	26746855	PRJNA950981_P_NODE_21781_length_242_cov_0.923077_g21605_i0	PRJNA950981	21781	242	0.923077	2.23384634	Bdellovibrio	958	Bacteria	Bacteria	129	1.7e-32	NR	WP_063245168.1	959	g21605	i0	76.3	6.8801652892562	80	19	99.2	0	1	240	637	716	WP_063245168.1 type II secretion system secretin GspD [Bdellovibrio bacteriovorus]	diamond	1665	130	0.992307692307692	Bacteria	Pseudomonadati	Bdellovibrionota	Bdellovibrionia	Bdellovibrionales	Pseudobdellovibrionaceae	Bdellovibrio	Bdellovibrio bacteriovorus
31890394	31890394	PRJNA950981_P_NODE_20677_length_244_cov_0.912281_g20501_i0	PRJNA950981	20677	244	0.912281	2.22596564	Halobacteriovorax marinus	97084	Bacteria	Bacteria	60.5	1.85e-8	NR	WP_096909605.1	97084	g20501	i0	34.6	0.959016393442623	78	43	95.9	1	3	236	268	337	WP_096909605.1 lipoate--protein ligase [Halobacteriovorax marinus]	diamond	234	60.5	1	Bacteria	Pseudomonadati	Bdellovibrionota	Bacteriovoracia	Bacteriovoracales	Halobacteriovoraceae	Halobacteriovorax	Halobacteriovorax marinus

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