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

5 rows where analysis = "blastn", bioproject = "PRJNA1098727" 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
3570359	3570359	PRJNA1098727_P_NODE_5103_length_285_cov_1.351695_g4862_i0	PRJNA1098727	5103	285	1.351695	3.85233075	Tepidiforma	2682228	Bacteria	Bacteria	448	2.8699999999999997e-121	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g4862	i0	95.07	92.3473684210526	284	14	99	0	2	285	2204205	2204488	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	26319	448	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
4037836	4037836	PRJNA1098727_P_NODE_16224_length_157_cov_2.851852_g15983_i0	PRJNA1098727	16224	157	2.851852	4.47740764	Tepidiforma bonchosmolovskayae	2601677	Bacteria	Bacteria	222	9.329999999999999e-54	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g15983	i0	92.357	410.369426751592	157	10	99	2	1	156	2202510	2202355	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	64428	222	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
18871404	18871404	PRJNA1098727_P_NODE_16055_length_160_cov_2.306306_g15814_i0	PRJNA1098727	16055	160	2.306306	3.6900896	Tepidiforma	2682228	Bacteria	Bacteria	211	2.07e-50	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g15814	i0	90.625	86.025	160	13	99	2	1	159	2203881	2203723	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	13764	211	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
20146216	20146216	PRJNA1098727_P_NODE_6836_length_238_cov_2.671958_g6595_i0	PRJNA1098727	6836	238	2.671958	6.35926004	Tepidiforma	2682228	Bacteria	Bacteria	353	5.23e-93	NTclustered	gi\|1756502384\|gb\|CP042829.1\|	2601677	g6595	i0	93.644	162.844537815126	236	15	99	0	2	237	2204692	2204927	Tepidiforma bonchosmolovskayae strain 3753O chromosome, complete genome	blastn	38757	353	1	Bacteria	Bacillati	Chloroflexota	Tepidiformia	Tepidiformales	Tepidiformaceae	Tepidiforma	Tepidiforma bonchosmolovskayae
24437011	24437011	PRJNA1098727_P_NODE_7800_length_221_cov_1.488372_g7559_i0	PRJNA1098727	7800	221	1.488372	3.28930212	Roseiflexus sp. RS-1	357808	Bacteria	Bacteria	183	6.659999999999998e-42	NTclustered	gi\|470481958\|ref\|NR_076505.1\|	357808	g7559	i0	82.143	235.723981900452	224	30	99	9	1	218	518	737	Roseiflexus sp. RS-1 strain RS-1 23S ribosomal RNA, complete sequence	blastn	52095	183	1	Bacteria	Bacillati	Chloroflexota	Chloroflexia	Chloroflexales	Roseiflexaceae	Roseiflexus	Roseiflexus sp. RS-1

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