metadata: contig_metadata: 6 rows where bioproject = "PRJNA591127" and tax

6 rows where bioproject = "PRJNA591127" 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_order	tax_species
3116002	3116002	PRJNA591127_P_NODE_22903_length_182_cov_1.075862_g22734_i0	PRJNA591127	22903	182	1.075862	1.95806884	root	1	Root_unresolved	Root_unresolved	108	2.45e-28	NR	MBX9724270.1	2364082	g22734	i0	86.7	2.96703296703297	60	8	98.9	0	180	1	28	87	MBX9724270.1 50S ribosomal protein L15e [Candidatus Obscuribacterales bacterium]	diamond	540	108	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
10769360	10769360	PRJNA591127_P_NODE_2629_length_436_cov_3.731830_g2463_i0	PRJNA591127	2629	436	3.73183	16.2707788	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	327	6.25e-85	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2463	i0	80.317	69.901376146789	442	79	100	8	1	436	3681010	3681449	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	30477	327	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
18416863	18416863	PRJNA591127_P_NODE_1675_length_525_cov_6.637295_g1520_i0	PRJNA591127	1675	525	6.637295	34.84579875	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	699	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1520	i0	90.684	143.146666666667	526	47	100	2	1	525	3680674	3680150	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	75152	699	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
19691470	19691470	PRJNA591127_P_NODE_23556_length_177_cov_5.178571_g23387_i0	PRJNA591127	23556	177	5.178571	9.16607067	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	217	5.01e-52	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g23387	i0	89.205	160.774011299435	176	16	98	3	1	174	3682179	3682353	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	28457	217	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
29051249	29051249	PRJNA591127_P_NODE_18068_length_197_cov_2.312500_g17899_i0	PRJNA591127	18068	197	2.3125	4.555625	Bacillati	1783272	Bacteria	Bacteria	56.2	2.76e-7	NR	MDP3507025.1	2052166	g17899	i0	100	1.14213197969543	25	0	38.1	0	1	75	167	191	MDP3507025.1 Fe-Mn family superoxide dismutase [Candidatus Melainabacteria bacterium]	diamond	225	56.2	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
32577571	32577571	PRJNA591127_P_NODE_17399_length_197_cov_2.500000_g17230_i0	PRJNA591127	17399	197	2.5	4.925	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	92.4	3.7300000000000006e-21	NR	MBX9672374.1	2364082	g17230	i0	73.5	1.03553299492386	68	15	99	1	2	196	16	83	MBX9672374.1 cyclase family protein [Candidatus Obscuribacterales bacterium]	diamond	204	92.4	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);;