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

5 rows where analysis = "blastn", bioproject = "PRJNA1146029" 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
5393414	5393414	PRJNA1146029_P_NODE_3085_length_486_cov_1.292978_g2808_i0	PRJNA1146029	3085	486	1.292978	6.28387308	Candidatus Campbellbacteria bacterium GW2011_OD1_34_28	1618633	Bacteria	Bacteria	411	6.789999999999999e-110	NTclustered	gi\|837353685\|gb\|CP011215.1\|	1618633	g2808	i0	82.839	385.965020576132	472	67	96	14	1	465	8067	8531	MAG: Candidatus Campbellbacteria bacterium GW2011_OD1_34_28 chromosome, complete genome	blastn	187579	411	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota					Candidatus Campbellbacteria bacterium GW2011_OD1_34_28
15593005	15593005	PRJNA1146029_P_NODE_18853_length_246_cov_2.219653_g18572_i0	PRJNA1146029	18853	246	2.219653	5.46034638	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	237	5.72e-58	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g18572	i0	85.169	24.2357723577236	236	30	95	5	13	246	626284	626052	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	5962	237	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria				Candidatus Peribacteria bacterium
16867122	16867122	PRJNA1146029_P_NODE_12954_length_272_cov_1.211055_g12673_i0	PRJNA1146029	12954	272	1.211055	3.2940696	Candidatus Sumerlaea chitinivorans	2250252	Bacteria	Bacteria	56.5	0.002	NTclustered	gi\|1419285073\|gb\|CP030759.1\|	2250252	g12673	i0	100	0.213235294117647	30	0	11	0	1	30	1105850	1105879	Candidatus Sumerlaea chitinivorans isolate BY40 chromosome, complete genome	blastn	58	56.5	1	Bacteria	Bacteria candidate phyla	Candidatus Sumerlaeota	Candidatus Sumerlaeia	Candidatus Sumerlaeales	Candidatus Sumerlaeaceae	Candidatus Sumerlaea	Candidatus Sumerlaea chitinivorans
23242591	23242591	PRJNA1146029_P_NODE_5759_length_365_cov_1.845890_g5481_i0	PRJNA1146029	5759	365	1.84589	6.7374985	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	230	1.4899999999999995e-55	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g5481	i0	80.062	3.66575342465753	321	55	87	8	10	326	125737	126052	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	1338	230	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
24515868	24515868	PRJNA1146029_P_NODE_11300_length_282_cov_2.105263_g11019_i0	PRJNA1146029	11300	282	2.105263	5.93684166	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	477	3.6199999999999986e-130	NTclustered	gi\|2258875662\|gb\|CP060232.1\|	2052152	g11019	i0	97.163	179.202127659574	282	8	100	0	1	282	962496	962215	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-40 chromosome, complete genome	blastn	50535	477	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);;