metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA550047" and tax_phylum = "Synergistota"

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
6891587	6891587	PRJNA550047_P_NODE_224826_length_301_cov_8.807018_g222857_i0	PRJNA550047	224826	301	8.807018	26.50912418	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	355	1.91e-93	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g222857	i0	88.699	106.913621262458	292	32	97	1	1	292	70152	69862	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	32181	355	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
6894997	6894997	PRJNA550047_P_NODE_495986_length_231_cov_39.272152_g494013_i0	PRJNA550047	495986	231	39.272152	90.71867112	Synergistetes bacterium oral taxon 363	713037	Bacteria	Bacteria	422	1.37e-113	NTclustered	gi\|285800810\|gb\|GU410792.1\|	713037	g494013	i0	99.567	102.004329004329	231	1	100	0	1	231	29	259	Synergistetes bacterium oral taxon 363 clone AT057 16S ribosomal RNA gene, partial sequence	blastn	23563	422	1	Bacteria	Thermotogati	Synergistota					Synergistetes bacterium oral taxon 363
9442260	9442260	PRJNA550047_P_NODE_233108_length_301_cov_4.894737_g231139_i0	PRJNA550047	233108	301	4.894737	14.73315837	Fretibacterium fastidiosum	651822	Bacteria	Bacteria	525	1.3699999999999995e-144	NTclustered	gi\|2869663113\|emb\|OZ209244.1\|	651822	g231139	i0	98.328	499.063122923588	299	5	99	0	3	301	67852	68150	Fretibacterium fastidiosum strain SGP1 genome assembly, chromosome: Ff3	blastn	150218	525	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Aminobacteriaceae	Fretibacterium	Fretibacterium fastidiosum
12600389	12600389	PRJNA550047_P_NODE_402430_length_264_cov_5.989529_g400458_i0	PRJNA550047	402430	264	5.989529	15.81235656	Bacteria	2	Bacteria	Bacteria	486	5.579999999999999e-133	NTclustered	gi\|401555873\|gb\|JX010924.1\|	447826	g400458	i0	100	99.625	263	0	99	0	1	263	303	41	Uncultured Synergistetes bacterium clone 1P15 16S ribosomal RNA gene, partial sequence	blastn	26301	486	1	Bacteria	Thermotogati	Synergistota					uncultured Synergistota bacterium
19639160	19639160	PRJNA550047_P_NODE_149296_length_345_cov_4.764706_g147336_i0	PRJNA550047	149296	345	4.764706	16.4382357	Pyramidobacter piscolens	638849	Bacteria	Bacteria	63.9	1.51e-5	NTclustered	gi\|2188906985\|dbj\|AP025585.1\|	638849	g147336	i0	93.182	0.359420289855072	44	2	13	1	301	344	1075428	1075470	Pyramidobacter piscolens CE91-St28 DNA, complete genome	blastn	124	63.9	1	Bacteria	Thermotogati	Synergistota	Synergistia	Synergistales	Dethiosulfovibrionaceae	Pyramidobacter	Pyramidobacter piscolens

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);;