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

9 rows where analysis = "blastn", bioproject = "PRJNA883229" 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
3410690	3410690	PRJNA883229_P_NODE_15503_length_243_cov_0.917647_g15457_i0	PRJNA883229	15503	243	0.917647	2.22988221	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	255	1.5600000000000001e-63	NTclustered	gi\|2189495548\|gb\|CP091727.1\|	2053569	g15457	i0	86.008	2.82716049382716	243	28	99	6	1	240	2157905	2158144	MAG: Lentisphaeria bacterium isolate nC33_lr_bin.207.fa chromosome	blastn	687	255	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
5963329	5963329	PRJNA883229_P_NODE_8725_length_253_cov_0.866667_g8679_i0	PRJNA883229	8725	253	0.866667	2.19266751	Candidatus Kuenenia stuttgartensis	174633	Bacteria	Bacteria	468	1.92e-127	NTclustered	gi\|91202367\|emb\|CT573072.1\|	174633	g8679	i0	100	3	253	0	100	0	1	253	724699	724951	Kuenenia stuttgartiensis genome fragment KUST_D (4 of 5)	blastn	759	468	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Brocadiaceae	Candidatus Kuenenia	Candidatus Kuenenia stuttgartensis
11063613	11063613	PRJNA883229_P_NODE_7409_length_268_cov_2.128205_g7363_i0	PRJNA883229	7409	268	2.128205	5.7035894	Pirellulales bacterium	2715253	Bacteria	Bacteria	134	8.520000000000001e-27	NTclustered	gi\|2874253964\|emb\|OY970289.1\|	2715253	g7363	i0	97.468	31.8358208955224	79	1	29	1	51	128	1506040	1506118	MAG: Pirellulales bacterium isolate MFD05442.bin.c.2 genome assembly, chromosome: 1	blastn	8532	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales			Pirellulales bacterium
11063640	11063640	PRJNA883229_P_NODE_9589_length_252_cov_0.871508_g9543_i0	PRJNA883229	9589	252	0.871508	2.19620016	Akkermansia muciniphila	239935	Bacteria	Bacteria	161	3.639999999999999e-35	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g9543	i0	80.365	42.4960317460317	219	37	86	5	34	249	2483658	2483873	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	10709	161	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
16543619	16543619	PRJNA883229_P_NODE_10893_length_250_cov_0.881356_g10847_i0	PRJNA883229	10893	250	0.881356	2.20339	Luteolibacter	518753	Bacteria	Bacteria	254	5.78e-63	NTclustered	gi\|1835317346\|gb\|CP051774.1\|	2728835	g10847	i0	85.774	98.412	239	34	96	0	1	239	5570417	5570655	Luteolibacter luteus strain G-1-1-1 chromosome, complete genome	blastn	24603	254	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter luteus
18711309	18711309	PRJNA883229_P_NODE_15535_length_243_cov_0.917647_g15489_i0	PRJNA883229	15535	243	0.917647	2.22988221	Roseimaritima ulvae	980254	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1727550343\|gb\|CP042914.1\|	980254	g15489	i0	100	0.119341563786008	29	0	12	0	215	243	2613845	2613817	Roseimaritima ulvae strain UC8 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Roseimaritima	Roseimaritima ulvae
21261965	21261965	PRJNA883229_P_NODE_5897_length_290_cov_1.391705_g5851_i0	PRJNA883229	5897	290	1.391705	4.0359445	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	239	1.92e-58	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g5851	i0	82.069	70.4413793103448	290	43	98	6	6	290	3260428	3260143	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	20428	239	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
23812174	23812174	PRJNA883229_P_NODE_13839_length_246_cov_0.901734_g13793_i0	PRJNA883229	13839	246	0.901734	2.21826564	Nibricoccus aquaticus	2576891	Bacteria	Bacteria	165	2.74e-36	NTclustered	gi\|1243404978\|gb\|CP023344.1\|	2576891	g13793	i0	80.645	24.219512195122	217	39	87	3	25	239	3493955	3494170	Nibricoccus aquaticus strain HZ-65 chromosome, complete genome	blastn	5958	165	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Nibricoccus	Nibricoccus aquaticus
25086025	25086025	PRJNA883229_P_NODE_15060_length_244_cov_0.912281_g15014_i0	PRJNA883229	15060	244	0.912281	2.22596564	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	195	3.46e-45	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g15014	i0	83.654	4.9672131147541	208	32	85	2	38	244	4013209	4013415	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	1212	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;