metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA976345" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA976345" 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
3498459	3498459	PRJNA976345_P_NODE_138723_length_171_cov_2.051471_g137115_i0	PRJNA976345	138723	171	2.051471	3.50801541	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	228	2.219999999999999e-55	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g137115	i0	91.071	288.701754385965	168	15	98	0	4	171	27443	27276	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	49368	228	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
3498560	3498560	PRJNA976345_P_NODE_153323_length_165_cov_1.415385_g151715_i0	PRJNA976345	153323	165	1.415385	2.33538525	Pedosphaera parvula	1032527	Bacteria	Bacteria	243	7.63e-60	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g151715	i0	94.839	13.8909090909091	155	8	94	0	1	155	1310	1464	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	2292	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
4776099	4776099	PRJNA976345_P_NODE_13324_length_468_cov_2.635104_g11752_i0	PRJNA976345	13324	468	2.635104	12.33228672	Aquisphaera giovannonii	406548	Bacteria	Bacteria	217	1.52e-51	NTclustered	gi\|1730068067\|gb\|CP042997.1\|	406548	g11752	i0	83.193	0.508547008547009	238	38	51	2	231	467	9202614	9202378	Aquisphaera giovannonii strain OJF2 chromosome, complete genome	blastn	238	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Aquisphaera	Aquisphaera giovannonii
8601757	8601757	PRJNA976345_P_NODE_77867_length_208_cov_1.595376_g76259_i0	PRJNA976345	77867	208	1.595376	3.31838208	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	307	3.52e-79	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g76259	i0	93.269	247.432692307692	208	14	100	0	1	208	16032	15825	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	51466	307	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
9876103	9876103	PRJNA976345_P_NODE_155448_length_164_cov_1.674419_g153840_i0	PRJNA976345	155448	164	1.674419	2.74604716	Gemmataceae bacterium	2052164	Bacteria	Bacteria	248	1.63e-61	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g153840	i0	93.902	1	164	10	100	0	1	164	1005132	1004969	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	164	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
9877056	9877056	PRJNA976345_P_NODE_88288_length_198_cov_3.429448_g86680_i0	PRJNA976345	88288	198	3.429448	6.79030704	Victivallaceae bacterium	2793042	Bacteria	Bacteria	52.8	0.017	NTclustered	gi\|2621704067\|emb\|OY761536.1\|	2793042	g86680	i0	100	0.141414141414141	28	0	14	0	139	166	3021920	3021893	MAG: Victivallaceae bacterium isolate e353ef71-700a-4510-b67c-5bed4426050c genome assembly, chromosome: 1	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Victivallales	Victivallaceae		Victivallaceae bacterium
12426919	12426919	PRJNA976345_P_NODE_121270_length_178_cov_2.426573_g119662_i0	PRJNA976345	121270	178	2.426573	4.31929994	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g119662	i0	100	0.162921348314607	29	0	16	0	150	178	3200882	3200854	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
17526042	17526042	PRJNA976345_P_NODE_158594_length_163_cov_1.250000_g156986_i0	PRJNA976345	158594	163	1.25	2.0375	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	65.8	1.75e-6	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g156986	i0	97.368	0.730061349693252	38	1	23	0	23	60	6442187	6442150	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	119	65.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
18799387	18799387	PRJNA976345_P_NODE_105115_length_186_cov_2.443709_g103507_i0	PRJNA976345	105115	186	2.443709	4.54529874	Bremerella sp. TYQ1	3119568	Bacteria	Bacteria	87.9	4.36e-13	NTclustered	gi\|2101355205\|gb\|CP083740.1\|	3119568	g103507	i0	84.884	0.462365591397849	86	13	46	0	1	86	6520934	6521019	Bremerella sp. TYQ1 chromosome, complete genome	blastn	86	87.9	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. TYQ1
18800103	18800103	PRJNA976345_P_NODE_26855_length_325_cov_2.379310_g25252_i0	PRJNA976345	26855	325	2.37931	7.7327575	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	412	1.2199999999999999e-110	NTclustered	gi\|2874254019\|emb\|OY970344.1\|	412056	g25252	i0	89.571	244.270769230769	326	33	100	1	1	325	735850	736175	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.c.3 genome assembly, chromosome: 1	blastn	79388	412	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
23900533	23900533	PRJNA976345_P_NODE_164659_length_160_cov_6.184000_g163051_i0	PRJNA976345	164659	160	6.184	9.8944	Lentisphaera profundi	1658616	Bacteria	Bacteria	54.7	0.004	NTclustered	gi\|2445967839\|gb\|CP117812.1\|	1658616	g163051	i0	100	0.18125	29	0	18	0	112	140	2068251	2068279	Lentisphaera profundi strain SAORIC-696 chromosome 2, complete sequence	blastn	29	54.7	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria	Lentisphaerales	Lentisphaeraceae	Lentisphaera	Lentisphaera profundi

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