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

5 rows where analysis = "blastn", bioproject = "PRJNA797475" 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_class	tax_order	tax_family	tax_genus	tax_species
11420838	11420838	PRJNA797475_P_NODE_23049_length_249_cov_1.420455_g22950_i0	PRJNA797475	23049	249	1.420455	3.53693295	Candidatus Nanosynbacter	2093823	Bacteria	Bacteria	372	1.52e-98	NTclustered	gi\|1663054866\|gb\|CP040004.1\|	2572088	g22950	i0	93.574	2	249	16	100	0	1	249	237966	238214	Candidatus Nanosynbacter featherlites strain BB001 chromosome, complete genome	blastn	498	372	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter featherlites
12260967	12260967	PRJNA797475_P_NODE_27630_length_244_cov_0.900585_g27531_i0	PRJNA797475	27630	244	0.900585	2.1974274	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB	2933970	Bacteria	Bacteria	416	6.769999999999999e-112	NTclustered	gi\|2179907571\|gb\|CP090820.1\|	2933970	g27531	i0	97.541	1	244	5	100	1	1	244	669434	669192	MAG: Candidatus Nanosynbacter sp. HMT-348_TM7c-JB isolate JCVI_32_bin.19 chromosome, complete genome	blastn	244	416	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadia	Candidatus Nanosynbacterales	Candidatus Nanosynbacteraceae	Candidatus Nanosynbacter	Candidatus Nanosynbacter sp. HMT-348_TM7c-JB
16083925	16083925	PRJNA797475_P_NODE_21393_length_251_cov_0.865169_g21294_i0	PRJNA797475	21393	251	0.865169	2.17157419	uncultured Parcubacteria group bacterium	221218	Bacteria	Bacteria	442	1.1599999999999995e-119	NTclustered	gi\|28435960\|gb\|AY193202.1\|	221218	g21294	i0	98.406	92.9641434262948	251	4	100	0	1	251	647	897	Uncultured candidate division OD1 bacterium clone DA17 16S ribosomal RNA gene, partial sequence	blastn	23334	442	1	Bacteria	Bacteria candidate phyla						uncultured Parcubacteria group bacterium
17794685	17794685	PRJNA797475_P_NODE_28914_length_242_cov_1.822485_g28815_i0	PRJNA797475	28914	242	1.822485	4.4104137	Candidatus Nanosynbacteraceae	2093822	Bacteria	Bacteria	387	5.26e-103	NTclustered	gi\|2306607015\|emb\|OX335598.1\|	2026720	g28815	i0	95.455	164.818181818182	242	11	100	0	1	242	79863	79622	Candidatus Saccharibacteria bacterium isolate PRJEB56001 genome assembly, chromosome: contig00001	blastn	39886	387	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota					Candidatus Saccharimonadota bacterium
19908374	19908374	PRJNA797475_P_NODE_656_length_1124_cov_2.046622_g599_i0	PRJNA797475	656	1124	2.046622	23.00403128	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	2069	0	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g599	i0	99.911	433.44128113879	1123	1	99	0	2	1124	974537	973415	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	487188	2069	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);;