metadata: contig_metadata: 22 rows where analysis = "blastn", bioproject = "PRJNA473824" and tax

22 rows where analysis = "blastn", bioproject = "PRJNA473824" 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
1721598	1721598	PRJNA473824_P_NODE_29782_length_218_cov_2.983425_g29144_i0	PRJNA473824	29782	218	2.983425	6.5038665	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	54.7	0.005	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g29144	i0	94.286	0.160550458715596	35	2	16	0	147	181	5234344	5234310	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	35	54.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
2996851	2996851	PRJNA473824_P_NODE_118903_length_172_cov_0.800000_g118265_i0	PRJNA473824	118903	172	0.8	1.376	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	211	2.25e-50	NTclustered	gi\|2874253749\|emb\|OY969623.1\|	1914239	g118265	i0	88.764	162.81976744186	178	13	100	5	1	172	7050918	7050742	MAG: uncultured Gemmataceae bacterium isolate MFD06742.bin.c.1 genome assembly, chromosome: 1	blastn	28005	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
2997251	2997251	PRJNA473824_P_NODE_164763_length_150_cov_4.716814_g164125_i0	PRJNA473824	164763	150	4.716814	7.075221	Blastopirellula sp. J2-11	2943192	Bacteria	Bacteria	60.2	7.3e-5	NTclustered	gi\|2283101653\|gb\|CP097384.1\|	2943192	g164125	i0	85.965	0.38	57	7	37	1	91	146	3248405	3248461	Blastopirellula sp. J2-11 chromosome	blastn	57	60.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Blastopirellula	Blastopirellula sp. J2-11
2998002	2998002	PRJNA473824_P_NODE_82203_length_173_cov_3.308824_g81565_i0	PRJNA473824	82203	173	3.308824	5.72426552	Mucisphaera calidilacus	2527982	Bacteria	Bacteria	67.6	5.19e-7	NTclustered	gi\|1712644202\|gb\|CP036280.1\|	2527982	g81565	i0	93.333	1.08670520231214	45	3	26	0	120	164	437256	437212	Mucisphaera calidilacus strain Pan265 chromosome, complete genome	blastn	188	67.6	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae	Mucisphaera	Mucisphaera calidilacus
4274107	4274107	PRJNA473824_P_NODE_53544_length_173_cov_6.316176_g52906_i0	PRJNA473824	53544	173	6.316176	10.92698448	Gemmata sp. SH-PL17	1630693	Bacteria	Bacteria	62.1	2.41e-5	NTclustered	gi\|1015440974\|gb\|CP011271.1\|	1630693	g52906	i0	88.462	0.531791907514451	52	4	29	2	107	157	5399457	5399407	Gemmata sp. SH-PL17, complete genome	blastn	92	62.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata sp. SH-PL17
5550045	5550045	PRJNA473824_P_NODE_146425_length_151_cov_4.175439_g145787_i0	PRJNA473824	146425	151	4.175439	6.30491289	Oleiharenicola sp. Vm1	3398393	Bacteria	Bacteria	67.6	4.4e-7	NTclustered	gi\|2912653302\|gb\|CP180537.1\|	3398393	g145787	i0	100	0.47682119205298	36	0	24	0	41	76	4517732	4517767	Oleiharenicola sp. Vm1 chromosome, complete genome	blastn	72	67.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Oleiharenicola	Oleiharenicola sp. Vm1
8099379	8099379	PRJNA473824_P_NODE_130207_length_157_cov_8.616667_g129569_i0	PRJNA473824	130207	157	8.616667	13.52816719	Limnoglobus roseus	2598579	Bacteria	Bacteria	141	2.69e-29	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g129569	i0	83.226	1.80891719745223	155	24	98	2	2	155	5748933	5748780	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	284	141	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
8100124	8100124	PRJNA473824_P_NODE_46647_length_180_cov_2.944056_g46009_i0	PRJNA473824	46647	180	2.944056	5.2993008	Congregicoccus parvus	3081749	Bacteria	Bacteria	80.5	7e-11	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g46009	i0	90.164	0.338888888888889	61	6	34	0	1	61	290932	290872	Opitutales bacterium ASA1 DNA, complete genome	blastn	61	80.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
11299893	11299893	PRJNA473824_P_NODE_7249_length_525_cov_1.946721_g6674_i0	PRJNA473824	7249	525	1.946721	10.22028525	Verrucomicrobiota	74201	Bacteria	Bacteria	525	2.5199999999999995e-144	NTclustered	gi\|183579829\|emb\|AM905426.1\|	320771	g6674	i0	84.82	90.3352380952381	527	75	100	5	1	525	737	214	Bacterium Ellin514 23S rRNA gene, isolate Ellin514	blastn	47426	525	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Pedosphaerae	Pedosphaerales	Pedosphaeraceae	Pedosphaera	Pedosphaera parvula
11925873	11925873	PRJNA473824_P_NODE_75550_length_173_cov_3.617647_g74912_i0	PRJNA473824	75550	173	3.617647	6.25852931	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	119	1.4100000000000001e-22	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g74912	i0	94.737	15.5086705202312	76	4	44	0	1	76	153852	153927	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	2683	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
13200762	13200762	PRJNA473824_P_NODE_55271_length_173_cov_5.720588_g54633_i0	PRJNA473824	55271	173	5.720588	9.89661724	Roseimicrobium sp. ORNL1	2711231	Bacteria	Bacteria	89.8	1.11e-13	NTclustered	gi\|1815841271\|gb\|CP049143.1\|	2711231	g54633	i0	88	0.433526011560694	75	9	43	0	2	76	1908904	1908978	Roseimicrobium sp. ORNL1 chromosome, complete genome	blastn	75	89.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Roseimicrobium	Roseimicrobium sp. ORNL1
14475253	14475253	PRJNA473824_P_NODE_22212_length_251_cov_1.219626_g21574_i0	PRJNA473824	22212	251	1.219626	3.06126126	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	394	3.28e-105	NTclustered	gi\|218533792\|gb\|FJ490306.1\|	120965	g21574	i0	94.34	88.199203187251	265	1	100	4	1	251	392	128	Uncultured planctomycete clone E_29 16S ribosomal RNA gene, partial sequence	blastn	22138	394	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
14475335	14475335	PRJNA473824_P_NODE_27632_length_226_cov_1.507937_g26994_i0	PRJNA473824	27632	226	1.507937	3.40793762	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	311	3.01e-80	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g26994	i0	91.102	107.553097345133	236	11	100	4	1	226	5936385	5936620	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	24307	311	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14475447	14475447	PRJNA473824_P_NODE_36912_length_199_cov_0.882716_g36274_i0	PRJNA473824	36912	199	0.882716	1.75660484	Luteolibacter sp.	1962973	Bacteria	Bacteria	224	3.4599999999999996e-54	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g36274	i0	86.935	67.0552763819096	199	26	100	0	1	199	1009915	1010113	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	13344	224	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
15748830	15748830	PRJNA473824_P_NODE_117273_length_172_cov_3.977778_g116635_i0	PRJNA473824	117273	172	3.977778	6.84177816	Kiritimatiella glycovorans	1307763	Bacteria	Bacteria	52.8	0.014	NTclustered	gi\|827038732\|gb\|CP010904.1\|	1307763	g116635	i0	100	0.162790697674419	28	0	16	0	7	34	928191	928218	Kiritimatiella glycovorans strain L21-Fru-AB chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Kiritimatiellota	Kiritimatiellia	Kiritimatiellales	Kiritimatiellaceae	Kiritimatiella	Kiritimatiella glycovorans
18298455	18298455	PRJNA473824_P_NODE_37775_length_197_cov_1.012500_g37137_i0	PRJNA473824	37775	197	1.0125	1.994625	Luteolibacter sp. AS25	3135776	Bacteria	Bacteria	270	4.33e-68	NTclustered	gi\|2889346039\|gb\|CP151837.1\|	3135776	g37137	i0	91.371	9.05583756345178	197	17	100	0	1	197	454776	454580	Luteolibacter sp. AS25 chromosome, complete genome	blastn	1784	270	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. AS25
18298867	18298867	PRJNA473824_P_NODE_88115_length_173_cov_3.132353_g87477_i0	PRJNA473824	88115	173	3.132353	5.41897069	Humisphaera borealis	2807512	Bacteria	Bacteria	163	6.43e-36	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g87477	i0	81.287	0.988439306358382	171	26	99	2	3	173	2899327	2899163	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	171	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
19571822	19571822	PRJNA473824_P_NODE_100496_length_173_cov_2.764706_g99858_i0	PRJNA473824	100496	173	2.764706	4.78294138	Congregicoccus parvus	3081749	Bacteria	Bacteria	56.5	0.001	NTclustered	gi\|2599616993\|dbj\|AP028972.1\|	3081749	g99858	i0	90.698	0.248554913294798	43	2	24	2	1	42	1725976	1726017	Opitutales bacterium ASA1 DNA, complete genome	blastn	43	56.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Alterococcaceae	Congregicoccus	Congregicoccus parvus
19571914	19571914	PRJNA473824_P_NODE_114216_length_173_cov_2.330882_g113578_i0	PRJNA473824	114216	173	2.330882	4.03242586	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	110	8.5e-20	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g113578	i0	93.243	229.508670520231	74	5	43	0	2	75	4419828	4419755	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	39705	110	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
19571952	19571952	PRJNA473824_P_NODE_118756_length_172_cov_1.770370_g118118_i0	PRJNA473824	118756	172	1.77037	3.0450364	Humisphaera borealis	2807512	Bacteria	Bacteria	198	1.7499999999999999e-46	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g118118	i0	87.5	396.825581395349	176	16	100	6	1	172	5064389	5064216	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	68254	198	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
20848046	20848046	PRJNA473824_P_NODE_14697_length_313_cov_1.699275_g14060_i0	PRJNA473824	14697	313	1.699275	5.31873075	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	327	4.339999999999999e-85	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g14060	i0	85.669	39.2492012779553	314	41	99	4	2	313	1830914	1830603	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	12285	327	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
22122741	22122741	PRJNA473824_P_NODE_125798_length_163_cov_4.460317_g125160_i0	PRJNA473824	125798	163	4.460317	7.27031671	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	76.8	8.06e-10	NTclustered	gi\|2621704341\|emb\|OY760937.1\|	2499141	g125160	i0	95.745	0.50920245398773	47	2	29	0	11	57	4325939	4325985	MAG: Verrucomicrobiae bacterium isolate 066a7682-a1ac-48de-8761-1470dc9e5c3e genome assembly, chromosome: 1	blastn	83	76.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;