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

13 rows where analysis = "blastn", bioproject = "PRJNA399711" 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
4908961	4908961	PRJNA399711_P_NODE_7484_length_213_cov_7.085227_g7418_i0	PRJNA399711	7484	213	7.085227	15.09153351	Pseudomonadati	3379134	Bacteria	Bacteria	80.5	8.6e-11	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g7418	i0	95.918	22.2441314553991	49	2	23	0	144	192	1925587	1925635	Opitutus terrae PB90-1, complete genome	blastn	4738	80.5	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
9341546	9341546	PRJNA399711_P_NODE_11248_length_190_cov_2.457516_g11182_i0	PRJNA399711	11248	190	2.457516	4.6692804	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	78.7	2.69e-10	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g11182	i0	95.918	1.52105263157895	49	1	26	1	139	187	864884	864837	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	289	78.7	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola
25563042	25563042	PRJNA399711_S_NODE_31713_length_234_cov_3.543147_g31571_i0	PRJNA399711	31713	234	3.543147	8.29096398	Akkermansia muciniphila	239935	Bacteria	Bacteria	54.7	0.006	NTclustered	gi\|1554474302\|gb\|CP025823.1\|	239935	g31571	i0	100	0.247863247863248	29	0	12	0	127	155	410818	410790	Akkermansia muciniphila strain EB-AMDK-7 chromosome, complete genome	blastn	58	54.7	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
25565303	25565303	PRJNA399711_S_NODE_93585_length_159_cov_0.959016_g93443_i0	PRJNA399711	93585	159	0.959016	1.52483544	Gemmataceae bacterium	2052164	Bacteria	Bacteria	134	4.5700000000000005e-27	NTclustered	gi\|2063814025\|emb\|LR586051.1\|	2052164	g93443	i0	82.781	7.11320754716981	151	24	94	2	10	159	3658678	3658529	Gemmata bacterium CJuql4 whole genome assembly and annotation	blastn	1131	134	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
25701220	25701220	PRJNA399711_S_NODE_85714_length_164_cov_1.519685_g85572_i0	PRJNA399711	85714	164	1.519685	2.4922834	Isosphaeraceae bacterium EP7	3139350	Bacteria	Bacteria	132	1.71e-26	NTclustered	gi\|2719878338\|gb\|CP151667.1\|	3139350	g85572	i0	90.816	0.597560975609756	98	9	60	0	1	98	5284056	5284153	Isosphaeraceae bacterium EP7 chromosome, complete genome	blastn	98	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium EP7
25835887	25835887	PRJNA399711_S_NODE_47019_length_203_cov_8.566265_g46877_i0	PRJNA399711	47019	203	8.566265	17.38951795	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	261	2.7000000000000007e-65	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g46877	i0	91.935	91.9064039408867	186	15	92	0	1	186	5171963	5171778	Lacipirellula limnantheis strain I41 chromosome	blastn	18657	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
25972112	25972112	PRJNA399711_S_NODE_45404_length_206_cov_3.650888_g45262_i0	PRJNA399711	45404	206	3.650888	7.52082928	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	80.5	8.26e-11	NTclustered	gi\|2874253903\|emb\|OY970228.1\|	100233	g45262	i0	84.524	2.04854368932039	84	9	40	2	93	174	4666888	4666969	MAG: uncultured Planctomycetaceae bacterium isolate MFD00731.bin.c.1 genome assembly, chromosome: 1	blastn	422	80.5	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
26109082	26109082	PRJNA399711_S_NODE_71133_length_175_cov_3.181159_g70991_i0	PRJNA399711	71133	175	3.181159	5.56702825	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	195	2.31e-45	NTclustered	gi\|226525339\|gb\|FJ872375.1\|	156588	g70991	i0	86.857	34.8342857142857	175	21	99	2	2	175	28443	28616	Uncultured Verrucomicrobia bacterium clone 286 genomic sequence	blastn	6096	195	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
26244572	26244572	PRJNA399711_S_NODE_52782_length_195_cov_3.772152_g52640_i0	PRJNA399711	52782	195	3.772152	7.3556964	Singulisphaera acidiphila DSM 18658	886293	Bacteria	Bacteria	224	3.369999999999999e-54	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g52640	i0	87.374	2.98974358974359	198	22	100	2	1	195	4804725	4804922	Singulisphaera acidiphila DSM 18658, complete genome	blastn	583	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
26244767	26244767	PRJNA399711_S_NODE_58150_length_188_cov_6.344371_g58008_i0	PRJNA399711	58150	188	6.344371	11.92741748	uncultured Verrucomicrobiota bacterium	156588	Bacteria	Bacteria	224	3.23e-54	NTclustered	gi\|226525288\|gb\|FJ872373.1\|	156588	g58008	i0	99.2	153.531914893617	125	0	66	1	1	124	15369	15493	Uncultured Verrucomicrobia bacterium clone 118 genomic sequence	blastn	28864	224	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					uncultured Verrucomicrobiota bacterium
26245115	26245115	PRJNA399711_S_NODE_67558_length_178_cov_6.000000_g67416_i0	PRJNA399711	67558	178	6	10.68	Stieleria varia	2528005	Bacteria	Bacteria	62.1	2.5e-5	NTclustered	gi\|2720418917\|gb\|CP151726.1\|	2528005	g67416	i0	97.222	1.38202247191011	36	1	21	0	131	166	155766	155801	Stieleria varia strain Pla52n chromosome, complete genome	blastn	246	62.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria varia
26379091	26379091	PRJNA399711_S_NODE_23479_length_260_cov_8.349776_g23337_i0	PRJNA399711	23479	260	8.349776	21.7094176	Opitutia bacterium KCR 482	3034326	Bacteria	Bacteria	60.2	1.42e-4	NTclustered	gi\|2707273910\|gb\|CP149973.1\|	3034326	g23337	i0	91.111	0.173076923076923	45	3	17	1	103	146	2219902	2219858	Opitutia bacterium KCR 482 chromosome, complete genome	blastn	45	60.2	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia				Opitutia bacterium KCR 482
26516398	26516398	PRJNA399711_S_NODE_47792_length_202_cov_5.109091_g47650_i0	PRJNA399711	47792	202	5.109091	10.32036382	Alienimonas californiensis	2527989	Bacteria	Bacteria	95.3	2.88e-15	NTclustered	gi\|1712468061\|gb\|CP036265.1\|	2527989	g47650	i0	88.75	0.396039603960396	80	6	39	3	62	139	1854549	1854627	Alienimonas californiensis strain CA12 chromosome	blastn	80	95.3	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Alienimonas	Alienimonas californiensis

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