metadata: contig_metadata: 17 rows where bioproject = "PRJNA315314", tax_clade = "Cyanobacteriota/Melainabacteria group" and tax

17 rows where bioproject = "PRJNA315314", tax_clade = "Cyanobacteriota/Melainabacteria group" 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
5484326	5484326	PRJNA315314_S_NODE_23705_length_171_cov_7.753521_g23384_i0	PRJNA315314	23705	171	7.753521	13.25852091	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	220	3.71e-53	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g23384	i0	90.116	77.4035087719298	172	13	100	4	1	171	3681336	3681504	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13236	220	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
8034203	8034203	PRJNA315314_S_NODE_30147_length_154_cov_21.416000_g29826_i0	PRJNA315314	30147	154	21.416	32.98064	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	180	5.56e-41	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g29826	i0	88.158	887.876623376623	152	16	98	2	4	154	1478757	1478607	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	136733	180	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
8034276	8034276	PRJNA315314_S_NODE_5427_length_344_cov_713.530159_g5106_i0	PRJNA315314	5427	344	713.530159	2454.54374696	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	451	2.75e-122	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5106	i0	90.379	144.906976744186	343	33	99	0	2	344	3680357	3680699	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	49848	451	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
9308688	9308688	PRJNA315314_S_NODE_13708_length_220_cov_9.591623_g13387_i0	PRJNA315314	13708	220	9.591623	21.1015706	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	307	3.77e-79	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g13387	i0	91.892	141.204545454545	222	15	99	2	1	219	3681820	3682041	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	31065	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
10584867	10584867	PRJNA315314_S_NODE_5349_length_347_cov_3.566038_g5028_i0	PRJNA315314	5349	347	3.566038	12.37415186	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	250	1.09e-61	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5028	i0	80.233	40.3659942363112	344	59	98	8	7	345	3682574	3682235	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	14007	250	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
10584880	10584880	PRJNA315314_S_NODE_5989_length_330_cov_2.877076_g5668_i0	PRJNA315314	5989	330	2.877076	9.4943508	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	233	1.03e-56	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5668	i0	80.06	4.05757575757576	336	50	99	17	4	330	3682635	3682308	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	1339	233	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
11859377	11859377	PRJNA315314_S_NODE_14930_length_211_cov_18.538462_g14609_i0	PRJNA315314	14930	211	18.538462	39.11615482	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	307	3.5800000000000004e-79	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g14609	i0	92.891	217.81990521327	211	15	100	0	1	211	3680388	3680178	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	45960	307	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
14409611	14409611	PRJNA315314_S_NODE_1612_length_610_cov_200.106713_g1352_i0	PRJNA315314	1612	610	200.106713	1220.6509493	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	599	1.7199999999999993e-166	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1352	i0	84.578	155.408196721311	616	81	100	11	1	610	3680681	3681288	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	94799	599	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
15683746	15683746	PRJNA315314_S_NODE_9833_length_258_cov_5.707424_g9512_i0	PRJNA315314	9833	258	5.707424	14.72515392	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	316	7.539999999999998e-82	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g9512	i0	88.76	118.046511627907	258	29	100	0	1	258	3681579	3681836	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	30456	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
16958148	16958148	PRJNA315314_S_NODE_16754_length_200_cov_4400.947368_g16433_i0	PRJNA315314	16754	200	4400.947368	8801.894736	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	182	2.12e-41	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g16433	i0	88.235	21.89	153	16	76	2	1	152	197481	197632	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	4378	182	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
22057209	22057209	PRJNA315314_S_NODE_1618_length_609_cov_198.015517_g1358_i0	PRJNA315314	1618	609	198.015517	1205.91449853	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	514	6.399999999999999e-141	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1358	i0	82.229	148.192118226601	619	89	100	19	1	609	3680681	3681288	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	90249	514	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
23332657	23332657	PRJNA315314_S_NODE_1139_length_716_cov_170.503639_g912_i0	PRJNA315314	1139	716	170.503639	1220.80605524	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	771	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g912	i0	86.288	136.321229050279	722	84	100	12	1	716	3681393	3680681	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	97606	771	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
24606905	24606905	PRJNA315314_S_NODE_2200_length_531_cov_229.119522_g1908_i0	PRJNA315314	2200	531	229.119522	1216.62466182	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	355	3.55e-93	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1908	i0	85.112	174.815442561205	356	44	66	8	180	531	3681031	3680681	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	92827	355	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
26979393	26979393	PRJNA315314_S_NODE_6822_length_310_cov_2.875445_g6501_i0	PRJNA315314	6822	310	2.875445	8.9138795	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	54.7	5.45e-6	NR	MDR3612284.1	2364082	g6501	i0	38.3	1.73225806451613	94	50	87.1	3	273	4	1049	1138	MDR3612284.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	537	54.7	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
27042725	27042725	PRJNA315314_S_NODE_23042_length_173_cov_15.347222_g22721_i0	PRJNA315314	23042	173	15.347222	26.55069406	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	44.3	4.13e-4	NR	MBX9722867.1	2364082	g22721	i0	80.8	0.450867052023121	26	5	45.1	0	157	80	5	30	MBX9722867.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	78	44.3	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
27105780	27105780	PRJNA315314_S_NODE_24342_length_169_cov_5.178571_g24021_i0	PRJNA315314	24342	169	5.178571	8.75178499	Candidatus Obscuribacterales bacterium	2364082	Bacteria	Bacteria	43.1	0.00109	NR	MBX9722867.1	2364082	g24021	i0	52.3	0.781065088757396	44	21	78.1	0	18	149	7	50	MBX9722867.1 hypothetical protein [Candidatus Obscuribacterales bacterium]	diamond	132	43.1	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Obscuribacterales	Candidatus Obscuribacterales bacterium
32603604	32603604	PRJNA315314_S_NODE_31700_length_151_cov_8.827869_g31379_i0	PRJNA315314	31700	151	8.827869	13.33008219	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	75.9	3.99e-16	NR	PZM84364.1	2052166	g31379	i0	90	0.794701986754967	40	4	79.5	0	3	122	62	101	PZM84364.1 MAG: hypothetical protein DKT66_06930 [Candidatus Melainabacteria bacterium]	diamond	120	75.9	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria 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);;