metadata: contig_metadata: 16 rows where analysis = "blastn", bioproject = "PRJNA358490" and tax

16 rows where analysis = "blastn", bioproject = "PRJNA358490" 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
1673776	1673776	PRJNA358490_P_NODE_502_length_1632_cov_3.912743_g455_i0	PRJNA358490	502	1632	3.912743	63.85596576	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1509	0	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g455	i0	85.587	128.217524509804	1464	183	88	20	171	1610	4421417	4422876	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	209251	1509	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2949643	2949643	PRJNA358490_P_NODE_3303_length_787_cov_3.122995_g3090_i0	PRJNA358490	3303	787	3.122995	24.57797065	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	462	3.08e-125	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g3090	i0	89.037	94.9097839898348	374	39	87	2	415	787	632231	631859	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	74694	462	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
4226234	4226234	PRJNA358490_P_NODE_3184_length_803_cov_10.293194_g2977_i0	PRJNA358490	3184	803	10.293194	82.65434782	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	1007	0	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g2977	i0	90.064	175.657534246575	785	66	97	11	24	803	1830359	1831136	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	141053	1007	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
4901155	4901155	PRJNA358490_P_NODE_14984_length_183_cov_1.138889_g14640_i0	PRJNA358490	14984	183	1.138889	2.08416687	Engelhardtia	139931	Bacteria	Bacteria	135	1.5e-27	NTclustered	gi\|1712638177\|gb\|CP036287.1\|	2528011	g14640	i0	82.166	16.6010928961749	157	28	86	0	27	183	410860	411016	Planctomycetes bacterium Pla133 chromosome, complete genome	blastn	3038	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Engelhardtia	Engelhardtia mirabilis
5502686	5502686	PRJNA358490_P_NODE_5725_length_564_cov_1.695238_g5419_i0	PRJNA358490	5725	564	1.695238	9.56114232	Humisphaera borealis	2807512	Bacteria	Bacteria	283	1.81e-71	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g5419	i0	79.009	4.24290780141844	424	81	74	7	133	552	5794461	5794880	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	2393	283	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
6176178	6176178	PRJNA358490_P_NODE_10925_length_290_cov_2.195219_g10583_i0	PRJNA358490	10925	290	2.195219	6.3661351	Limnoglobus	2731450	Bacteria	Bacteria	344	3.959999999999999e-90	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g10583	i0	93.22	301.579310344828	236	12	81	4	37	270	318453	318686	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	87458	344	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
6776647	6776647	PRJNA358490_P_NODE_17186_length_159_cov_1.500000_g16842_i0	PRJNA358490	17186	159	1.5	2.385	Luteolibacter sp. Populi	3230487	Bacteria	Bacteria	196	5.75e-46	NTclustered	gi\|2774618348\|gb\|CP161812.1\|	3230487	g16842	i0	90.066	421.987421383648	151	15	95	0	2	152	3261583	3261433	Luteolibacter sp. Populi chromosome, complete genome	blastn	67096	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. Populi
6776649	6776649	PRJNA358490_P_NODE_17326_length_158_cov_1.252101_g16982_i0	PRJNA358490	17326	158	1.252101	1.97831958	Lacipirellula parvula	2650471	Bacteria	Bacteria	248	1.55e-61	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g16982	i0	94.937	37.9430379746835	158	8	100	0	1	158	5164059	5164216	Lacipirellula parvula PX69 DNA, complete genome	blastn	5995	248	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
8052332	8052332	PRJNA358490_P_NODE_487_length_1650_cov_3.726257_g440_i0	PRJNA358490	487	1650	3.726257	61.4832405	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	2037	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g440	i0	89.043	152.758181818182	1661	139	99	32	1	1637	5937647	5936006	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	252051	2037	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
10602780	10602780	PRJNA358490_P_NODE_1929_length_1010_cov_2.929969_g1789_i0	PRJNA358490	1929	1010	2.929969	29.5926869	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	686	0	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g1789	i0	79.3	3.74257425742574	1000	191	98	13	22	1010	110019	109025	Luteolibacter sp. LG18 DNA, complete genome	blastn	3780	686	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
11877682	11877682	PRJNA358490_P_NODE_16090_length_169_cov_1.569231_g15746_i0	PRJNA358490	16090	169	1.569231	2.65200039	Haloferula helveola	490095	Bacteria	Bacteria	91.6	2.99e-14	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g15746	i0	83.505	1.63313609467456	97	16	57	0	5	101	2179358	2179454	Haloferula helveola CN-1 DNA, complete genome	blastn	276	91.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
15701649	15701649	PRJNA358490_P_NODE_1433_length_1130_cov_16.079743_g1319_i0	PRJNA358490	1433	1130	16.079743	181.7010959	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	1295	0	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g1319	i0	90.622	321.958407079646	981	84	87	5	153	1130	2364712	2365687	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	363813	1295	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16976446	16976446	PRJNA358490_P_NODE_3294_length_788_cov_4.217623_g3083_i0	PRJNA358490	3294	788	4.217623	33.23486924	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	708	0	NTclustered	gi\|2874253793\|emb\|OY969777.1\|	412056	g3083	i0	86.76	263.121827411167	642	77	81	8	146	783	2364708	2365345	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01689.bin.c.1 genome assembly, chromosome: 1	blastn	207340	708	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
16976488	16976488	PRJNA358490_P_NODE_574_length_1567_cov_3.848822_g440_i1	PRJNA358490	574	1567	3.848822	60.31104074	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	1840	0	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g440	i1	90.968	157.498404594767	1384	100	87	21	187	1554	5937380	5936006	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	246800	1840	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
18250643	18250643	PRJNA358490_P_NODE_17275_length_158_cov_2.042017_g16931_i0	PRJNA358490	17275	158	2.042017	3.22638686	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	183	4.4399999999999996e-42	NTclustered	gi\|2874253948\|emb\|OY970273.1\|	100233	g16931	i0	88.235	3.0253164556962	153	18	97	0	6	158	2403247	2403399	MAG: uncultured Planctomycetaceae bacterium isolate MFD09495.bin.c.1 genome assembly, chromosome: 1	blastn	478	183	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
24625234	24625234	PRJNA358490_P_NODE_16860_length_162_cov_1.268293_g16516_i0	PRJNA358490	16860	162	1.268293	2.05463466	Luteolibacter sp. LG18	2819286	Bacteria	Bacteria	163	5.97e-36	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g16516	i0	85	74.8333333333333	160	24	99	0	1	160	5179506	5179347	Luteolibacter sp. LG18 DNA, complete genome	blastn	12123	163	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18

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