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

21 rows where analysis = "blastn", bioproject = "PRJNA550047" 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
513283	513283	PRJNA550047_P_NODE_186621_length_344_cov_15.579336_g184660_i0	PRJNA550047	186621	344	15.579336	53.59291584	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	263	1.3800000000000001e-65	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g184660	i0	98.013	0.86046511627907	151	3	86	0	1	151	4842715	4842565	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	296	263	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
1790836	1790836	PRJNA550047_P_NODE_337762_length_290_cov_3.262673_g335792_i0	PRJNA550047	337762	290	3.262673	9.4617517	Candidatus Melainabacteria bacterium MEL.A1	1899017	Bacteria	Bacteria	525	1.32e-144	NTclustered	gi\|1079475020\|gb\|CP017245.1\|	1899017	g335792	i0	99.31	2.1	290	2	100	0	1	290	360874	361163	Candidatus Melainabacteria bacterium MEL.A1 chromosome, complete genome	blastn	609	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium MEL.A1
1790926	1790926	PRJNA550047_P_NODE_345142_length_287_cov_5.570093_g343172_i0	PRJNA550047	345142	287	5.570093	15.98616691	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	525	1.2999999999999995e-144	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g343172	i0	99.652	1	287	1	100	0	1	287	478215	478501	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	287	525	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
3066938	3066938	PRJNA550047_P_NODE_405363_length_263_cov_4.236842_g403391_i0	PRJNA550047	405363	263	4.236842	11.14289446	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	486	5.5499999999999986e-133	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g403391	i0	100	1	263	0	100	0	1	263	3956008	3956270	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	263	486	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
3069836	3069836	PRJNA550047_P_NODE_99303_length_345_cov_8.503676_g97343_i0	PRJNA550047	99303	345	8.503676	29.3376822	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	270	8.28e-68	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g97343	i0	98.684	0.866666666666667	152	2	87	0	1	152	1859744	1859593	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	299	270	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
5617285	5617285	PRJNA550047_P_NODE_189905_length_344_cov_10.479705_g187944_i0	PRJNA550047	189905	344	10.479705	36.0501852	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	276	1.77e-69	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g187944	i0	100	0.869186046511628	149	0	87	0	196	344	2483349	2483201	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	299	276	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
6891579	6891579	PRJNA550047_P_NODE_223426_length_301_cov_9.583333_g221457_i0	PRJNA550047	223426	301	9.583333	28.84583233	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	283	9.12e-72	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g221457	i0	100	1.00996677740864	153	0	100	0	149	301	1408144	1408296	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	304	283	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
6895835	6895835	PRJNA550047_P_NODE_565746_length_208_cov_15.000000_g563773_i0	PRJNA550047	565746	208	15	31.2	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	374	3.4199999999999996e-99	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g563773	i0	99.038	1	208	2	100	0	1	208	1034618	1034825	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	208	374	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
8168640	8168640	PRJNA550047_P_NODE_383587_length_271_cov_11.222222_g381615_i0	PRJNA550047	383587	271	11.222222	30.41222162	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	496	9.55e-136	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g381615	i0	99.631	1	271	1	100	0	1	271	2739813	2740083	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	271	496	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
9444343	9444343	PRJNA550047_P_NODE_398368_length_265_cov_16.130208_g396396_i0	PRJNA550047	398368	265	16.130208	42.7450512	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g396396	i0	100	1	265	0	100	0	1	265	1100622	1100358	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	265	490	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
9445174	9445174	PRJNA550047_P_NODE_467468_length_241_cov_12.053571_g465495_i0	PRJNA550047	467468	241	12.053571	29.04910611	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	438	1.4299999999999999e-118	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g465495	i0	99.583	0.995850622406639	240	1	99	0	2	241	4238697	4238936	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	240	438	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
11996781	11996781	PRJNA550047_P_NODE_55730_length_345_cov_16.908088_g53770_i0	PRJNA550047	55730	345	16.908088	58.3329036	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	278	4.9500000000000006e-70	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g53770	i0	100	1.00869565217391	150	0	87	0	195	344	1257035	1256886	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	348	278	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
14545417	14545417	PRJNA550047_P_NODE_442032_length_249_cov_19.017045_g440060_i0	PRJNA550047	442032	249	19.017045	47.35244205	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	420	5.36e-113	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g440060	i0	97.177	0.995983935742972	248	7	99	0	1	248	3924709	3924462	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	248	420	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
15816775	15816775	PRJNA550047_P_NODE_240113_length_300_cov_17.392070_g238144_i0	PRJNA550047	240113	300	17.39207	52.17621	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	544	3.78e-150	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g238144	i0	99.333	1	300	2	100	0	1	300	1093623	1093324	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	300	544	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
17092922	17092922	PRJNA550047_P_NODE_351354_length_284_cov_13.246445_g349383_i0	PRJNA550047	351354	284	13.246445	37.6199038	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	518	2.15e-142	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g349383	i0	99.647	0.996478873239437	283	1	99	0	2	284	692239	691957	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	283	518	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
18367953	18367953	PRJNA550047_P_NODE_426175_length_255_cov_7.274725_g424203_i0	PRJNA550047	426175	255	7.274725	18.55054875	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	326	1.2399999999999999e-84	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g424203	i0	89.844	232.81568627451	256	23	100	3	1	255	3679982	3679729	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	59368	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
19639413	19639413	PRJNA550047_P_NODE_170776_length_345_cov_3.316176_g168816_i0	PRJNA550047	170776	345	3.316176	11.4408072	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	267	1.07e-66	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g168816	i0	98.667	0.855072463768116	150	2	86	0	2	151	2184306	2184157	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	295	267	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
22192554	22192554	PRJNA550047_P_NODE_378038_length_273_cov_19.100000_g376066_i0	PRJNA550047	378038	273	19.1	52.143	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	383	7.82e-102	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g376066	i0	94.378	0.912087912087912	249	14	91	0	1	249	287418	287666	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	249	383	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
22192740	22192740	PRJNA550047_P_NODE_393078_length_267_cov_18.597938_g391106_i0	PRJNA550047	393078	267	18.597938	49.65649446	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	494	3.38e-135	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g391106	i0	100	1	267	0	100	0	1	267	3212427	3212693	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	267	494	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
22194377	22194377	PRJNA550047_P_NODE_532338_length_219_cov_15.253425_g530365_i0	PRJNA550047	532338	219	15.253425	33.40500075	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	366	6.09e-97	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g530365	i0	96.804	1	219	7	100	0	1	219	101112	101330	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	219	366	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
24741316	24741316	PRJNA550047_P_NODE_340980_length_288_cov_16.516279_g339010_i0	PRJNA550047	340980	288	16.516279	47.56688352	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	532	7.8e-147	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g339010	i0	100	1	288	0	100	0	1	288	4393892	4393605	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	288	532	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);;