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

7 rows where analysis = "blastn", bioproject = "PRJNA725806" and tax_clade = "PVC group"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
711742	711742	PRJNA725806_P_NODE_139421_length_174_cov_0.992701_g139119_i0	PRJNA725806	139421	174	0.99270099999999994	1.72729974	Luteolibacter luteus	2728835	Bacteria	Bacteria	255	1.04e-63	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g139119	i0	97.333	220.465517241379	150	4	86	0	25	174	3803514	3803663	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	38361	255	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
8365182	8365182	PRJNA725806_P_NODE_327_length_1066_cov_7.145773_g236_i0	PRJNA725806	327	1066	7.145773	76.17394018	Luteolibacter luteus	2728835	Bacteria	Bacteria	1799	0	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g236	i0	98.066	278.549718574109	1034	20	97	0	14	1047	3804911	3803878	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	296934	1799	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
13465644	13465644	PRJNA725806_P_NODE_30911_length_285_cov_1.552419_g30614_i0	PRJNA725806	30911	285	1.552419	4.42439415	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	488	1.6899999999999999e-133	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g30614	i0	97.544	92.7543859649123	285	7	100	0	1	285	623	907	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	26435	488	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
13948369	13948369	PRJNA725806_P_NODE_66711_length_227_cov_1.868421_g66411_i0	PRJNA725806	66711	227	1.868421	4.24131567	Bacteria	2	Bacteria	Bacteria	52.8	0.02	NTclustered	gi\|2126063867\|gb\|CP085689.1\|	2886196	g66411	i0	100	0.246696035242291	28	0	12	0	156	183	206049	206076	Lentisphaerae bacterium WC36 chromosome, complete genome	blastn	56	52.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota					Lentisphaerae bacterium WC36
18563776	18563776	PRJNA725806_P_NODE_90155_length_205_cov_1.255952_g89853_i0	PRJNA725806	90155	205	1.255952	2.5747016	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	281	2.1e-71	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g89853	i0	92	40.5219512195122	200	16	98	0	6	205	1600555	1600754	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	8307	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
19838702	19838702	PRJNA725806_P_NODE_134076_length_176_cov_5.719424_g133774_i0	PRJNA725806	134076	176	5.719424	10.06618624	Candidatus Uabimicrobium amorphum	2596890	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1732437785\|dbj\|AP019860.1\|	2596890	g133774	i0	92.308	0.221590909090909	39	2	22	1	112	150	2507158	2507195	Planctomycetes bacterium SRT547 DNA, complete genome	blastn	39	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium amorphum
24938404	24938404	PRJNA725806_P_NODE_540_length_883_cov_7.758865_g413_i0	PRJNA725806	540	883	7.758865	68.51077795	Maioricimonas rarisocia	2528026	Bacteria	Bacteria	63.9	4.11e-5	NTclustered	gi\|1712603021\|gb\|CP036275.1\|	2528026	g413	i0	97.297	18.2785956964892	37	1	4	0	270	306	1111013	1110977	Maioricimonas rarisocia strain Mal4 chromosome, complete genome	blastn	16140	63.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Maioricimonas	Maioricimonas rarisocia

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