metadata: contig_metadata: 9 rows where analysis = "blastn", bioproject = "PRJNA983848" and tax

9 rows where analysis = "blastn", bioproject = "PRJNA983848" 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
4794359	4794359	PRJNA983848_P_NODE_107224_length_291_cov_1.431193_g101341_i0	PRJNA983848	107224	291	1.431193	4.16477163	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	538	1.6999999999999994e-148	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g101341	i0	100	1	291	0	100	0	1	291	281362	281072	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	291	538	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
4795682	4795682	PRJNA983848_P_NODE_145484_length_249_cov_0.886364_g139601_i0	PRJNA983848	145484	249	0.886364	2.20704636	Candidatus Dependentiae bacterium Noda2021	2891165	Bacteria	Bacteria	350	7.14e-92	NTclustered	gi\|2131577866\|dbj\|AP025250.1\|	2891165	g139601	i0	92	6.79919678714859	250	19	100	1	1	249	217867	217618	Candidatus Dependentiae bacterium Noda2021 DNA, complete genome	blastn	1693	350	1	Bacteria	Bacteria candidate phyla						Candidatus Dependentiae bacterium Noda2021
8624031	8624031	PRJNA983848_P_NODE_87767_length_327_cov_1.842520_g81884_i0	PRJNA983848	87767	327	1.84252	6.0250404	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	599	8.759999999999997e-167	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g81884	i0	99.694	98.6788990825688	327	1	100	0	1	327	503849	503523	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	32268	599	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis
11172867	11172867	PRJNA983848_P_NODE_46529_length_522_cov_9.581292_g40659_i0	PRJNA983848	46529	522	9.581292	50.01434424	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	965	0	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g40659	i0	100	92.0478927203065	522	0	100	0	1	522	973291	972770	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	48049	965	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
13721412	13721412	PRJNA983848_P_NODE_148671_length_247_cov_1.793103_g142788_i0	PRJNA983848	148671	247	1.793103	4.42896441	Vermiphilus pyriformis	1763547	Bacteria	Bacteria	457	4.05e-124	NTclustered	gi\|2207817285\|gb\|CP074345.1\|	1763547	g142788	i0	100	1	247	0	100	0	1	247	1092831	1092585	MAG: Vermiphilus pyriformis isolate TW-EDP1-1 chromosome, complete genome	blastn	247	457	1	Bacteria	Bacteria candidate phyla					Vermiphilus	Vermiphilus pyriformis
14998490	14998490	PRJNA983848_P_NODE_74432_length_362_cov_9.636678_g68549_i0	PRJNA983848	74432	362	9.636678	34.88477436	Candidatus Nomurabacteria bacterium	2052152	Bacteria	Bacteria	289	2.3999999999999994e-73	NTclustered	gi\|1958028780\|gb\|CP064973.1\|	2052152	g68549	i0	82.051	6.41988950276243	351	51	95	9	1	345	126120	125776	MAG: Candidatus Nomurabacteria bacterium isolate EsbW_18-Q3-R4-48_MAXAC.200_cln chromosome, complete genome	blastn	2324	289	1	Bacteria	Bacteria candidate phyla	Candidatus Nomuraibacteriota					Candidatus Nomurabacteria bacterium
18818284	18818284	PRJNA983848_P_NODE_113055_length_282_cov_3.913876_g107172_i0	PRJNA983848	113055	282	3.913876	11.03713032	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	387	6.279999999999998e-103	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g107172	i0	91.489	7.13829787234043	282	23	99	1	1	281	1250912	1250631	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	2013	387	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium 28_42_T64
20097519	20097519	PRJNA983848_P_NODE_88596_length_325_cov_2.261905_g82713_i0	PRJNA983848	88596	325	2.261905	7.35119125	Candidatus Gracilibacteria bacterium 28_42_T64	1862133	Bacteria	Bacteria	479	1.1799999999999993e-130	NTclustered	gi\|1769783243\|gb\|CP042461.1\|	1862133	g82713	i0	93.231	899.304615384615	325	22	100	0	1	325	1251283	1250959	Candidatus Gracilibacteria bacterium 28_42_T64 chromosome, complete genome	blastn	292274	479	1	Bacteria	Bacteria candidate phyla	Candidatus Altimarinota					Candidatus Gracilibacteria bacterium 28_42_T64
25196685	25196685	PRJNA983848_P_NODE_73380_length_366_cov_1.819113_g67497_i0	PRJNA983848	73380	366	1.819113	6.65795358	Candidatus Babela massiliensis	673862	Bacteria	Bacteria	597	3.559999999999998e-166	NTclustered	gi\|563405083\|emb\|HG793133.1\|	673862	g67497	i0	96.175	265.825136612022	366	13	99	1	1	365	502254	501889	Candidatus Babela massiliensis strain BABL1 complete genome	blastn	97292	597	1	Bacteria	Bacteria candidate phyla		Candidatus Babeliae	Candidatus Babeliales	Candidatus Babeliaceae	Candidatus Babela	Candidatus Babela massiliensis

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);;