metadata: contig_metadata: 7 rows where bioproject = "PRJNA928559", tax_kingdom = "Bacillati" and tax

7 rows where bioproject = "PRJNA928559", tax_kingdom = "Bacillati" and tax_phylum = "Candidatus Melainabacteria"

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
11107312	11107312	PRJNA928559_P_NODE_227529_length_199_cov_11.261905_g225960_i0	PRJNA928559	227529	199	11.261905	22.41119095	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	353	4.23e-93	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g225960	i0	98.99	0.994974874371859	198	1	99	1	1	197	197662	197465	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	198	353	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
14006780	14006780	PRJNA928559_P_NODE_15811_length_786_cov_10.953717_g14434_i0	PRJNA928559	15811	786	10.953717	86.09621562	Bacteria	2	Bacteria	Bacteria	669	0	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g14434	i0	84.615	111.169211195929	689	88	86	16	97	773	597323	598005	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	87379	669	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
21304223	21304223	PRJNA928559_P_NODE_123197_length_320_cov_3.433198_g121628_i0	PRJNA928559	123197	320	3.433198	10.9862336	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	132	7.679999999999999e-37	NR	MBL8086285.1	2711154	g121628	i0	98.4	0.58125	62	1	58.1	0	133	318	1	62	MBL8086285.1 nicotinate-nucleotide adenylyltransferase [Candidatus Obscuribacter sp.]	diamond	186	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
25130861	25130861	PRJNA928559_P_NODE_9880_length_975_cov_2.968958_g8697_i0	PRJNA928559	9880	975	2.968958	28.9473405	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	636	2.1399999999999996e-177	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g8697	i0	78.942	911.541538461538	1002	162	100	44	1	975	597077	598056	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	888753	636	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria					Candidatus Melainabacteria bacterium
27467352	27467352	PRJNA928559_P_NODE_212203_length_243_cov_0.917647_g210634_i0	PRJNA928559	212203	243	0.917647	2.22988221	Candidatus Caenarcanales bacterium	2729995	Bacteria	Bacteria	108	5.06e-27	NR	MDX1920634.1	2729995	g210634	i0	74.2	0.814814814814815	66	17	81.5	0	242	45	87	152	MDX1920634.1 hypothetical protein [Candidatus Caenarcanales bacterium]	diamond	198	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Vampirovibriophyceae	Candidatus Caenarcanales			Candidatus Caenarcanales bacterium
30656657	30656657	PRJNA928559_P_NODE_158633_length_279_cov_1.344660_g157064_i0	PRJNA928559	158633	279	1.34466	3.7516014	Candidatus Obscuribacter sp.	2711154	Bacteria	Bacteria	77.4	2.81e-15	NR	MBL8086383.1	2711154	g157064	i0	74.5	0.505376344086022	47	12	50.5	0	276	136	98	144	MBL8086383.1 ankyrin repeat domain-containing protein [Candidatus Obscuribacter sp.]	diamond	141	77.4	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales	Candidatus Obscuribacteraceae	Candidatus Obscuribacter	Candidatus Obscuribacter sp.
32079503	32079503	PRJNA928559_P_NODE_199658_length_248_cov_0.891429_g198089_i0	PRJNA928559	199658	248	0.891429	2.21074392	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	123	1.2699999999999998e-31	NR	HEY9843761.1	2364082	g198089	i0	72.6	1.01612903225806	84	19	96.8	1	7	246	56	139	HEY9843761.1 hemolysin family protein [Candidatus Obscuribacterales bacterium]	diamond	252	123	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Obscuribacterales			Candidatus Obscuribacterales 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);;