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

8 rows where analysis = "blastn", bioproject = "PRJNA773247" 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
749053	749053	PRJNA773247_P_NODE_3821_length_964_cov_5.941639_g3754_i0	PRJNA773247	3821	964	5.941639	57.27739996	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	959	0	NTclustered	gi\|1950821269\|gb\|CP066696.1\|	2026720	g3754	i0	84.974	93.6898340248963	945	142	98	0	18	962	485495	484551	Candidatus Saccharibacteria bacterium isolate NC_groundwater_1927_Pr3_S-0.2um_48_6 chromosome	blastn	90317	959	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
3300075	3300075	PRJNA773247_P_NODE_27143_length_267_cov_2.453608_g27059_i0	PRJNA773247	27143	267	2.453608	6.55113336	Candidatus Saccharimonadota bacterium	2026720	Bacteria	Bacteria	130	1.1e-25	NTclustered	gi\|1958070929\|gb\|CP064991.1\|	2026720	g27059	i0	97.368	24.7303370786517	76	2	28	0	22	97	608455	608380	Candidatus Saccharibacteria bacterium isolate Hirt_18-Q3-R61-65_BAT3C.362_fly chromosome, complete genome	blastn	6603	130	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharimonadota bacterium
12228665	12228665	PRJNA773247_P_NODE_30370_length_251_cov_0.865169_g30286_i0	PRJNA773247	30370	251	0.865169	2.17157419	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	300	7.36e-77	NTclustered	gi\|1958016626\|gb\|CP064968.1\|	2030810	g30286	i0	88.4	514.581673306773	250	27	99	2	1	249	954994	955242	MAG: Candidatus Kaiserbacteria bacterium isolate Damh_18-Q3-R51-60_MAXAC.235_fly chromosome, complete genome	blastn	129160	300	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
13502426	13502426	PRJNA773247_P_NODE_14471_length_393_cov_3.562500_g14387_i0	PRJNA773247	14471	393	3.5625	14.000625	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17	1619070	Bacteria	Bacteria	675	0	NTclustered	gi\|837350690\|gb\|CP011211.1\|	1619070	g14387	i0	98.433	0.974554707379135	383	6	97	0	1	383	517739	518121	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17, complete genome	blastn	383	675	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharibacteria bacterium GW2011_GWC2_44_17
13502488	13502488	PRJNA773247_P_NODE_18191_length_340_cov_3.591760_g18107_i0	PRJNA773247	18191	340	3.59176	12.211984	Candidatus Kaiserbacteria bacterium	2030810	Bacteria	Bacteria	320	7.97e-83	NTclustered	gi\|1950807631\|gb\|CP066682.1\|	2030810	g18107	i0	83.728	36.7205882352941	338	55	99	0	3	340	751192	751529	MAG: Candidatus Kaiserbacteria bacterium isolate NC_groundwater_79_Ag_B-0.1um_58_26 chromosome	blastn	12485	320	1	Bacteria	Bacteria candidate phyla	Candidatus Kaiseribacteriota	Candidatus Kaiserbacteria bacterium
15235441	15235441	PRJNA773247_P_NODE_11392_length_458_cov_2.145455_g11309_i0	PRJNA773247	11392	458	2.145455	9.8261839	Bacteria	2	Bacteria	Bacteria	399	1.3799999999999995e-106	NTclustered	gi\|563353835\|gb\|CP006915.1\|	1394711	g11309	i0	83.258	21.3471615720524	442	66	96	7	1	438	357493	357930	Candidatus Saccharibacteria bacterium RAAC3_TM7_1, complete genome	blastn	9777	399	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota	Candidatus Saccharibacteria bacterium RAAC3_TM7_1
18600765	18600765	PRJNA773247_P_NODE_33195_length_244_cov_4.356725_g33111_i0	PRJNA773247	33195	244	4.356725	10.630409	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	106	1.67e-18	NTclustered	gi\|2258828852\|gb\|CP060223.1\|	2052152	g33111	i0	92	15.2172131147541	75	6	31	0	93	167	926022	925948	MAG: Candidatus Nomurabacteria bacterium isolate HK-STAS-PATE-3 chromosome, complete genome	blastn	3713	106	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota	Candidatus Nomurabacteria bacterium
19875899	19875899	PRJNA773247_P_NODE_8996_length_533_cov_22.419565_g8913_i0	PRJNA773247	8996	533	22.419565	119.49628145	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	97.1	2.38e-15	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g8913	i0	86.022	0.283302063789869	93	10	17	3	275	364	395315	395407	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	151	97.1	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);;