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

8 rows where analysis = "blastn", bioproject = "PRJNA1101946" 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
211278	211278	PRJNA1101946_S_NODE_4321_length_323_cov_3.821168_g4222_i0	PRJNA1101946	4321	323	3.821168	12.34237264	Mycoplasma wenyonii	65123	Bacteria	Bacteria	368	2.65e-97	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g4222	i0	95.671	0.715170278637771	231	6	71	4	2	230	434790	434562	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	231	368	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
1485940	1485940	PRJNA1101946_S_NODE_27062_length_154_cov_3.400000_g26963_i0	PRJNA1101946	27062	154	3.4	5.236	Mycoplasma wenyonii	65123	Bacteria	Bacteria	174	2.59e-39	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g26963	i0	87.013	1.32467532467532	154	20	100	0	1	154	156174	156021	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	204	174	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
4037957	4037957	PRJNA1101946_S_NODE_10784_length_240_cov_2.136126_g10685_i0	PRJNA1101946	10784	240	2.136126	5.1267024	Mycoplasma wenyonii	65123	Bacteria	Bacteria	424	3.97e-114	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g10685	i0	98.739	0.991666666666667	238	3	99	0	1	238	172335	172572	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	238	424	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
5314143	5314143	PRJNA1101946_S_NODE_24585_length_163_cov_0.894737_g24486_i0	PRJNA1101946	24585	163	0.894737	1.45842131	Mycoplasma wenyonii	65123	Bacteria	Bacteria	279	5.73e-71	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g24486	i0	97.546	1	163	4	100	0	1	163	78341	78503	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	163	279	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
9138880	9138880	PRJNA1101946_S_NODE_21708_length_173_cov_1.645161_g21609_i0	PRJNA1101946	21708	173	1.645161	2.84612853	Mycoplasma sp. E35C	2801918	Bacteria	Bacteria	52.8	0.015	NTclustered	gi\|2089719294\|gb\|CP068418.1\|	2801918	g21609	i0	100	0.161849710982659	28	0	16	0	109	136	846583	846556	Mycoplasma sp. E35C chromosome, complete genome	blastn	28	52.8	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma sp. E35C
19337108	19337108	PRJNA1101946_S_NODE_7816_length_271_cov_5.927928_g7717_i0	PRJNA1101946	7816	271	5.927928	16.06468488	Mycoplasma wenyonii	65123	Bacteria	Bacteria	427	3.53e-115	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7717	i0	95.185	0.996309963099631	270	13	99	0	2	271	468724	468455	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	270	427	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
23163615	23163615	PRJNA1101946_S_NODE_7879_length_270_cov_9.877828_g7780_i0	PRJNA1101946	7879	270	9.877828	26.6701356	Mycoplasma wenyonii	65123	Bacteria	Bacteria	374	4.6499999999999986e-99	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g7780	i0	91.791	2.68148148148148	268	22	100	0	1	268	619840	620107	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	724	374	1	Bacteria	Bacillati	Mycoplasmatota	Mollicutes	Mycoplasmatales	Mycoplasmataceae	Mycoplasma	Mycoplasma wenyonii
24437171	24437171	PRJNA1101946_S_NODE_3360_length_345_cov_4.307432_g3261_i0	PRJNA1101946	3360	345	4.307432	14.8606404	Mycoplasma wenyonii	65123	Bacteria	Bacteria	564	3.3899999999999995e-156	NTclustered	gi\|395455868\|gb\|CP003703.1\|	1197325	g3261	i0	96.232	1	345	12	99	1	1	344	447029	447373	Mycoplasma wenyonii str. Massachusetts, complete genome	blastn	345	564	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);;