metadata: contig_metadata: 7 rows where analysis = "blastn", bioproject = "PRJNA315314" and tax

7 rows where analysis = "blastn", bioproject = "PRJNA315314" 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_species
4207870	4207870	PRJNA315314_S_NODE_13684_length_220_cov_316.921466_g13363_i0	PRJNA315314	13684	220	316.921466	697.2272252	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	171	5.15e-38	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g13363	i0	83.684	528.359090909091	190	22	85	4	27	212	814170	813986	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	116239	171	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
5484293	5484293	PRJNA315314_S_NODE_21685_length_178_cov_2.859060_g21364_i0	PRJNA315314	21685	178	2.85906	5.0891268	Candidatus Woesebacteria bacterium GW2011_GWF1_31_35	1618600	Bacteria	Bacteria	115	1.89e-21	NTclustered	gi\|837352775\|gb\|CP011214.1\|	1618600	g21364	i0	91.667	114.61797752809	84	6	47	1	95	178	381031	380949	MAG: Candidatus Woesebacteria bacterium GW2011_GWF1_31_35 chromosome, complete genome	blastn	20402	115	1	Bacteria	Bacteria candidate phyla	Candidatus Woeseibacteriota		Candidatus Woesebacteria bacterium GW2011_GWF1_31_35
9308860	9308860	PRJNA315314_S_NODE_23968_length_170_cov_219.453901_g23647_i0	PRJNA315314	23968	170	219.453901	373.0716317	candidate division SR1 bacterium Aalborg_AAW-1	1643353	Bacteria	Bacteria	73.1	1.09e-8	NTclustered	gi\|821340791\|gb\|CP011268.1\|	1643353	g23647	i0	97.619	22.5470588235294	42	1	25	0	129	170	325790	325831	Candidate division SR1 bacterium Aalborg_AAW-1 chromosome, complete genome	blastn	3833	73.1	1	Bacteria	Bacteria candidate phyla	Candidatus Absconditibacteriota		candidate division SR1 bacterium Aalborg_AAW-1
13134630	13134630	PRJNA315314_S_NODE_27931_length_159_cov_9.830769_g27610_i0	PRJNA315314	27931	159	9.830769	15.63092271	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	178	2.08e-40	NTclustered	gi\|2874253936\|emb\|OY970261.1\|	2052149	g27610	i0	86.875	146.735849056604	160	19	100	2	1	159	3246830	3246988	MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.29 genome assembly, chromosome: 1	blastn	23331	178	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota		Candidatus Aminicenantes bacterium
18232282	18232282	PRJNA315314_S_NODE_1075_length_741_cov_84.654494_g858_i0	PRJNA315314	1075	741	84.654494	627.28980054	Candidatus Peribacteria bacterium	2053688	Bacteria	Bacteria	294	1.12e-74	NTclustered	gi\|2258833497\|gb\|CP060226.1\|	2053688	g858	i0	83.133	388.329284750337	332	46	73	8	19	348	813984	813661	MAG: Candidatus Peribacteria bacterium isolate HK-STAS-PATE-10 chromosome, complete genome	blastn	287752	294	1	Bacteria	Bacteria candidate phyla	Candidatus Peregrinibacteriota	Candidatus Peribacteria	Candidatus Peribacteria bacterium
19506734	19506734	PRJNA315314_S_NODE_18356_length_192_cov_7.533742_g18035_i0	PRJNA315314	18356	192	7.533742	14.46478464	Candidatus Poribacteria bacterium	2026781	Bacteria	Bacteria	104	4.5e-18	NTclustered	gi\|2575820324\|emb\|OY730443.1\|	2026781	g18035	i0	83.193	43.2864583333333	119	15	60	4	2	117	3464290	3464406	MAG: Candidatus Poribacteria bacterium isolate dbacca32-2332-4c09-a5ad-da9f5ab17b7d genome assembly, chromosome: 1	blastn	8311	104	1	Bacteria	Bacteria candidate phyla	Candidatus Poribacteria		Candidatus Poribacteria bacterium
22057486	22057486	PRJNA315314_S_NODE_4578_length_374_cov_6.837681_g4257_i0	PRJNA315314	4578	374	6.837681	25.57292694	Candidatus Aminicenantes bacterium	2052149	Bacteria	Bacteria	169	3.3899999999999996e-37	NTclustered	gi\|2874254063\|emb\|OY970122.1\|	2052149	g4257	i0	77.815	114.812834224599	302	47	77	18	1	288	2275286	2274991	MAG: Candidatus Aminicenantes bacterium isolate MFD04408.bin.1.13 genome assembly, chromosome: 1	blastn	42940	169	1	Bacteria	Bacteria candidate phyla	Candidatus Aminicenantota		Candidatus Aminicenantes 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);;