metadata: contig_metadata: 21 rows where analysis = "blastn", bioproject = "PRJEB64798" and tax

21 rows where analysis = "blastn", bioproject = "PRJEB64798" 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
129337	129337	PRJEB64798_P_NODE_6581_length_765_cov_39.108939_g5338_i0	PRJEB64798	6581	765	39.108939	299.18338335	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	527	1.0499999999999996e-144	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g5338	i0	80.054	302.550326797386	737	126	95	16	2	728	597914	598639	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	231451	527	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
1401260	1401260	PRJEB64798_P_NODE_126522_length_200_cov_5.708609_g124756_i0	PRJEB64798	126522	200	5.708609	11.417218	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	228	2.689999999999999e-55	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g124756	i0	87.755	638.595	196	23	98	1	6	200	598180	597985	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	127719	228	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
1402379	1402379	PRJEB64798_P_NODE_200082_length_167_cov_4.881356_g198316_i0	PRJEB64798	200082	167	4.881356	8.15186452	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	104	3.81e-18	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g198316	i0	94.118	143.299401197605	68	4	41	0	4	71	509981	509914	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	23931	104	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
6507765	6507765	PRJEB64798_P_NODE_74806_length_223_cov_3.321839_g73041_i0	PRJEB64798	74806	223	3.321839	7.40770097	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	156	1.47e-33	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g73041	i0	95.833	2.15695067264574	96	4	43	0	123	218	3679870	3679965	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	481	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
7780296	7780296	PRJEB64798_P_NODE_20107_length_444_cov_11.392405_g18377_i0	PRJEB64798	20107	444	11.392405	50.5822782	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	488	2.7599999999999996e-133	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g18377	i0	86.517	58.3198198198198	445	58	100	2	1	444	1477488	1477045	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	25894	488	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
9053975	9053975	PRJEB64798_P_NODE_123968_length_203_cov_4.272727_g122202_i0	PRJEB64798	123968	203	4.272727	8.67363581	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	283	5.76e-72	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g122202	i0	92.462	157.024630541872	199	14	98	1	1	198	597965	598163	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	31876	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
9055522	9055522	PRJEB64798_P_NODE_227948_length_159_cov_7.772727_g226182_i0	PRJEB64798	227948	159	7.772727	12.35863593	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	135	1.27e-27	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g226182	i0	82.581	132.182389937107	155	25	97	2	5	158	3682142	3681989	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	21017	135	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
9056474	9056474	PRJEB64798_P_NODE_5888_length_803_cov_285.360743_g4734_i0	PRJEB64798	5888	803	285.360743	2291.44676629	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	634	6.299999999999999e-177	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g4734	i0	83.824	100.250311332503	680	96	83	12	129	798	3680916	3681591	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	80501	634	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
10330531	10330531	PRJEB64798_P_NODE_172469_length_177_cov_16.898438_g170703_i0	PRJEB64798	172469	177	16.898438	29.91023526	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	132	1.87e-26	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g170703	i0	88.288	208.64406779661	111	12	62	1	34	143	3681191	3681301	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	36930	132	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
10330659	10330659	PRJEB64798_P_NODE_182169_length_173_cov_6.540323_g180403_i0	PRJEB64798	182169	173	6.540323	11.31475879	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	139	1.08e-28	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g180403	i0	82.609	255.653179190751	161	24	92	4	4	162	3679975	3679817	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	44228	139	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
11605483	11605483	PRJEB64798_P_NODE_144010_length_191_cov_6.732394_g142244_i0	PRJEB64798	144010	191	6.732394	12.85887254	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	156	1.22e-33	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g142244	i0	82.682	144.329842931937	179	27	93	4	2	178	598258	598434	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	27567	156	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
12882266	12882266	PRJEB64798_P_NODE_2771_length_1107_cov_90.825142_g149_i5	PRJEB64798	2771	1107	90.825142	1005.43432194	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	854	0	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g149	i5	82.283	170.350496838302	1016	153	91	25	104	1106	1223176	1222175	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	188578	854	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
12882434	12882434	PRJEB64798_P_NODE_36551_length_326_cov_19.577617_g34792_i0	PRJEB64798	36551	326	19.577617	63.82303142	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	350	9.7e-92	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g34792	i0	87.025	196.822085889571	316	33	95	8	1	310	1479480	1479167	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	64164	350	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium MEL.A1
14157418	14157418	PRJEB64798_P_NODE_4732_length_889_cov_84.470238_g3748_i0	PRJEB64798	4732	889	84.470238	750.94041582	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	878	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g3748	i0	84.831	133.482564679415	890	115	99	20	1	881	3681803	3682681	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	118666	878	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
15431326	15431326	PRJEB64798_P_NODE_41633_length_305_cov_22.734375_g39868_i0	PRJEB64798	41633	305	22.734375	69.33984375	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	233	9.46e-57	NTclustered	gi\|2729058729\|emb\|OZ007029.1\|	2137880	g39868	i0	84.167	87.8950819672131	240	38	79	0	3	242	1222181	1221942	MAG: Candidatus Gastranaerophilales bacterium isolate 6755_HET_CTRL_tig00013926_hicanu_large MAG genome assembly, chromosome: 1	blastn	26808	233	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
15431592	15431592	PRJEB64798_P_NODE_54753_length_264_cov_2.911628_g52988_i0	PRJEB64798	54753	264	2.911628	7.68669792	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	267	7.909999999999999e-67	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g52988	i0	85.547	78.7537878787879	256	36	97	1	1	256	3679729	3679983	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	20791	267	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
17981277	17981277	PRJEB64798_P_NODE_87535_length_212_cov_11.852761_g85769_i0	PRJEB64798	87535	212	11.852761	25.12785332	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	244	2.87e-60	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g85769	i0	87.736	165.481132075472	212	23	99	3	2	212	511462	511671	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	35082	244	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales bacterium
20529388	20529388	PRJEB64798_P_NODE_24217_length_400_cov_37.364672_g22470_i0	PRJEB64798	24217	400	37.364672	149.458688	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	486	8.869999999999999e-133	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g22470	i0	88.945	587.51	398	38	99	4	1	394	597391	596996	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	235004	486	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
23078634	23078634	PRJEB64798_P_NODE_11939_length_579_cov_13.877358_g10351_i0	PRJEB64798	11939	579	13.877358	80.34990282	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	641	2.6699999999999993e-179	NTclustered	gi\|2189472572\|gb\|CP091731.1\|	2052166	g10351	i0	87.002	97.0449050086356	577	66	99	8	2	574	597018	597589	MAG: Candidatus Melainabacteria bacterium isolate nC33_lr_bin.1.fa chromosome	blastn	56189	641	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
23079386	23079386	PRJEB64798_P_NODE_170439_length_178_cov_9.085271_g168673_i0	PRJEB64798	170439	178	9.085271	16.17178238	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	294	2.27e-75	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g168673	i0	99.383	422.943820224719	162	1	91	0	17	178	3681581	3681420	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	75284	294	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria		Candidatus Melainabacteria bacterium
23080712	23080712	PRJEB64798_P_NODE_33979_length_338_cov_100.114187_g32221_i0	PRJEB64798	33979	338	100.114187	338.38595206	Candidatus Gastranaerophilales bacterium	2137880	Bacteria	Bacteria	372	2.16e-98	NTclustered	gi\|2729058672\|emb\|OZ006972.1\|	2137880	g32221	i0	86.686	1174.36982248521	338	41	99	4	1	336	511947	511612	MAG: Candidatus Gastranaerophilales bacterium isolate metabat2_pooled_hifiasm.1023 MAG genome assembly, chromosome: 1	blastn	396937	372	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Gastranaerophilales	Candidatus Gastranaerophilales 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);;