metadata: contig_metadata: 19 rows where analysis = "blastn", bioproject = "PRJNA1196438" and tax

19 rows where analysis = "blastn", bioproject = "PRJNA1196438" 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
1597986	1597986	PRJNA1196438_P_NODE_60662_length_257_cov_2.239130_g60235_i0	PRJNA1196438	60662	257	2.23913	5.7545641	Candidatus Piscichlamydia sp.	1977145	Bacteria	Bacteria	436	5.52e-118	NTclustered	gi\|1175896721\|gb\|KY380088.1\|	1977145	g60235	i0	98.776	95.8287937743191	245	3	95	0	13	257	403	647	Candidatus Piscichlamydia sp. strain EP 16S ribosomal RNA gene, partial sequence	blastn	24628	436	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Candidatus Piscichlamydiaceae	Candidatus Piscichlamydia	Candidatus Piscichlamydia sp.
3593878	3593878	PRJNA1196438_P_NODE_67983_length_249_cov_1.750000_g67556_i0	PRJNA1196438	67983	249	1.75	4.3575	PVC group	1783257	Bacteria	Bacteria	460	3.16e-125	NTclustered	gi\|337292513\|emb\|FR872621.1\|	765953	g67556	i0	100	60.9718875502008	249	0	100	0	1	249	1456	1208	Waddlia chondrophila 2032/99 annotated genome fragment, clone 1103163150273	blastn	15182	460	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Waddliaceae	Waddlia	Waddlia chondrophila
4149900	4149900	PRJNA1196438_P_NODE_31204_length_300_cov_5.911894_g30778_i0	PRJNA1196438	31204	300	5.911894	17.735682	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	470	6.5e-128	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g30778	i0	95	1	300	14	100	1	1	300	5899736	5900034	Lacipirellula limnantheis strain I41 chromosome	blastn	300	470	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
7976682	7976682	PRJNA1196438_P_NODE_57767_length_261_cov_2.776596_g57340_i0	PRJNA1196438	57767	261	2.776596	7.24691556	Chthoniobacter flavus	191863	Bacteria	Bacteria	333	7.589999999999999e-87	NTclustered	gi\|183579828\|emb\|AM905425.1\|	497964	g57340	i0	89.734	269.735632183908	263	23	100	4	1	261	1972	2232	Chthoniobacter flavus 23S rRNA gene, strain Ellin428	blastn	70401	333	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter flavus
9251149	9251149	PRJNA1196438_P_NODE_50968_length_271_cov_4.065657_g50541_i0	PRJNA1196438	50968	271	4.065657	11.01793047	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	279	1.05e-70	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g50541	i0	85.24	2.77121771217712	271	40	100	0	1	271	5818583	5818313	Planctomyces sp. SH-PL62, complete genome	blastn	751	279	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
11801408	11801408	PRJNA1196438_P_NODE_15730_length_312_cov_3.912134_g15304_i0	PRJNA1196438	15730	312	3.912134	12.20585808	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	67.6	1.04e-6	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g15304	i0	85.714	1.01923076923077	63	9	20	0	218	280	3176310	3176372	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	318	67.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
12522067	12522067	PRJNA1196438_P_NODE_59490_length_259_cov_1.672043_g59063_i0	PRJNA1196438	59490	259	1.672043	4.33059137	Neochlamydia	112987	Bacteria	Bacteria	289	1.65e-73	NTclustered	gi\|194594624\|gb\|EU662269.1\|	112235	g59063	i0	86.923	186.393822393822	260	30	99	4	2	259	1439	1182	Neochlamydia hartmannellae strain ATCC 50802 23S ribosomal RNA gene, partial sequence	blastn	48276	291	0.993127147766323	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Neochlamydia	Neochlamydia hartmannellae
13796662	13796662	PRJNA1196438_P_NODE_36791_length_294_cov_1.945701_g36365_i0	PRJNA1196438	36791	294	1.945701	5.72036094	Rubinisphaera	1649490	Bacteria	Bacteria	425	1.39e-114	NTclustered	gi\|470488120\|ref\|NR_076852.1\|	119	g36365	i0	97.581	165.520408163265	248	6	84	0	46	293	2038	2285	Planctomyces brasiliensis strain DSM 5305 23S ribosomal RNA gene, complete sequence	blastn	48663	425	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Rubinisphaera	Rubinisphaera brasiliensis
14352177	14352177	PRJNA1196438_P_NODE_46092_length_279_cov_2.165049_g45665_i0	PRJNA1196438	46092	279	2.165049	6.04048671	Urbifossiella limnaea	2528023	Bacteria	Bacteria	276	1.4e-69	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g45665	i0	86.454	1.61290322580645	251	34	96	0	29	279	4292957	4293207	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	450	276	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
15625657	15625657	PRJNA1196438_P_NODE_14793_length_312_cov_4.280335_g14367_i0	PRJNA1196438	14793	312	4.280335	13.3546452	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	233	9.71e-57	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g14367	i0	94.667	94.9839743589744	150	8	76	0	162	311	915059	914910	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	29635	233	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
15625934	15625934	PRJNA1196438_P_NODE_44613_length_281_cov_4.019231_g44186_i0	PRJNA1196438	44613	281	4.0192310000000004	11.29403911	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	143	1.49e-29	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g44186	i0	79.476	0.814946619217082	229	25	76	10	1	213	73547	73325	Planctomyces sp. SH-PL62, complete genome	blastn	229	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
15626218	15626218	PRJNA1196438_P_NODE_66313_length_251_cov_0.876404_g65886_i0	PRJNA1196438	66313	251	0.876404	2.19977404	Opitutus terrae	107709	Bacteria	Bacteria	130	1.02e-25	NTclustered	gi\|177839040\|gb\|CP001032.1\|	452637	g65886	i0	95.122	0.653386454183267	82	4	33	0	170	251	3854930	3854849	Opitutus terrae PB90-1, complete genome	blastn	164	130	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus terrae
18174472	18174472	PRJNA1196438_P_NODE_10635_length_326_cov_2.339921_g10209_i0	PRJNA1196438	10635	326	2.339921	7.62814246	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	318	2.74e-82	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g10209	i0	84.848	119.546012269939	330	34	99	14	1	325	653427	653745	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	38972	318	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
18174920	18174920	PRJNA1196438_P_NODE_57235_length_262_cov_2.227513_g56808_i0	PRJNA1196438	57235	262	2.227513	5.83608406	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	224	4.789999999999999e-54	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g56808	i0	82.129	3.72900763358779	263	45	100	2	1	262	2741447	2741708	Planctomyces sp. SH-PL62, complete genome	blastn	977	224	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
18175000	18175000	PRJNA1196438_P_NODE_62855_length_254_cov_1.723757_g62428_i0	PRJNA1196438	62855	254	1.723757	4.37834278	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	163	1.02e-35	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g62428	i0	86.897	8.89370078740157	145	19	57	0	109	253	3202267	3202123	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	2259	163	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
19449282	19449282	PRJNA1196438_P_NODE_52216_length_270_cov_1.482234_g51789_i0	PRJNA1196438	52216	270	1.482234	4.0020318	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	379	9.989999999999998e-101	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g51789	i0	91.912	273.377777777778	272	20	100	2	1	270	4422000	4422271	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	73812	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
20724313	20724313	PRJNA1196438_P_NODE_2637_length_596_cov_5.135755_g2238_i0	PRJNA1196438	2637	596	5.135755	30.6090998	Chthoniobacteraceae bacterium	2811408	Bacteria	Bacteria	900	0	NTclustered	gi\|2813917447\|gb\|CP170506.1\|	2811408	g2238	i0	93.96	264.785234899329	596	35	100	1	1	596	3046257	3046851	MAG: Chthoniobacteraceae bacterium isolate SH-KS-3 chromosome, complete genome	blastn	157812	900	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae		Chthoniobacteraceae bacterium
21999943	21999943	PRJNA1196438_P_NODE_4678_length_456_cov_7.422977_g4260_i0	PRJNA1196438	4678	456	7.422977	33.84877512	Sulfuriroseicoccus oceanibius	2707525	Bacteria	Bacteria	326	2.36e-84	NTclustered	gi\|1953472588\|gb\|CP066776.1\|	2707525	g4260	i0	88.561	73.2456140350877	271	28	98	3	1	271	3450453	3450186	Sulfuriroseicoccus oceanibius strain T37 chromosome, complete genome	blastn	33400	326	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Sulfuriroseicoccus	Sulfuriroseicoccus oceanibius
23275910	23275910	PRJNA1196438_P_NODE_86059_length_210_cov_8.810219_g85631_i0	PRJNA1196438	86059	210	8.810219	18.5014599	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	226	1.0299999999999999e-54	NTclustered	gi\|2874253952\|emb\|OY970277.1\|	412056	g85631	i0	86.603	56.3333333333333	209	23	99	5	2	208	2749803	2750008	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04580.bin.1.45 genome assembly, chromosome: 1	blastn	11830	226	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;