metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJEB11523" and tax

8 rows where analysis = "blastn", bioproject = "PRJEB11523" 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_genus	tax_species
6391925	6391925	PRJEB11523_P_NODE_7366_length_168_cov_7.268908_g7288_i0	PRJEB11523	7366	168	7.268908	12.21176544	Candidatus Levyibacteriota bacterium	2052151	Bacteria	Bacteria	104	3.84e-18	NTclustered	gi\|2874253967\|emb\|OY970292.1\|	2052151	g7288	i0	82.906	3.5952380952381	117	18	69	2	1	116	718814	718929	MAG: Candidatus Levybacteria bacterium isolate MFD01916.bin.c.8 genome assembly, chromosome: 1	blastn	604	104	1	Bacteria	Bacteria candidate phyla	Candidatus Levyibacteriota		Candidatus Levyibacteriota bacterium
10216545	10216545	PRJEB11523_P_NODE_6789_length_176_cov_2.283465_g6711_i0	PRJEB11523	6789	176	2.283465	4.0188984	Candidatus Saccharibacteria bacterium TM7i	2980174	Bacteria	Bacteria	220	3.85e-53	NTclustered	gi\|2306681518\|gb\|CP075337.1\|	2980174	g6711	i0	89.266	8.10795454545454	177	17	100	2	1	176	361090	361265	Candidatus Saccharibacteria bacterium TM7i chromosome, complete genome	blastn	1427	220	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Saccharibacteria bacterium TM7i
11491744	11491744	PRJEB11523_P_NODE_670_length_738_cov_37.985486_g607_i0	PRJEB11523	670	738	37.985486	280.33288668	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	876	0	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g607	i0	89.971	0.91869918699187	678	68	92	0	36	713	74085	74762	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	678	876	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
15315992	15315992	PRJEB11523_P_NODE_6833_length_175_cov_15.079365_g6755_i0	PRJEB11523	6833	175	15.079365	26.38888875	Candidatus Parcubacteria bacterium	2762014	Bacteria	Bacteria	69.4	1.46e-7	NTclustered	gi\|2314735967\|dbj\|AP024681.1\|	2762014	g6755	i0	100	0.211428571428571	37	0	21	0	116	152	167790	167754	MAG: Candidatus Parcubacteria bacterium KatS3mg097 DNA, complete genome	blastn	37	69.4	1	Bacteria	Bacteria candidate phyla	Candidatus Parcubacteria		Candidatus Parcubacteria bacterium
16590636	16590636	PRJEB11523_P_NODE_6834_length_175_cov_14.142857_g6756_i0	PRJEB11523	6834	175	14.142857	24.74999975	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	228	2.2799999999999996e-55	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g6756	i0	93.464	49.5828571428571	153	10	87	0	23	175	964795	964643	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	8677	228	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
17865527	17865527	PRJEB11523_P_NODE_6915_length_174_cov_15.312000_g6837_i0	PRJEB11523	6915	174	15.312	26.64288	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	202	1.3699999999999998e-47	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g6837	i0	90.728	0.867816091954023	151	14	87	0	3	153	163970	164120	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	151	202	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota		Candidatus Nomurabacteria bacterium
24239642	24239642	PRJEB11523_P_NODE_3500_length_262_cov_2.610329_g3422_i0	PRJEB11523	3500	262	2.610329	6.83906198	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	427	3.4e-115	NTclustered	gi\|1958015594\|gb\|CP064967.1\|	2282149	g3422	i0	98.75	0.916030534351145	240	3	92	0	1	240	839180	838941	MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome	blastn	240	427	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota		Candidatus Roizmanbacteria bacterium
24239674	24239674	PRJEB11523_P_NODE_6640_length_178_cov_2.767442_g6562_i0	PRJEB11523	6640	178	2.767442	4.92604676	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	152	1.4399999999999999e-32	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g6562	i0	84.375	24.5112359550562	160	19	88	5	1	157	972960	972804	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	4363	152	1	Bacteria	Bacteria candidate phyla		Vermiphilus	Vermiphilus pyriformis

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