metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA415636" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA415636" 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
2969826	2969826	PRJNA415636_S_NODE_5843_length_214_cov_0.916168_g5796_i0	PRJNA415636	5843	214	0.916168	1.96059952	Mycoplasma wenyonii	65123	Bacteria	Bacteria	357	3.5699999999999996e-94	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5796	i0	96.729	1	214	7	100	0	1	214	187906	188119	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	214	357	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4246174	4246174	PRJNA415636_S_NODE_6104_length_210_cov_2.815951_g6057_i0	PRJNA415636	6104	210	2.815951	5.9134971	Mycoplasma wenyonii	65123	Bacteria	Bacteria	383	5.75e-102	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g6057	i0	99.524	1	210	1	100	0	1	210	609661	609452	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	210	383	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5522883	5522883	PRJNA415636_S_NODE_2945_length_280_cov_1.510730_g2898_i0	PRJNA415636	2945	280	1.51073	4.230044	Mycoplasma wenyonii	65123	Bacteria	Bacteria	468	2.16e-127	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2898	i0	96.786	1	280	9	100	0	1	280	537161	537440	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	280	468	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
15721779	15721779	PRJNA415636_S_NODE_3953_length_250_cov_2.078818_g3906_i0	PRJNA415636	3953	250	2.078818	5.197045	Mycoplasma wenyonii	65123	Bacteria	Bacteria	440	4.1399999999999976e-119	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3906	i0	98.406	1.004	251	3	100	1	1	250	560981	561231	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	251	440	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
18270736	18270736	PRJNA415636_S_NODE_5335_length_222_cov_1.497143_g5288_i0	PRJNA415636	5335	222	1.497143	3.32365746	Mycoplasma wenyonii	65123	Bacteria	Bacteria	361	2.8799999999999994e-95	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5288	i0	95.946	1	222	9	100	0	1	222	137419	137640	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	222	361	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
19544940	19544940	PRJNA415636_S_NODE_4956_length_229_cov_1.197802_g4909_i0	PRJNA415636	4956	229	1.197802	2.74296658	Mycoplasma wenyonii	65123	Bacteria	Bacteria	350	6.47e-92	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4909	i0	94.298	0.995633187772926	228	13	99	0	2	229	188922	188695	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	228	350	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
20820832	20820832	PRJNA415636_S_NODE_3957_length_250_cov_1.502463_g3910_i0	PRJNA415636	3957	250	1.502463	3.7561575	Mycoplasma wenyonii	65123	Bacteria	Bacteria	457	4.1099999999999985e-124	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3910	i0	99.6	1	250	1	100	0	1	250	37219	37468	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	250	457	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
20820836	20820836	PRJNA415636_S_NODE_5537_length_219_cov_1.186047_g5490_i0	PRJNA415636	5537	219	1.186047	2.59744293	Mycoplasma wenyonii	65123	Bacteria	Bacteria	366	6.09e-97	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g5490	i0	97.235	0.990867579908676	217	4	99	2	4	219	556495	556280	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	217	366	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23371220	23371220	PRJNA415636_S_NODE_2419_length_301_cov_3.610236_g2372_i0	PRJNA415636	2419	301	3.610236	10.86681036	Mycoplasma wenyonii	65123	Bacteria	Bacteria	518	2.3e-142	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g2372	i0	97.674	1	301	7	100	0	1	301	254865	254565	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	301	518	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);;