metadata: contig_metadata: 12 rows where analysis = "blastn", bioproject = "PRJNA857857" and tax

12 rows where analysis = "blastn", bioproject = "PRJNA857857" 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
845130	845130	PRJNA857857_P_NODE_36581_length_251_cov_0.865169_g36132_i0	PRJNA857857	36581	251	0.865169	2.17157419	Mariniblastus fucicola	980251	Bacteria	Bacteria	211	3.55e-50	NTclustered	gi\|1730062935\|gb\|CP042912.1\|	980251	g36132	i0	84.091	1.8804780876494	220	34	87	1	29	247	4412641	4412860	Mariniblastus fucicola strain FC18 chromosome, complete genome	blastn	472	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Mariniblastus	Mariniblastus fucicola
4673644	4673644	PRJNA857857_P_NODE_39624_length_249_cov_0.875000_g39175_i0	PRJNA857857	39624	249	0.875	2.17875	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	163	9.980000000000001e-36	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g39175	i0	80.357	58.2128514056225	224	36	88	8	30	249	4716166	4715947	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	14495	163	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
5948679	5948679	PRJNA857857_P_NODE_47305_length_244_cov_0.900585_g46856_i0	PRJNA857857	47305	244	0.900585	2.1974274	Planctomycetes bacterium MalM25	2527998	Bacteria	Bacteria	211	3.43e-50	NTclustered	gi\|1712524857\|gb\|CP036424.1\|	2527998	g46856	i0	94.203	7.47131147540984	138	8	57	0	107	244	1408568	1408705	Planctomycetes bacterium MalM25 chromosome	blastn	1823	211	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					Planctomycetes bacterium MalM25
8498229	8498229	PRJNA857857_P_NODE_45447_length_245_cov_0.895349_g44998_i0	PRJNA857857	45447	245	0.895349	2.19360505	Lacipirellula parvula	2650471	Bacteria	Bacteria	148	2.74e-31	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g44998	i0	81.421	2.2530612244898	183	32	74	2	1	182	362764	362945	Lacipirellula parvula PX69 DNA, complete genome	blastn	552	148	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
8498302	8498302	PRJNA857857_P_NODE_49027_length_243_cov_0.905882_g48578_i0	PRJNA857857	49027	243	0.905882	2.20129326	Saltatorellus ferox	2528018	Bacteria	Bacteria	241	4.36e-59	NTclustered	gi\|1712682957\|gb\|CP036434.1\|	2528018	g48578	i0	84.836	1.00411522633745	244	31	99	6	3	243	1155508	1155748	Planctomycetes bacterium Poly30 chromosome, complete genome	blastn	244	241	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia			Saltatorellus	Saltatorellus ferox
14873012	14873012	PRJNA857857_P_NODE_30752_length_278_cov_1.370732_g30303_i0	PRJNA857857	30752	278	1.370732	3.81063496	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	414	2.83e-111	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g30303	i0	93.525	118.543165467626	278	18	100	0	1	278	1832270	1831993	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	32955	414	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
17423441	17423441	PRJNA857857_P_NODE_44034_length_246_cov_0.890173_g43585_i0	PRJNA857857	44034	246	0.890173	2.18982558	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	339	1.5199999999999998e-88	NTclustered	gi\|1938775668\|gb\|CP054178.1\|	2026777	g43585	i0	91.803	10.8211382113821	244	18	100	2	4	246	3125683	3125441	MAG: Phycisphaeraceae bacterium isolate H1_PLA4 chromosome, complete genome	blastn	2662	339	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
19971845	19971845	PRJNA857857_P_NODE_42976_length_247_cov_0.885057_g42527_i0	PRJNA857857	42976	247	0.885057	2.18609079	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	239	1.6e-58	NTclustered	gi\|2921913114\|gb\|CP182803.1\|	2026777	g42527	i0	84.146	4.50607287449393	246	39	99	0	2	247	2566077	2565832	MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome	blastn	1113	239	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
19971895	19971895	PRJNA857857_P_NODE_45736_length_245_cov_0.895349_g45287_i0	PRJNA857857	45736	245	0.895349	2.19360505	Akkermansia massiliensis	2927224	Bacteria	Bacteria	113	1e-20	NTclustered	gi\|2736739857\|gb\|CP156916.1\|	2927224	g45287	i0	85.321	6.97551020408163	109	16	44	0	137	245	2449833	2449725	Akkermansia massiliensis strain Akk273 chromosome, complete genome	blastn	1709	113	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia massiliensis
21247604	21247604	PRJNA857857_P_NODE_52237_length_241_cov_0.857143_g51788_i0	PRJNA857857	52237	241	0.857143	2.06571463	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	104	5.9e-18	NTclustered	gi\|2921913114\|gb\|CP182803.1\|	2026777	g51788	i0	77.907	0.713692946058091	172	35	71	2	68	239	541069	540901	MAG: Phycisphaeraceae bacterium isolate amkv24 chromosome, complete genome	blastn	172	104	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
21637673	21637673	PRJNA857857_P_NODE_27657_length_294_cov_1.742081_g27208_i0	PRJNA857857	27657	294	1.742081	5.12171814	Gemmata	113	Bacteria	Bacteria	459	1.38e-124	NTclustered	gi\|1727537522\|gb\|CP042911.1\|	114	g27208	i0	94.898	448.826530612245	294	13	100	1	1	294	2022586	2022877	Gemmata obscuriglobus strain DSM 5831 chromosome, complete genome	blastn	131955	459	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata obscuriglobus
25071340	25071340	PRJNA857857_P_NODE_41180_length_248_cov_0.880000_g40731_i0	PRJNA857857	41180	248	0.88	2.1824	Bremerella sp. P1	3026424	Bacteria	Bacteria	189	1.6399999999999996e-43	NTclustered	gi\|2446655020\|gb\|CP118164.1\|	3026424	g40731	i0	87.273	1.70967741935484	165	21	67	0	1	165	2785794	2785958	Bremerella sp. P1 chromosome, complete genome	blastn	424	189	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. P1

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