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

8 rows where analysis = "blastn", bioproject = "PRJNA642647" and tax_phylum = "Candidatus Nomuraibacteriota"

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
5721499	5721499	PRJNA642647_P_NODE_1545_length_280_cov_2.016461_g1495_i0	PRJNA642647	1545	280	2.016461	5.6460908	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	302	2.32e-77	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g1495	i0	86.525	63.3714285714286	282	28	99	10	3	279	126188	125912	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	17744	302	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
9546601	9546601	PRJNA642647_P_NODE_5788_length_158_cov_4.165289_g5738_i0	PRJNA642647	5788	158	4.165289	6.58115662	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	95.3	2.14e-15	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g5738	i0	79.72	24.4620253164557	143	20	91	5	4	146	126787	126654	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	3865	95.3	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
12097431	12097431	PRJNA642647_P_NODE_4970_length_166_cov_2.961240_g4920_i0	PRJNA642647	4970	166	2.96124	4.9156584	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	75	2.97e-9	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g4920	i0	86.567	0.813253012048193	67	9	40	0	98	164	37454	37520	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	135	75	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
12097441	12097441	PRJNA642647_P_NODE_5810_length_158_cov_1.900826_g5760_i0	PRJNA642647	5810	158	1.900826	3.00330508	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	241	2.6e-59	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g5760	i0	94.304	259.96835443038	158	8	99	1	2	158	384208	384365	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	41075	241	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
14646896	14646896	PRJNA642647_P_NODE_2252_length_229_cov_1.255208_g2202_i0	PRJNA642647	2252	229	1.255208	2.87442632	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	224	4.09e-54	NTclustered	gi\|2258868658\|gb\|CP060229.1\|	2052152	g2202	i0	85.321	3.8296943231441	218	31	95	1	10	227	493623	493407	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-25 chromosome	blastn	877	224	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
17195915	17195915	PRJNA642647_P_NODE_1594_length_276_cov_3.108787_g1544_i0	PRJNA642647	1594	276	3.108787	8.58025212	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	233	8.439999999999999e-57	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g1544	i0	85.217	7.61231884057971	230	31	83	3	44	272	125828	126055	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	2101	233	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
18470235	18470235	PRJNA642647_P_NODE_3755_length_184_cov_2.931973_g3705_i0	PRJNA642647	3755	184	2.931973	5.39483032	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	196	6.849999999999999e-46	NTclustered	gi\|2258874150\|gb\|CP060230.1\|	2052152	g3705	i0	85.946	17.6739130434783	185	24	99	1	2	184	384179	384363	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-34 chromosome	blastn	3252	196	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
21020393	21020393	PRJNA642647_P_NODE_3937_length_181_cov_1.819444_g3887_i0	PRJNA642647	3937	181	1.819444	3.29319364	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	270	3.899999999999999e-68	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g3887	i0	94.798	10.2209944751381	173	9	96	0	6	178	429563	429735	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	1850	270	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria 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);;