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

5 rows where analysis = "blastn", bioproject = "PRJEB7799" and tax_clade = "Bacteria candidate phyla"

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_clade	tax_phylum	tax_species
25936566	25936566	PRJEB7799m_S_NODE_316_length_285_cov_5.236000_g311_i0	PRJEB7799	316	285	5.236	14.9226	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	257	5.2e-64	NTclustered	gi\|2874253756\|emb\|OY969696.1\|	2052149	g311	i0	85.433	108.736842105263	254	29	87	5	19	265	971491	971239	MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.14 genome assembly, chromosome: 1	blastn	30990	257	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes bacterium
25936646	25936646	PRJEB7799n_S_NODE_1604_length_332_cov_8.898990_g1567_i0	PRJEB7799	1604	332	8.89899	29.5446468	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	257	6.18e-64	NTclustered	gi\|2874253756\|emb\|OY969696.1\|	2052149	g1567	i0	85.433	99.6174698795181	254	29	74	5	45	291	971491	971239	MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.14 genome assembly, chromosome: 1	blastn	33073	257	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota	Candidatus Aminicenantes bacterium
26072945	26072945	PRJEB7799o_S_NODE_4541_length_155_cov_1.391667_g4533_i0	PRJEB7799	4541	155	1.391667	2.15708385	uncultured Candidatus Dependentiae bacterium	171954	Bacteria	Bacteria	217	4.2699999999999996e-52	NTclustered	gi\|22267331\|gb\|AY043958.1\|	171954	g4533	i0	97.619	80.9096774193548	126	3	81	0	1	126	1160	1285	Uncultured division TM6 bacterium clone NMW3.210WL 16S ribosomal RNA gene, partial sequence	blastn	12541	217	1	Bacteria	Bacteria candidate phyla		uncultured Candidatus Babelota bacterium
26345017	26345017	PRJEB7799o_S_NODE_3903_length_162_cov_2.425197_g3895_i0	PRJEB7799	3903	162	2.425197	3.92881914	uncultured Candidatus Dependentiae bacterium	171954	Bacteria	Bacteria	283	4.39e-72	NTclustered	gi\|22267112\|gb\|AY043739.1\|	171954	g3895	i0	98.148	98.8024691358025	162	3	100	0	1	162	743	904	Uncultured division TM6 bacterium clone NOS7.2WL 16S ribosomal RNA gene, partial sequence	blastn	16006	283	1	Bacteria	Bacteria candidate phyla		uncultured Candidatus Babelota bacterium
26478498	26478498	PRJEB7799a_S_NODE_14160_length_167_cov_3.643939_g14125_i0	PRJEB7799	14160	167	3.643939	6.08537813	uncultured Candidatus Dependentiae bacterium	171954	Bacteria	Bacteria	283	4.56e-72	NTclustered	gi\|22267331\|gb\|AY043958.1\|	171954	g14125	i0	98.742	93.502994011976	159	2	95	0	9	167	1240	1082	Uncultured division TM6 bacterium clone NMW3.210WL 16S ribosomal RNA gene, partial sequence	blastn	15615	283	1	Bacteria	Bacteria candidate phyla		uncultured Candidatus Babelota 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);;