metadata: contig_metadata: 15 rows where analysis = "blastn", bioproject = "PRJNA1120771" and tax

15 rows where analysis = "blastn", bioproject = "PRJNA1120771" 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
276633	276633	PRJNA1120771_S_NODE_22841_length_248_cov_2.565854_g22441_i0	PRJNA1120771	22841	248	2.565854	6.36331792	Mycoplasma wenyonii	65123	Bacteria	Bacteria	387	5.409999999999998e-103	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g22441	i0	94.758	1	248	13	100	0	1	248	533596	533349	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	248	387	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
1028531	1028531	PRJNA1120771_S_NODE_11281_length_322_cov_3.186380_g10881_i0	PRJNA1120771	11281	322	3.18638	10.2601436	Mycoplasma	2093	Bacteria	Bacteria	483	9.039999999999999e-132	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g10881	i0	94.081	79.8944099378882	321	13	98	5	4	320	604794	605112	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	25726	484	0.997933884297521	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
2827242	2827242	PRJNA1120771_S_NODE_18543_length_269_cov_1.154867_g18143_i0	PRJNA1120771	18543	269	1.154867	3.10659223	Mycoplasma wenyonii	65123	Bacteria	Bacteria	475	1.2299999999999999e-129	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g18143	i0	98.513	1	269	4	100	0	1	269	389553	389821	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	269	475	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5379822	5379822	PRJNA1120771_S_NODE_32745_length_214_cov_1.520468_g32345_i0	PRJNA1120771	32745	214	1.520468	3.25380152	Mycoplasma wenyonii	65123	Bacteria	Bacteria	276	1.03e-69	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g32345	i0	91.5	0.934579439252336	200	17	93	0	1	200	506302	506501	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	200	276	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5379875	5379875	PRJNA1120771_S_NODE_8305_length_359_cov_2.202532_g7905_i0	PRJNA1120771	8305	359	2.202532	7.90708988	Mycoplasma ovis	171632	Bacteria	Bacteria	119	3.3100000000000003e-22	NTclustered	gi\|566058721\|gb\|CP006935.1\|	1415773	g7905	i0	84.746	0.328690807799443	118	18	33	0	1	118	144819	144936	Mycoplasma ovis str. Michigan, complete genome	blastn	118	119	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma ovis
7929565	7929565	PRJNA1120771_S_NODE_32047_length_216_cov_1.005780_g31647_i0	PRJNA1120771	32047	216	1.00578	2.1724848	Mycoplasma wenyonii	65123	Bacteria	Bacteria	366	5.99e-97	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g31647	i0	97.222	1	216	6	100	0	1	216	140648	140433	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	216	366	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
10480327	10480327	PRJNA1120771_S_NODE_38149_length_196_cov_6.215686_g37749_i0	PRJNA1120771	38149	196	6.215686	12.18274456	Mycoplasma wenyonii	65123	Bacteria	Bacteria	211	2.64e-50	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g37749	i0	86.154	1.9234693877551	195	27	99	0	2	196	341311	341505	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	377	211	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
11755215	11755215	PRJNA1120771_S_NODE_33370_length_212_cov_2.159763_g32970_i0	PRJNA1120771	33370	212	2.159763	4.57869756	Mycoplasma wenyonii	65123	Bacteria	Bacteria	381	2.0899999999999994e-101	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g32970	i0	99.057	1	212	2	100	0	1	212	36145	35934	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	212	381	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
13030305	13030305	PRJNA1120771_S_NODE_24331_length_242_cov_1.884422_g23931_i0	PRJNA1120771	24331	242	1.884422	4.56030124	Mycoplasma wenyonii	65123	Bacteria	Bacteria	357	4.13e-94	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g23931	i0	93.802	1	242	8	100	2	1	242	574461	574227	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	242	357	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
20678065	20678065	PRJNA1120771_S_NODE_23117_length_247_cov_1.867647_g22717_i0	PRJNA1120771	23117	247	1.867647	4.61308809	Mycoplasma haemocanis	136241	Bacteria	Bacteria	158	4.6e-34	NTclustered	gi\|363988676\|gb\|CP003199.1\|	1111676	g22717	i0	92.105	1.38461538461538	114	6	46	3	11	123	676071	676182	Mycoplasma haemocanis str. Illinois, complete genome	blastn	342	158	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma haemocanis
23228986	23228986	PRJNA1120771_S_NODE_32579_length_214_cov_3.567251_g32179_i0	PRJNA1120771	32579	214	3.567251	7.63391714	Mycoplasma wenyonii	65123	Bacteria	Bacteria	183	6.41e-42	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g32179	i0	82.16	0.995327102803738	213	38	99	0	1	213	440034	440246	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	213	183	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23229048	23229048	PRJNA1120771_S_NODE_7879_length_365_cov_3.860248_g7479_i0	PRJNA1120771	7879	365	3.860248	14.0899052	Mycoplasma wenyonii	65123	Bacteria	Bacteria	593	4.59e-165	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7479	i0	97.953	1.09041095890411	342	7	94	0	1	342	537144	537485	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	398	593	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24502599	24502599	PRJNA1120771_S_NODE_31920_length_216_cov_2.479769_g31520_i0	PRJNA1120771	31920	216	2.479769	5.35630104	Mycoplasma wenyonii	65123	Bacteria	Bacteria	394	2.75e-105	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g31520	i0	99.537	1	216	1	100	0	1	216	157824	157609	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	216	394	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24502611	24502611	PRJNA1120771_S_NODE_33300_length_212_cov_3.248521_g32900_i0	PRJNA1120771	33300	212	3.248521	6.88686452	Mycoplasma wenyonii	65123	Bacteria	Bacteria	339	1.28e-88	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g32900	i0	96.569	0.962264150943396	204	7	96	0	9	212	571146	571349	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	204	339	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24502635	24502635	PRJNA1120771_S_NODE_37140_length_200_cov_2.515924_g36740_i0	PRJNA1120771	37140	200	2.515924	5.031848	Mycoplasma wenyonii	65123	Bacteria	Bacteria	348	1.98e-91	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g36740	i0	98	1.8	200	4	100	0	1	200	548866	549065	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	360	348	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);;