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

16 rows where analysis = "blastn", bioproject = "PRJDB12578" 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
2168	2168	PRJDB12578_S_NODE_148901_length_204_cov_1.658065_g125843_i0	PRJDB12578	148901	204	1.658065	3.3824526	uncultured clinical Chlamydiales bacterium	227484	Bacteria	Bacteria	298	2.07e-76	NTclustered	gi\|407196282\|gb\|JX559647.1\|	227484	g125843	i0	100	98	161	0	79	0	44	204	1	161	Uncultured clinical Chlamydiales bacterium clone CRG100 16S ribosomal RNA gene, partial sequence	blastn	19992	298	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Chlamydiales			uncultured clinical Chlamydiales bacterium
6511	6511	PRJDB12578_S_NODE_55961_length_753_cov_3.174716_g34224_i0	PRJDB12578	55961	753	3.174716	23.90561148	Aureliella helgolandensis	2527968	Bacteria	Bacteria	1037	0	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g34224	i0	91.611	118.151394422311	751	61	99	2	1	750	7001712	7000963	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	88968	1037	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
7362	7362	PRJDB12578_S_NODE_73221_length_458_cov_2.195599_g50188_i0	PRJDB12578	73221	458	2.195599	10.05584342	planctomycete str. 449	79870	Bacteria	Bacteria	636	9.639999999999997e-178	NTclustered	gi\|12583969\|gb\|AF245373.1\|AF245373	79870	g50188	i0	91.939	126.133187772926	459	29	99	8	3	458	1313	860	Planctomycete str. 449 23S ribosomal RNA gene, partial sequence	blastn	57769	636	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 449
1277074	1277074	PRJDB12578_S_NODE_165982_length_189_cov_0.921429_g142924_i0	PRJDB12578	165982	189	0.921429	1.74150081	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	294	2.44e-75	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g142924	i0	94.737	4.02645502645503	190	9	100	1	1	189	3097540	3097351	Pirellula sp. SH-Sr6A, complete genome	blastn	761	294	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
2553828	2553828	PRJDB12578_S_NODE_196523_length_168_cov_0.865546_g173465_i0	PRJDB12578	196523	168	0.865546	1.45411728	uncultured Parachlamydiaceae bacterium	464461	Bacteria	Bacteria	220	3.66e-53	NTclustered	gi\|2874253811\|emb\|OY969795.1\|	464461	g173465	i0	90.533	107.577380952381	169	12	99	4	1	166	653679	653512	MAG: uncultured Parachlamydiaceae bacterium isolate MFD05502.bin.c.3 genome assembly, chromosome: 1	blastn	18073	220	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae		uncultured Parachlamydiaceae bacterium
2557045	2557045	PRJDB12578_S_NODE_69683_length_502_cov_2.487859_g46706_i0	PRJDB12578	69683	502	2.487859	12.48905218	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	531	5.17e-146	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g46706	i0	85.714	98.5756972111554	511	64	100	4	1	502	5363024	5363534	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	49485	531	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
2557977	2557977	PRJDB12578_S_NODE_90223_length_330_cov_3.587189_g67165_i0	PRJDB12578	90223	330	3.587189	11.8377237	Aureliella helgolandensis	2527968	Bacteria	Bacteria	359	1.63e-94	NTclustered	gi\|1712701923\|gb\|CP036298.1\|	2527968	g67165	i0	89.825	158.709090909091	285	22	85	5	16	297	6999419	6999139	Aureliella helgolandensis strain Q31a chromosome, complete genome	blastn	52374	359	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella helgolandensis
2558070	2558070	PRJDB12578_S_NODE_92403_length_320_cov_3.597786_g69345_i0	PRJDB12578	92403	320	3.597786	11.5129152	Aureliella sp.	2795609	Bacteria	Bacteria	315	3.47e-81	NTclustered	gi\|2626244095\|emb\|OY829846.1\|	2795609	g69345	i0	86.254	110.4	291	38	90	2	31	319	5640378	5640668	MAG: Aureliella sp. isolate e39ea203-26a8-405f-9782-9267d5c1de48 genome assembly, chromosome: 1	blastn	35328	315	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Aureliella	Aureliella sp.
3531413	3531413	PRJDB12578_S_NODE_177483_length_180_cov_1.038168_g154425_i0	PRJDB12578	177483	180	1.038168	1.8687024	Gemmataceae	1914233	Bacteria	Bacteria	278	2.31e-70	NTclustered	gi\|12583965\|gb\|AF245369.1\|AF245369	114	g154425	i0	94.444	142	180	10	100	0	1	180	1614	1793	Gemmata obscuriglobus 23S ribosomal RNA gene, partial sequence	blastn	25560	279	0.996415770609319	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
8928848	8928848	PRJDB12578_S_NODE_139688_length_214_cov_1.563636_g116630_i0	PRJDB12578	139688	214	1.563636	3.34618104	Pirellula sp. SH-Sr6A	1632865	Bacteria	Bacteria	296	7.89e-76	NTclustered	gi\|1015448679\|gb\|CP011272.1\|	1632865	g116630	i0	91.628	126.869158878505	215	17	100	1	1	214	3097297	3097511	Pirellula sp. SH-Sr6A, complete genome	blastn	27150	296	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Pirellula	Pirellula sp. SH-Sr6A
12460078	12460078	PRJDB12578_S_NODE_65450_length_567_cov_2.561776_g42654_i0	PRJDB12578	65450	567	2.561776	14.52526992	Planctomycetia	203683	Bacteria	Bacteria	697	0	NTclustered	gi\|12583967\|gb\|AF245371.1\|AF245371	149588	g42654	i0	88.927	125.031746031746	578	47	100	13	1	567	764	1335	Planctomycete str. 139 23S ribosomal RNA gene, partial sequence	blastn	70893	697	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		planctomycete str. 139
14031956	14031956	PRJDB12578_S_NODE_194672_length_168_cov_2.008403_g171614_i0	PRJDB12578	194672	168	2.008403	3.37411704	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	219	1.3099999999999999e-52	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g171614	i0	90.476	90.3690476190476	168	12	99	4	1	166	3412358	3412193	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	15182	219	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
16581462	16581462	PRJDB12578_S_NODE_216514_length_157_cov_2.888889_g193456_i0	PRJDB12578	216514	157	2.888889	4.53555573	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	185	1.2199999999999999e-42	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g193456	i0	88.05	40.0063694267516	159	15	100	3	1	157	3722447	3722291	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	6281	185	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
17858731	17858731	PRJDB12578_S_NODE_63375_length_603_cov_2.570397_g40746_i0	PRJDB12578	63375	603	2.570397	15.49949391	Fuerstiella marisgermanici	1891926	Bacteria	Bacteria	597	6.11e-166	NTclustered	gi\|1140105870\|gb\|CP017641.1\|	1891926	g40746	i0	86.306	110.708126036484	555	69	92	6	36	589	5362295	5362843	Fuerstiella marisgermanici strain NH11 chromosome, complete genome	blastn	66757	597	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Fuerstiella	Fuerstiella marisgermanici
19127701	19127701	PRJDB12578_S_NODE_146896_length_206_cov_1.643312_g123838_i0	PRJDB12578	146896	206	1.643312	3.38522272	Candidatus Protochlamydia amoebophila	362787	Bacteria	Bacteria	320	4.47e-83	NTclustered	gi\|1691252667\|emb\|BX908798.2\|	264201	g123838	i0	94.66	116.04854368932	206	11	100	0	1	206	2153552	2153757	Candidatus Protochlamydia amoebophila UWE25 complete genome	blastn	23906	320	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales	Parachlamydiaceae	Candidatus Protochlamydia	Candidatus Protochlamydia amoebophila
22956600	22956600	PRJDB12578_S_NODE_217699_length_153_cov_4.884615_g194641_i0	PRJDB12578	217699	153	4.884615	7.47346095	Stieleria bergensis	2528025	Bacteria	Bacteria	243	6.93e-60	NTclustered	gi\|1712514661\|gb\|CP036272.1\|	2528025	g194641	i0	95.395	106.888888888889	152	7	99	0	2	153	5540599	5540448	Planctomycetes bacterium SV_7m_r chromosome	blastn	16354	243	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Stieleria	Stieleria bergensis

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