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

8 rows where analysis = "blastn", bioproject = "PRJNA283169" 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
1646598	1646598	PRJNA283169_P_NODE_6802_length_167_cov_0.872881_g6739_i0	PRJNA283169	6802	167	0.872881	1.45771127	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	237	3.599999999999999e-58	NTclustered	gi\|2258865392\|gb\|CP060227.1\|	2052152	g6739	i0	92.216	28.9041916167665	167	13	100	0	1	167	431413	431247	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-22 chromosome, complete genome	blastn	4827	237	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
8025034	8025034	PRJNA283169_P_NODE_2907_length_243_cov_1.582474_g2844_i0	PRJNA283169	2907	243	1.582474	3.84541182	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	117	7.6600000000000005e-22	NTclustered	gi\|1958002018\|gb\|CP064958.1\|	2052152	g2844	i0	93.671	0.473251028806584	79	4	33	1	53	131	254865	254788	MAG: Candidatus Nomurabacteria bacterium isolate AalW_18-Q3-R10-53_BAT3C.395 chromosome, complete genome	blastn	115	117	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
10575740	10575740	PRJNA283169_P_NODE_5669_length_180_cov_1.106870_g5606_i0	PRJNA283169	5669	180	1.10687	1.992366	Candidatus Roizmanbacteria bacterium	2282149	Bacteria	Bacteria	270	3.87e-68	NTclustered	gi\|1958015594\|gb\|CP064967.1\|	2282149	g5606	i0	94.35	1.22777777777778	177	8	100	2	1	176	911893	912068	MAG: Candidatus Roizmanbacteria bacterium isolate Damh_18-Q3-R51-60_BAT3C.63_uni chromosome, complete genome	blastn	221	270	1	Bacteria	Bacteria candidate phyla	Candidatus Roizmaniibacteriota	Candidatus Roizmanbacteria bacterium
11850435	11850435	PRJNA283169_P_NODE_4970_length_191_cov_1.415493_g4907_i0	PRJNA283169	4970	191	1.415493	2.70359163	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	62.1	2.73e-5	NTclustered	gi\|2874253687\|emb\|OY969413.1\|	2030810	g4907	i0	91.304	0.240837696335079	46	3	24	1	136	180	367583	367628	MAG: Candidatus Kaiserbacteria bacterium isolate MFD01223.bin.1.23 genome assembly, chromosome: 1	blastn	46	62.1	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
16949192	16949192	PRJNA283169_S_NODE_3074_length_167_cov_0.152542_g3060_i0	PRJNA283169	3074	167	0.152542	0.25474514	Candidatus Giovannonibacteria bacterium	2053557	Bacteria	Bacteria	102	1.37e-17	NTclustered	gi\|1950811264\|gb\|CP066687.1\|	2053557	g3060	i0	86.316	32.8982035928144	95	11	76	2	75	167	310136	310042	MAG: Candidatus Giovannonibacteria bacterium isolate NC_groundwater_467_Ag_B-0.1um_47_26 chromosome	blastn	5494	102	1	Bacteria	Bacteria candidate phyla	Candidatus Giovannoniibacteriota	Candidatus Giovannonibacteria bacterium
18223498	18223498	PRJNA283169_P_NODE_8235_length_157_cov_2.388889_g8172_i0	PRJNA283169	8235	157	2.388889	3.75055573	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	104	3.53e-18	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g8172	i0	95.385	7.51592356687898	65	3	41	0	1	65	125420	125356	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	1180	104	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
23323810	23323810	PRJNA283169_P_NODE_3459_length_223_cov_1.160920_g3396_i0	PRJNA283169	3459	223	1.16092	2.5888516	Candidatus Woesebacteria bacterium	2026804	Bacteria	Bacteria	145	3.18e-30	NTclustered	gi\|1950815156\|gb\|CP066686.1\|	2026804	g3396	i0	82.941	0.762331838565022	170	20	74	5	9	174	767875	768039	MAG: Candidatus Woesebacteria bacterium isolate NC_groundwater_442_Ag_B-0.1um_40_41 chromosome	blastn	170	145	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota	Candidatus Woesebacteria bacterium
24597938	24597938	PRJNA283169_P_NODE_7980_length_162_cov_1.353982_g7917_i0	PRJNA283169	7980	162	1.353982	2.19345084	Patescibacteria group bacterium	2052139	Bacteria	Bacteria	93.5	7.94e-15	NTclustered	gi\|2556885218\|gb\|CP129471.1\|	2052139	g7917	i0	91.176	0.419753086419753	68	6	42	0	7	74	316718	316785	MAG: Patescibacteria group bacterium isolate cMAG.25 chromosome, complete genome	blastn	68	93.5	1	Bacteria	Bacteria candidate phyla		Patescibacteria group 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);;