metadata: contig_metadata: 13 rows where analysis = "blastn", bioproject = "PRJNA421571" and tax

13 rows where analysis = "blastn", bioproject = "PRJNA421571" 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
2361500	2361500	PRJNA421571_P_NODE_65902_length_317_cov_2.286885_g63353_i0	PRJNA421571	65902	317	2.286885	7.24942545	Caulifigura	2795778	Bacteria	Bacteria	542	1.45e-149	NTclustered	gi\|12583971\|gb\|AF245375.1\|AF245375	149590	g63353	i0	97.476	129.205047318612	317	8	100	0	1	317	895	1211	Planctomycete str. 658 23S ribosomal RNA gene, partial sequence	blastn	40958	547	0.990859232175503	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 658
4914232	4914232	PRJNA421571_P_NODE_75784_length_287_cov_1.761682_g73235_i0	PRJNA421571	75784	287	1.761682	5.05602734	Planctomycetia	203683	Bacteria	Bacteria	448	2.9e-121	NTclustered	gi\|1133581311\|gb\|CP019082.1\|	1387353	g73235	i0	94.81	317.369337979094	289	11	99	3	2	287	122779	123066	Paludisphaera borealis strain PX4 chromosome, complete genome	blastn	91085	451	0.993348115299335	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Paludisphaera	Paludisphaera borealis
9352515	9352515	PRJNA421571_P_NODE_96208_length_248_cov_0.880000_g93659_i0	PRJNA421571	96208	248	0.88	2.1824	Saltatorellus ferox	2528018	Bacteria	Bacteria	189	1.6399999999999996e-43	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g93659	i0	81.858	57.9072580645161	226	39	91	2	4	228	2331954	2332178	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	14361	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
11289512	11289512	PRJNA421571_P_NODE_87169_length_260_cov_2.871658_g84620_i0	PRJNA421571	87169	260	2.871658	7.4663108	Planctomyces	118	Bacteria	Bacteria	359	1.25e-94	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g84620	i0	91.635	144.55	263	16	100	5	1	260	5935802	5936061	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	37583	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
11903189	11903189	PRJNA421571_P_NODE_93970_length_250_cov_0.870056_g91421_i0	PRJNA421571	93970	250	0.870056	2.17514	Opitutus sp. GAS368	1882749	Bacteria	Bacteria	143	1.31e-29	NTclustered	gi\|1085764882\|emb\|LT629735.1\|	1882749	g91421	i0	78.855	68.248	227	37	89	8	1	223	2052656	2052437	Opitutus sp. GAS368 genome assembly, chromosome: I	blastn	17062	143	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. GAS368
14452964	14452964	PRJNA421571_P_NODE_80132_length_277_cov_0.970588_g77583_i0	PRJNA421571	80132	277	0.970588	2.68852876	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	324	4.89e-84	NTclustered	gi\|2874253779\|emb\|OY969763.1\|	412056	g77583	i0	88.806	117.635379061372	268	25	95	5	14	277	3833276	3833542	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04967.bin.c.2 genome assembly, chromosome: 1	blastn	32585	324	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15725668	15725668	PRJNA421571_P_NODE_42333_length_445_cov_1.913978_g39785_i0	PRJNA421571	42333	445	1.913978	8.5172021	Limnoglobus roseus	2598579	Bacteria	Bacteria	58.4	0.001	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g39785	i0	100	0.0696629213483146	31	0	7	0	59	89	7374518	7374488	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	31	58.4	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
16388756	16388756	PRJNA421571_P_NODE_88133_length_258_cov_2.064865_g85584_i0	PRJNA421571	88133	258	2.064865	5.3273517	Verrucomicrobiota	74201	Bacteria	Bacteria	335	2.079999999999999e-87	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g85584	i0	90.625	95.0736434108527	256	18	98	5	4	256	1244	992	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	24529	337	0.99406528189911	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
17001610	17001610	PRJNA421571_P_NODE_87194_length_260_cov_2.379679_g84645_i0	PRJNA421571	87194	260	2.379679	6.1871654	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	257	4.68e-64	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g84645	i0	85.385	2.88461538461538	260	24	99	7	4	260	1386366	1386118	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	750	257	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
18275347	18275347	PRJNA421571_P_NODE_65675_length_318_cov_1.885714_g63126_i0	PRJNA421571	65675	318	1.885714	5.99657052	Pedosphaera parvula	1032527	Bacteria	Bacteria	429	1.18e-115	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g63126	i0	91.195	141.74213836478	318	24	100	3	1	318	979	666	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	45074	429	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
18937775	18937775	PRJNA421571_P_NODE_95415_length_249_cov_0.875000_g92866_i0	PRJNA421571	95415	249	0.875	2.17875	Bacteria	2	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|2916408352\|gb\|CP170455.1\|	2052180	g92866	i0	92.5	0.321285140562249	40	0	16	2	149	188	235684	235648	MAG: Phycisphaerales bacterium isolate tig00000072 chromosome, complete genome	blastn	80	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			Phycisphaerales bacterium
20825392	20825392	PRJNA421571_P_NODE_64877_length_321_cov_1.552419_g62328_i0	PRJNA421571	64877	321	1.552419	4.98326499	Botrimarina mediterranea	2528022	Bacteria	Bacteria	54.7	0.008	NTclustered	gi\|1712762859\|gb\|CP036349.1\|	2528022	g62328	i0	100	0.177570093457944	29	0	9	0	92	120	4568598	4568626	Botrimarina mediterranea strain Spa11 chromosome	blastn	57	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Botrimarina	Botrimarina mediterranea
23376062	23376062	PRJNA421571_P_NODE_74599_length_290_cov_1.419355_g72050_i0	PRJNA421571	74599	290	1.419355	4.1161295	Anatilimnocola aggregata	2528021	Bacteria	Bacteria	270	6.81e-68	NTclustered	gi\|1712591889\|gb\|CP036274.1\|	2528021	g72050	i0	84.286	88.9379310344828	280	41	96	3	3	281	7379430	7379153	Anatilimnocola aggregata strain ETA_A8 chromosome, complete genome	blastn	25792	270	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Anatilimnocola	Anatilimnocola aggregata

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