metadata: contig_metadata: 20 rows where analysis = "blastn", bioproject = "PRJEB7799" and tax

20 rows where analysis = "blastn", bioproject = "PRJEB7799" 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
25526268	25526268	PRJEB7799a_S_NODE_49_length_875_cov_36.752381_g2_i4	PRJEB7799	49	875	36.752381	321.58333375	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	876	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g2	i4	85.315	82.0285714285714	858	115	97	10	1	852	3681588	3680736	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	71775	876	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25527243	25527243	PRJEB7799i_S_NODE_121_length_1664_cov_21.551872_g117_i0	PRJEB7799	121	1664	21.551872	358.62315008	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1703	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g117	i0	86.514	101.019230769231	1572	184	93	27	37	1590	3682681	3681120	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	168096	1703	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25528294	25528294	PRJEB7799n_S_NODE_1337_length_357_cov_13.779503_g1300_i0	PRJEB7799	1337	357	13.779503	49.19282571	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	316	1.09e-81	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1300	i0	87.455	306.319327731092	279	30	78	5	1	277	3682051	3682326	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	109356	316	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25528576	25528576	PRJEB7799o_S_NODE_1_length_1866_cov_50.525942_g0_i0	PRJEB7799	1	1866	50.525942	942.81407772	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1905	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g0	i0	86.145	155.010718113612	1790	219	95	26	68	1839	3680903	3682681	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	289250	1905	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25664261	25664261	PRJEB7799m_S_NODE_26_length_607_cov_51.797203_g22_i0	PRJEB7799	26	607	51.797203	314.40902221	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	603	1.3199999999999999e-167	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g22	i0	86.861	145.06589785832	548	60	89	11	40	581	3682140	3682681	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	88055	603	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25664573	25664573	PRJEB7799o_S_NODE_162_length_410_cov_10.397333_g154_i0	PRJEB7799	162	410	10.397333	42.6290653	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	339	2.6999999999999994e-88	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g154	i0	84.726	32.209756097561	347	44	84	8	1	343	3681244	3680903	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13206	339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25664611	25664611	PRJEB7799o_S_NODE_2_length_1715_cov_22.539286_g0_i1	PRJEB7799	2	1715	22.539286	386.5487549	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1676	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g0	i1	85.266	109.060058309038	1656	211	95	30	14	1648	3682546	3680903	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	187038	1676	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25797959	25797959	PRJEB7799a_S_NODE_1459_length_336_cov_40.455150_g1424_i0	PRJEB7799	1459	336	40.45515	135.929304	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	412	1.2599999999999998e-110	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1424	i0	89.157	404.47619047619	332	35	99	1	1	331	3680056	3679725	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	135904	412	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25799278	25799278	PRJEB7799g_S_NODE_1099_length_250_cov_4.167442_g883_i0	PRJEB7799	1099	250	4.167442	10.418605	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	265	2.67e-66	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g883	i0	86.611	54.336	239	32	96	0	2	240	3681116	3680878	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13584	265	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25800723	25800723	PRJEB7799o_S_NODE_11_length_863_cov_90.493961_g0_i3	PRJEB7799	11	863	90.493961	780.96288343	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	959	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g0	i3	87.441	258.531865585168	844	92	97	13	28	863	3682681	3681844	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	223113	959	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
25800800	25800800	PRJEB7799o_S_NODE_3_length_1308_cov_15.815397_g0_i2	PRJEB7799	3	1308	15.815397	206.86539276	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	1339	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g0	i2	86.182	95.8249235474006	1252	157	95	14	68	1308	3680903	3682149	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	125339	1339	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
26071590	26071590	PRJEB7799i_S_NODE_1941_length_329_cov_16.282313_g1911_i0	PRJEB7799	1941	329	16.282313	53.56880977	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	424	5.7e-114	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1911	i0	89.939	617.395136778116	328	33	99	0	2	329	3679721	3680048	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	203123	424	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
26072512	26072512	PRJEB7799m_S_NODE_333_length_281_cov_4.304878_g328_i0	PRJEB7799	333	281	4.304878	12.09670718	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	268	2.3599999999999997e-67	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g328	i0	84.982	48.0925266903915	273	32	96	8	1	269	3680950	3681217	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13514	268	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
26072944	26072944	PRJEB7799o_S_NODE_453_length_282_cov_21.174089_g445_i0	PRJEB7799	453	282	21.174089	59.71093098	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	326	1.39e-84	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g445	i0	87.589	50.5531914893617	282	34	99	1	2	282	3679728	3680009	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	14256	326	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
26206294	26206294	PRJEB7799a_S_NODE_10934_length_179_cov_9.277778_g10899_i0	PRJEB7799	10934	179	9.277778	16.60722262	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	161	2.41e-35	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g10899	i0	90.833	3.51396648044693	120	11	67	0	26	145	3679475	3679594	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	629	161	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
26208096	26208096	PRJEB7799i_S_NODE_598_length_596_cov_63.310160_g574_i0	PRJEB7799	598	596	63.31016	377.3285536	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	603	1.2999999999999998e-167	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g574	i0	86.861	147.743288590604	548	60	91	11	19	560	3682140	3682681	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	88055	603	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
26208978	26208978	PRJEB7799n_S_NODE_310_length_663_cov_91.278662_g285_i0	PRJEB7799	310	663	91.278662	605.17752906	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	739	0	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g285	i0	87.931	146.79185520362	638	64	95	12	1	632	3682051	3682681	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	97323	739	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
26479078	26479078	PRJEB7799a_S_NODE_888_length_388_cov_34.192635_g853_i0	PRJEB7799	888	388	34.192635	132.6674238	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	436	8.759999999999999e-118	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g853	i0	89.941	467.605670103093	338	34	87	0	51	388	3679719	3680056	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	181431	436	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
26479938	26479938	PRJEB7799i_S_NODE_1352_length_396_cov_7.282548_g1322_i0	PRJEB7799	1352	396	7.282548	28.83889008	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	333	1.21e-86	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g1322	i0	85.759	33.2878787878788	323	37	81	8	68	386	3680903	3681220	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	13182	333	1	Bacteria	Cyanobacteriota/Melainabacteria group	Bacillati	Candidatus Melainabacteria	Candidatus Melainabacteria bacterium
26481131	26481131	PRJEB7799n_S_NODE_552_length_515_cov_15.352083_g517_i0	PRJEB7799	552	515	15.352083	79.06322745	Candidatus Melainabacteria bacterium	2052166	Bacteria	Bacteria	473	9.08e-129	NTclustered	gi\|1958007833\|gb\|CP064963.1\|	2052166	g517	i0	84.553	324.873786407767	492	61	94	12	16	499	3681220	3680736	MAG: Candidatus Melainabacteria bacterium isolate Aved_18-Q3-R54-62_BATAC.358_cln chromosome, complete genome	blastn	167310	473	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);;