metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA827593" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA827593" 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_species
821050	821050	PRJNA827593_P_NODE_2661_length_1442_cov_9.834186_g2469_i0	PRJNA827593	2661	1442	9.834186	141.80896212	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1439	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2469	i0	85	95.7038834951456	1440	190	99	23	22	1442	3682424	3680992	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	138005	1439	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
5924619	5924619	PRJNA827593_P_NODE_50045_length_283_cov_1.314286_g49746_i0	PRJNA827593	50045	283	1.314286	3.71942938	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	235	2.4199999999999997e-57	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g49746	i0	87.624	0.876325088339223	202	25	71	0	31	232	32813	33014	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	248	235	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
5924831	5924831	PRJNA827593_P_NODE_63425_length_247_cov_2.488506_g63126_i0	PRJNA827593	63425	247	2.488506	6.14660982	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g63126	i0	91.892	0.149797570850202	37	3	15	0	211	247	872011	871975	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	37	52.8	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
7199862	7199862	PRJNA827593_P_NODE_65766_length_244_cov_1.333333_g65467_i0	PRJNA827593	65766	244	1.333333	3.25333252	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	252	2.02e-62	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g65467	i0	85.306	1.22950819672131	245	34	100	2	1	244	3380247	3380490	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	300	252	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
8473879	8473879	PRJNA827593_P_NODE_2787_length_1403_cov_2.481955_g2591_i0	PRJNA827593	2787	1403	2.481955	34.82182865	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	392	7.459999999999999e-104	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2591	i0	84.158	25.4811119030649	404	64	29	0	1	404	4710889	4711292	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	35750	392	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
8474316	8474316	PRJNA827593_P_NODE_51347_length_278_cov_2.424390_g51048_i0	PRJNA827593	51347	278	2.42439	6.7398042	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	189	1.87e-43	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g51048	i0	80.315	0.913669064748201	254	46	91	4	2	253	747291	747542	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	254	189	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
11025260	11025260	PRJNA827593_P_NODE_5669_length_949_cov_2.124429_g5419_i0	PRJNA827593	5669	949	2.124429	20.16083121	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	854	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g5419	i0	83.351	2.34984193888303	937	142	98	10	3	929	384792	383860	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	2230	854	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
12300853	12300853	PRJNA827593_P_NODE_64970_length_245_cov_1.441860_g64671_i0	PRJNA827593	64970	245	1.44186	3.532557	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	148	2.74e-31	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g64671	i0	78.667	9.74285714285714	225	46	91	2	22	245	1691370	1691593	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	2387	148	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
13574831	13574831	PRJNA827593_P_NODE_43951_length_305_cov_0.995690_g43652_i0	PRJNA827593	43951	305	0.99569	3.0368545	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	292	1.54e-74	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g43652	i0	84.459	0.970491803278689	296	46	97	0	9	304	3380659	3380364	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	296	292	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
21222871	21222871	PRJNA827593_P_NODE_17317_length_516_cov_1.600451_g17019_i0	PRJNA827593	17317	516	1.600451	8.25832716	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	113	2.29e-20	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g17019	i0	94.595	19.3333333333333	74	2	14	2	1	72	2664992	2664919	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	9976	113	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25047063	25047063	PRJNA827593_P_NODE_13240_length_598_cov_2.925714_g12946_i0	PRJNA827593	13240	598	2.925714	17.49576972	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	706	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g12946	i0	88.625	152.586956521739	589	55	97	11	16	597	3682509	3681926	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	91247	706	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25047552	25047552	PRJNA827593_P_NODE_3960_length_1156_cov_4.756233_g2469_i1	PRJNA827593	3960	1156	4.756233	54.98205348	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1223	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2469	i1	86.087	117.935121107266	1150	145	98	13	1	1138	3680992	3682138	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	136333	1223	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);;