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

5 rows where analysis = "blastn", bioproject = "PRJNA315399" 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
1657094	1657094	PRJNA315399_P_NODE_282222_length_179_cov_11.373239_g281774_i0	PRJNA315399	282222	179	11.373239	20.35809781	Dehalococcoidia bacterium	2026734	Bacteria	Bacteria	97.1	6.91e-16	NTclustered	gi\|2893358402\|emb\|OZ220693.1\|	2026734	g281774	i0	98.182	34.9217877094972	55	1	31	0	98	152	855776	855830	MAG: Dehalococcoidia bacterium isolate bb874fd2-ee0c-4288-94b4-44cbacb43f92 genome assembly, chromosome: 1	blastn	6251	97.1	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				Dehalococcoidia bacterium
20784555	20784555	PRJNA315399_P_NODE_411777_length_160_cov_4.967480_g411329_i0	PRJNA315399	411777	160	4.96748	7.947968	Thermobaculum terrenum	166501	Bacteria	Bacteria	196	5.79e-46	NTclustered	gi\|269788783\|gb\|CP001825.1\|	525904	g411329	i0	92.414	0.90625	145	0	84	1	15	148	339283	339427	Thermobaculum terrenum ATCC BAA-798 chromosome 1, complete sequence	blastn	145	196	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
22061782	22061782	PRJNA315399_S_NODE_48118_length_217_cov_2.994444_g47917_i0	PRJNA315399	48118	217	2.994444	6.49794348	uncultured Dehalococcoidia bacterium	498747	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2531963198\|emb\|OY282441.1\|	498747	g47917	i0	100	0.133640552995392	29	0	13	0	102	130	3097337	3097309	MAG: uncultured Dehalococcoidia bacterium genome assembly, chromosome: 1	blastn	29	54.7	1	Bacteria	Bacillati	Chloroflexota	Dehalococcoidia				uncultured Dehalococcoidia bacterium
23333473	23333473	PRJNA315399_P_NODE_148979_length_189_cov_3.296053_g148531_i0	PRJNA315399	148979	189	3.296053	6.22954017	Thermobaculum terrenum	166501	Bacteria	Bacteria	139	1.21e-28	NTclustered	gi\|269788783\|gb\|CP001825.1\|	525904	g148531	i0	97.531	0.783068783068783	81	2	78	0	97	177	1537665	1537745	Thermobaculum terrenum ATCC BAA-798 chromosome 1, complete sequence	blastn	148	139	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Candidatus Thermobaculales	Candidatus Thermobaculaceae	Thermobaculum	Thermobaculum terrenum
23336303	23336303	PRJNA315399_S_NODE_12099_length_328_cov_5.292096_g11898_i0	PRJNA315399	12099	328	5.292096	17.35807488	Leptolinea sp. HRD-7	2830982	Bacteria	Bacteria	575	1.4799999999999994e-159	NTclustered	gi\|2250018340\|dbj\|AP024710.1\|	2830982	g11898	i0	99.682	0.957317073170732	314	1	96	0	15	328	1727376	1727689	Leptolinea sp. HRD-7 DNA, complete genome	blastn	314	575	1	Bacteria	Bacillati	Chloroflexota	Anaerolineae	Anaerolineales	Anaerolineaceae	Leptolinea	Leptolinea sp. HRD-7

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