metadata: contig_metadata: 5 rows where bioproject = "PRJNA1046144", tax_kingdom = "Bacillati" and tax

5 rows where bioproject = "PRJNA1046144", tax_kingdom = "Bacillati" and tax_phylum = "Chloroflexota"

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
19297831	19297831	PRJNA1046144_P_NODE_26716_length_322_cov_1.545455_g26421_i0	PRJNA1046144	26716	322	1.545455	4.9763651	uncultured Chloroflexota bacterium	166587	Bacteria	Bacteria	375	1.58e-99	NTclustered	gi\|374850026\|dbj\|AP011646.1\|	166587	g26421	i0	88.05	692.009316770186	318	37	98	1	3	319	1994	2311	Uncultured Chloroflexi bacterium DNA, fosmid clone: JFF004_B01	blastn	222827	375	1	Bacteria	Bacillati	Chloroflexota					uncultured Chloroflexota bacterium
28488104	28488104	PRJNA1046144_P_NODE_51607_length_244_cov_1.645714_g51312_i0	PRJNA1046144	51607	244	1.645714	4.01554216	Ktedonobacter sp.	1932716	Bacteria	Bacteria	47	0.00121	NR	HCI82275.1	1932716	g51312	i0	37.7	0.75	61	30	75	1	5	187	63	115	HCI82275.1 hypothetical protein [Ktedonobacter sp.]	diamond	183	47	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae	Ktedonobacter	Ktedonobacter sp.
29056495	29056495	PRJNA1046144_P_NODE_70968_length_219_cov_2.233333_g70673_i0	PRJNA1046144	70968	219	2.233333	4.89099927	Ktedonobacteraceae bacterium	2740538	Bacteria	Bacteria	130	2.3e-33	NR	HEY6287430.1	2740538	g70673	i0	87.5	1.97260273972603	72	9	98.6	0	217	2	347	418	HEY6287430.1 phospholipase D family protein [Ktedonobacteraceae bacterium]	diamond	432	130	1	Bacteria	Bacillati	Chloroflexota	Ktedonobacteria	Ktedonobacterales	Ktedonobacteraceae		Ktedonobacteraceae bacterium
30856686	30856686	PRJNA1046144_P_NODE_38614_length_275_cov_2.470874_g38319_i0	PRJNA1046144	38614	275	2.470874	6.7949035	Anaerolineales bacterium	2073117	Bacteria	Bacteria	75.5	4.12e-15	NR	MBL8094112.1	2073117	g38319	i0	83.3	0.458181818181818	42	7	45.8	0	273	148	69	110	MBL8094112.1 winged helix-turn-helix transcriptional regulator [Anaerolineales bacterium]	diamond	126	75.5	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium
31172385	31172385	PRJNA1046144_P_NODE_48675_length_250_cov_2.977901_g48380_i0	PRJNA1046144	48675	250	2.977901	7.4447525	Anaerolineales bacterium	2073117	Bacteria	Bacteria	87.8	4.05e-18	NR	MBV6392155.1	2073117	g48380	i0	52.9	3.048	85	37	98.4	1	5	250	277	361	MBV6392155.1 hypothetical protein [Anaerolineales bacterium]	diamond	762	87.8	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales			Anaerolineales bacterium

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