metadata: contig_metadata: 5 rows where bioproject = "PRJEB11748", tax_phylum = "Atribacterota" and tax

5 rows where bioproject = "PRJEB11748", tax_phylum = "Atribacterota" and tax_superkingdom = "Bacteria"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
12771609	12771609	PRJEB11748_P_NODE_315391_length_212_cov_5.086093_g313208_i0	PRJEB11748	315391	212	5.086093	10.78251716	Atribacter laminatus	2847778	Bacteria	Bacteria	313	7.74e-81	NTclustered	gi\|1940086973\|gb\|CP065383.1\|	2847778	g313208	i0	96.335	0.900943396226415	191	5	89	2	23	211	1819765	1819955	Atribacter laminatus strain RT761 chromosome, complete genome	blastn	191	313	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria	Atribacterales	Atribacteraceae	Atribacter	Atribacter laminatus
16595534	16595534	PRJEB11748_P_NODE_355754_length_195_cov_2.179104_g353571_i0	PRJEB11748	355754	195	2.179104	4.2492528	Atribacter laminatus	2847778	Bacteria	Bacteria	196	7.36e-46	NTclustered	gi\|1940086973\|gb\|CP065383.1\|	2847778	g353571	i0	87.209	0.882051282051282	172	22	88	0	24	195	1070145	1070316	Atribacter laminatus strain RT761 chromosome, complete genome	blastn	172	196	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria	Atribacterales	Atribacteraceae	Atribacter	Atribacter laminatus
27349252	27349252	PRJEB11748_P_NODE_357863_length_193_cov_26.128788_g355680_i0	PRJEB11748	357863	193	26.128788	50.42856084	Candidatus Atribacteria bacterium	2053509	Bacteria	Bacteria	113	1.2e-28	NR	NLJ38763.1	2053509	g355680	i0	100	0.823834196891192	53	0	82.4	0	169	11	1	53	NLJ38763.1 hypothetical protein [Candidatus Atribacteria bacterium]	diamond	159	113	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria				Candidatus Atribacteria bacterium
27374684	27374684	PRJEB11748_P_NODE_388883_length_173_cov_4.535714_g386700_i0	PRJEB11748	388883	173	4.535714	7.84678522	Atribacter	2847777	Bacteria	Bacteria	109	2.1200000000000003e-27	NR	HOT05916.1	2847780	g386700	i0	91.2	1.97687861271676	57	5	98.8	0	173	3	183	239	HOT05916.1 ATP-binding cassette domain-containing protein [Atribacter sp.]	diamond	342	109	1	Bacteria	Pseudomonadati	Atribacterota	Atribacteria	Atribacterales	Atribacteraceae	Atribacter	Atribacter sp.
30917607	30917607	PRJEB11748_P_NODE_121494_length_376_cov_7.231746_g119318_i0	PRJEB11748	121494	376	7.231746	27.19136496	Candidatus Atribacteria bacterium HGW-Atribacteria-1	2013676	Bacteria	Bacteria	71.6	9.82e-12	NR	PKP57285.1	2013676	g119318	i0	33.9	1.8031914893617	112	71	89.4	2	35	370	166	274	PKP57285.1 MAG: hypothetical protein CVT91_10965 [Candidatus Atribacteria bacterium HGW-Atribacteria-1]	diamond	678	71.6	1	Bacteria	Pseudomonadati	Atribacterota					Candidatus Atribacteria bacterium HGW-Atribacteria-1

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