metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA1004255" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA1004255" and tax_phylum = "Mycoplasmatota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
2703470	2703470	PRJNA1004255_S_NODE_1943_length_360_cov_1.927445_g1735_i0	PRJNA1004255	1943	360	1.927445	6.938802	Mycoplasma haemofelis	29501	Bacteria	Bacteria	475	1.7099999999999995e-129	NTclustered	gi\|334192594\|gb\|CP002808.1\|	859194	g1735	i0	90.526	50.2333333333333	380	7	99	20	5	360	230825	230451	Mycoplasma haemofelis Ohio2, complete genome	blastn	18084	475	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma haemofelis
2703513	2703513	PRJNA1004255_S_NODE_9883_length_202_cov_3.490566_g9675_i0	PRJNA1004255	9883	202	3.490566	7.05094332	Mycoplasma wenyonii	65123	Bacteria	Bacteria	217	5.89e-52	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g9675	i0	86.869	0.98019801980198	198	20	97	4	8	202	247901	247707	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	198	217	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
3979662	3979662	PRJNA1004255_S_NODE_3864_length_287_cov_3.340164_g3656_i0	PRJNA1004255	3864	287	3.340164	9.58627068	Mycoplasma wenyonii	65123	Bacteria	Bacteria	370	6.45e-98	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3656	i0	89.931	1.65156794425087	288	27	100	2	1	287	292308	292022	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	474	370	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5256203	5256203	PRJNA1004255_S_NODE_8705_length_213_cov_3.241176_g8497_i0	PRJNA1004255	8705	213	3.241176	6.90370488	Mycoplasma wenyonii	65123	Bacteria	Bacteria	279	7.9e-71	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g8497	i0	95.429	0.990610328638498	175	8	82	0	1	175	634594	634420	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	211	279	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
9080698	9080698	PRJNA1004255_S_NODE_14028_length_173_cov_2.530769_g13820_i0	PRJNA1004255	14028	173	2.530769	4.37823037	Mycoplasma wenyonii	65123	Bacteria	Bacteria	198	1.7599999999999998e-46	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g13820	i0	87.283	1	173	22	100	0	1	173	632212	632040	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	173	198	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
9080717	9080717	PRJNA1004255_S_NODE_18528_length_151_cov_6.666667_g18320_i0	PRJNA1004255	18528	151	6.666667	10.06666717	Mycoplasma wenyonii	65123	Bacteria	Bacteria	263	5.23e-66	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g18320	i0	98.013	1	151	3	100	0	1	151	85850	86000	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	151	263	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
12906936	12906936	PRJNA1004255_S_NODE_16491_length_160_cov_2.384615_g16283_i0	PRJNA1004255	16491	160	2.384615	3.815384	Mycoplasma wenyonii	65123	Bacteria	Bacteria	296	5.55e-76	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g16283	i0	100	1	160	0	100	0	1	160	561284	561125	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	160	296	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
14181960	14181960	PRJNA1004255_S_NODE_5512_length_254_cov_4.222749_g5304_i0	PRJNA1004255	5512	254	4.222749	10.72578246	Mycoplasma wenyonii	65123	Bacteria	Bacteria	320	5.73e-83	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5304	i0	90.204	5.48031496062992	245	24	96	0	1	245	251066	251310	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	1392	320	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16730189	16730189	PRJNA1004255_S_NODE_5634_length_252_cov_3.373206_g5426_i0	PRJNA1004255	5634	252	3.373206	8.50047912	Mycoplasma wenyonii	65123	Bacteria	Bacteria	455	1.49e-123	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5426	i0	99.206	1	252	2	100	0	1	252	274064	274315	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	252	455	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
20554470	20554470	PRJNA1004255_S_NODE_9857_length_202_cov_5.320755_g9649_i0	PRJNA1004255	9857	202	5.320755	10.7479251	Mycoplasma wenyonii	65123	Bacteria	Bacteria	368	1.54e-97	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g9649	i0	99.505	1	202	1	100	0	1	202	272066	272267	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	202	368	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21830089	21830089	PRJNA1004255_S_NODE_9758_length_203_cov_4.762500_g9550_i0	PRJNA1004255	9758	203	4.7625	9.667875	Mycoplasma wenyonii	65123	Bacteria	Bacteria	331	2.03e-86	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g9550	i0	96.059	2.97536945812808	203	8	100	0	1	203	295879	296081	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	604	331	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23105517	23105517	PRJNA1004255_S_NODE_5579_length_253_cov_2.461905_g5371_i0	PRJNA1004255	5579	253	2.461905	6.22861965	Mycoplasma wenyonii	65123	Bacteria	Bacteria	412	9.14e-111	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5371	i0	96.047	1	253	10	100	0	1	253	462579	462327	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	253	412	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24379221	24379221	PRJNA1004255_S_NODE_10240_length_199_cov_3.378205_g10032_i0	PRJNA1004255	10240	199	3.378205	6.72262795	Mycoplasma wenyonii	65123	Bacteria	Bacteria	363	7.019999999999998e-96	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g10032	i0	99.497	1.15075376884422	199	1	100	0	1	199	557418	557220	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	229	363	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24379222	24379222	PRJNA1004255_S_NODE_10280_length_199_cov_2.108974_g10072_i0	PRJNA1004255	10280	199	2.108974	4.19685826	Mycoplasma wenyonii	65123	Bacteria	Bacteria	340	3.2899999999999996e-89	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g10072	i0	97.487	1	199	5	100	0	1	199	537231	537429	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	199	340	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii

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);;