metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA1195551" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA1195551" 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
4149567	4149567	PRJNA1195551_S_NODE_8304_length_315_cov_6.360902_g7951_i0	PRJNA1195551	8304	315	6.360902	20.0368413	Mycoplasma wenyonii	65123	Bacteria	Bacteria	560	3.96e-155	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7951	i0	98.73	1	315	4	100	0	1	315	101988	101674	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	315	560	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5425700	5425700	PRJNA1195551_S_NODE_15605_length_249_cov_1.745000_g15252_i0	PRJNA1195551	15605	249	1.745	4.34505	Mycoplasma wenyonii	65123	Bacteria	Bacteria	344	3.32e-90	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g15252	i0	91.566	17.433734939759	249	21	100	0	1	249	644904	645152	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	4341	344	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
10526340	10526340	PRJNA1195551_S_NODE_28449_length_190_cov_1.475177_g28096_i0	PRJNA1195551	28449	190	1.475177	2.8028363	Mycoplasma wenyonii	65123	Bacteria	Bacteria	318	1.46e-82	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g28096	i0	96.842	1	190	6	100	0	1	190	94821	95010	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	190	318	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
15625336	15625336	PRJNA1195551_S_NODE_20513_length_221_cov_2.418605_g20160_i0	PRJNA1195551	20513	221	2.418605	5.34511705	Mycoplasma ovis	171632	Bacteria	Bacteria	187	5.15e-43	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g20160	i0	88.387	0.701357466063348	155	18	70	0	3	157	697595	697749	Mycoplasma ovis str. Michigan, complete genome	blastn	155	187	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
18174182	18174182	PRJNA1195551_S_NODE_19495_length_226_cov_2.644068_g19142_i0	PRJNA1195551	19495	226	2.644068	5.97559368	Mycoplasma wenyonii	65123	Bacteria	Bacteria	298	2.34e-76	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g19142	i0	90.667	0.995575221238938	225	20	99	1	1	225	571574	571351	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	225	298	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19448562	19448562	PRJNA1195551_S_NODE_11156_length_283_cov_4.444444_g10803_i0	PRJNA1195551	11156	283	4.444444	12.57777652	Mycoplasma wenyonii	65123	Bacteria	Bacteria	492	1.2999999999999999e-134	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g10803	i0	97.895	1.21554770318021	285	4	100	1	1	283	230998	230714	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	344	492	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19448613	19448613	PRJNA1195551_S_NODE_22676_length_211_cov_4.469136_g22323_i0	PRJNA1195551	22676	211	4.469136	9.42987696	Mycoplasma wenyonii	65123	Bacteria	Bacteria	313	7.7e-81	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g22323	i0	93.365	1	211	14	100	0	1	211	262828	263038	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	211	313	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
20723969	20723969	PRJNA1195551_S_NODE_37757_length_167_cov_0.881356_g37404_i0	PRJNA1195551	37757	167	0.881356	1.47186452	Mycoplasma wenyonii	65123	Bacteria	Bacteria	292	7.58e-75	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g37404	i0	98.204	1	167	3	100	0	1	167	151617	151451	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	167	292	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21999358	21999358	PRJNA1195551_S_NODE_31858_length_180_cov_1.587786_g31505_i0	PRJNA1195551	31858	180	1.587786	2.8580148	Mycoplasma wenyonii	65123	Bacteria	Bacteria	316	4.899999999999999e-82	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g31505	i0	98.333	1	180	3	100	0	1	180	87446	87267	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	180	316	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
21999368	21999368	PRJNA1195551_S_NODE_37758_length_167_cov_0.881356_g37405_i0	PRJNA1195551	37758	167	0.881356	1.47186452	Mycoplasma wenyonii	65123	Bacteria	Bacteria	193	7.909999999999999e-45	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g37405	i0	87.5	1.0059880239521	168	19	100	2	1	167	143926	143760	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	168	193	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);;