metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA1111448" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA1111448" 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
2767916	2767916	PRJNA1111448_S_NODE_106943_length_264_cov_1.523560_g106120_i0	PRJNA1111448	106943	264	1.52356	4.0221984	Mycoplasma wenyonii	65123	Bacteria	Bacteria	420	5.74e-113	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g106120	i0	95.472	1.00378787878788	265	8	99	3	2	264	345115	345377	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	265	420	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
11226078	11226078	PRJNA1111448_S_NODE_31429_length_404_cov_1.247734_g30606_i0	PRJNA1111448	31429	404	1.247734	5.04084536	Mollicutes	31969	Bacteria	Bacteria	678	0	NTclustered	gi\|1563681465\|emb\|LR214949.1\|	2100	g30606	i0	97.03	104.975247524752	404	10	100	2	1	404	19349	19750	Mycoplasma hyorhinis strain NCTC10121 genome assembly, plasmid: 3	blastn	42410	678	1	Bacteria	Bacillati	Mycoplasmatota		Mycoplasmoidales	Metamycoplasmataceae	Mesomycoplasma	Mesomycoplasma hyorhinis
11697249	11697249	PRJNA1111448_S_NODE_96230_length_276_cov_1.137931_g95407_i0	PRJNA1111448	96230	276	1.137931	3.14068956	Mycoplasma wenyonii	65123	Bacteria	Bacteria	305	1.76e-78	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g95407	i0	91.189	1.65217391304348	227	17	82	2	51	274	191568	191794	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	456	305	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
14246471	14246471	PRJNA1111448_S_NODE_129132_length_246_cov_1.335260_g128309_i0	PRJNA1111448	129132	246	1.33526	3.2847396	Mycoplasma wenyonii	65123	Bacteria	Bacteria	283	7.239999999999999e-72	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g128309	i0	88.889	0.951219512195122	234	20	93	5	19	246	37787	38020	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	234	283	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
16795541	16795541	PRJNA1111448_S_NODE_89414_length_284_cov_1.094787_g88591_i0	PRJNA1111448	89414	284	1.094787	3.10919508	Mycoplasma ovis	171632	Bacteria	Bacteria	337	6.46e-88	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g88591	i0	88.028	4.63380281690141	284	34	100	0	1	284	33499	33216	Mycoplasma ovis str. Michigan, complete genome	blastn	1316	337	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
18069027	18069027	PRJNA1111448_S_NODE_116235_length_255_cov_1.269231_g115412_i0	PRJNA1111448	116235	255	1.269231	3.23653905	Mycoplasma wenyonii	65123	Bacteria	Bacteria	311	3.46e-80	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g115412	i0	88.627	1.82352941176471	255	29	100	0	1	255	330938	331192	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	465	311	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
20618608	20618608	PRJNA1111448_S_NODE_123377_length_249_cov_1.750000_g122554_i0	PRJNA1111448	123377	249	1.75	4.3575	Mycoplasma wenyonii	65123	Bacteria	Bacteria	268	2.06e-67	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g122554	i0	86.29	0.995983935742972	248	33	99	1	1	247	501550	501303	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	248	268	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24443238	24443238	PRJNA1111448_S_NODE_100660_length_271_cov_1.166667_g99837_i0	PRJNA1111448	100660	271	1.166667	3.16166757	Mycoplasma wenyonii	65123	Bacteria	Bacteria	357	4.7e-94	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g99837	i0	90.288	1.02583025830258	278	20	100	3	1	271	463523	463246	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	278	357	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);;