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

8 rows where analysis = "blastn", bioproject = "PRJNA977246" 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_genus	tax_species
950973	950973	PRJNA977246_S_NODE_19181_length_319_cov_2.993103_g18189_i0	PRJNA977246	19181	319	2.993103	9.54799857	Minisyncoccota bacterium	2053589	Bacteria	Bacteria	311	4.47e-80	NTclustered	gi\|2556886971\|gb\|CP129473.1\|	2053589	g18189	i0	84.858	114.984326018809	317	39	97	8	3	313	443662	443975	MAG: Candidatus Paceibacterota bacterium isolate cMAG.23 chromosome, complete genome	blastn	36680	311	1	Bacteria	Bacteria candidate phyla	Minisyncoccota			Minisyncoccota bacterium
951797	951797	PRJNA977246_S_NODE_8381_length_538_cov_8.754420_g7522_i0	PRJNA977246	8381	538	8.75442	47.0987796	uncultured candidate division SR1 bacterium	221237	Bacteria	Bacteria	580	5.4499999999999985e-161	NTclustered	gi\|336020567\|gb\|JF917288.1\|	221237	g7522	i0	88.32	94.1486988847584	488	52	90	5	53	538	115	599	Uncultured candidate division SR1 bacterium clone B1Q1E-91f-JRD28 16S ribosomal RNA gene, partial sequence	blastn	50652	580	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota			uncultured candidate division SR1 bacterium
4779413	4779413	PRJNA977246_S_NODE_26664_length_249_cov_3.595455_g25672_i0	PRJNA977246	26664	249	3.595455	8.95268295	candidate division TM6 bacterium GW2011_GWF2_28_16	1619077	Bacteria	Bacteria	261	3.44e-65	NTclustered	gi\|837367205\|gb\|CP011212.1\|	1619077	g25672	i0	86.475	64.5502008032128	244	26	95	5	1	237	133935	134178	Candidate division TM6 bacterium GW2011_GWF2_28_16 chromosome, complete genome	blastn	16073	261	1	Bacteria	Bacteria candidate phyla				candidate division TM6 bacterium GW2011_GWF2_28_16
6054972	6054972	PRJNA977246_S_NODE_4605_length_763_cov_11.337875_g4013_i0	PRJNA977246	4605	763	11.337875	86.50798625	candidate division SR1 bacterium RAAC1_SR1_1	1394709	Bacteria	Bacteria	804	0	NTclustered	gi\|563351663\|gb\|CP006913.1\|	1394709	g4013	i0	86.28	88.0943643512451	758	83	98	20	1	746	128834	129582	Candidate division SR1 bacterium RAAC1_SR1_1 chromosome, complete genome	blastn	67216	804	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota			candidate division SR1 bacterium RAAC1_SR1_1
9879216	9879216	PRJNA977246_S_NODE_23248_length_277_cov_11.588710_g22256_i0	PRJNA977246	23248	277	11.58871	32.1007267	Candidatus Mycosynbacter amalyticus	2665156	Bacteria	Bacteria	379	1.03e-100	NTclustered	gi\|1799615131\|gb\|CP045921.1\|	2665156	g22256	i0	91.697	74	277	18	99	3	5	277	217527	217252	Candidatus Mycosynbacter amalyticus isolate JR1 chromosome, complete genome	blastn	20498	379	1	Bacteria	Bacteria candidate phyla	Candidatus Saccharimonadota		Candidatus Mycosynbacter	Candidatus Mycosynbacter amalyticus
12430701	12430701	PRJNA977246_S_NODE_35010_length_201_cov_3.796512_g34018_i0	PRJNA977246	35010	201	3.796512	7.63098912	candidate division TM6 bacterium GW2011_GWF2_28_16	1619077	Bacteria	Bacteria	159	1e-34	NTclustered	gi\|837367205\|gb\|CP011212.1\|	1619077	g34018	i0	93.458	1.11442786069652	107	7	53	0	95	201	134302	134408	Candidate division TM6 bacterium GW2011_GWF2_28_16 chromosome, complete genome	blastn	224	159	1	Bacteria	Bacteria candidate phyla				candidate division TM6 bacterium GW2011_GWF2_28_16
21352998	21352998	PRJNA977246_S_NODE_16717_length_350_cov_3.716511_g15725_i0	PRJNA977246	16717	350	3.716511	13.0077885	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	213	1.43e-50	NTclustered	gi\|2258832001\|gb\|CP060225.1\|	2053688	g15725	i0	78.235	15.4257142857143	340	68	96	6	12	348	625929	626265	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-9 chromosome, complete genome	blastn	5399	213	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria		Candidatus Peribacteria bacterium
23904164	23904164	PRJNA977246_S_NODE_4599_length_764_cov_4.605442_g4007_i0	PRJNA977246	4599	764	4.605442	35.18557688	Candidatus Campbellbacteria bacterium	2026716	Bacteria	Bacteria	396	3.069999999999999e-105	NTclustered	gi\|1958034697\|gb\|CP064977.1\|	2026716	g4007	i0	78.493	33.8390052356021	637	113	82	24	1	624	449869	449244	MAG: Candidatus Campbellbacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.283_fly_man chromosome, complete genome	blastn	25853	396	1	Bacteria	Bacteria candidate phyla	Candidatus Campbelliibacteriota			Candidatus Campbellbacteria 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);;