metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJEB75230" and tax

10 rows where analysis = "blastn", bioproject = "PRJEB75230" 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
1411218	1411218	PRJEB75230_P_NODE_169262_length_243_cov_0.905882_g169080_i0	PRJEB75230	169262	243	0.905882	2.20129326	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	202	2.0599999999999995e-47	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g169080	i0	82.114	15.7489711934156	246	34	99	7	1	241	6149874	6149634	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	3827	202	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
1411420	1411420	PRJEB75230_P_NODE_185222_length_235_cov_2.018519_g185040_i0	PRJEB75230	185222	235	2.018519	4.74351965	uncultured Lentisphaeria bacterium	1506601	Bacteria	Bacteria	259	1.16e-64	NTclustered	gi\|2518551196\|emb\|OX638337.1\|	1506601	g185040	i0	93.642	2.11063829787234	173	11	74	0	1	173	647354	647182	MAG: uncultured Lentisphaeria bacterium isolate c31e16b5-b392-4df5-8896-43fa5ca65f34 genome assembly, chromosome: 1	blastn	496	259	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				uncultured Lentisphaeria bacterium
2685941	2685941	PRJEB75230_P_NODE_112163_length_254_cov_2.558011_g111981_i0	PRJEB75230	112163	254	2.558011	6.49734794	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	346	9.45e-91	NTclustered	gi\|2874254106\|emb\|OY970189.1\|	100233	g111981	i0	91.373	72.9645669291339	255	19	100	3	1	254	4318022	4317770	MAG: uncultured Planctomycetaceae bacterium isolate MFD09603.bin.2.127 genome assembly, chromosome: 1	blastn	18533	346	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
6514081	6514081	PRJEB75230_P_NODE_118426_length_251_cov_0.865169_g118244_i0	PRJEB75230	118426	251	0.865169	2.17157419	Singulisphaera acidiphila	466153	Bacteria	Bacteria	291	4.43e-74	NTclustered	gi\|430012750\|gb\|CP003364.1\|	886293	g118244	i0	87.903	1.88844621513944	248	29	99	1	1	248	2478872	2479118	Singulisphaera acidiphila DSM 18658, complete genome	blastn	474	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera acidiphila
11615192	11615192	PRJEB75230_P_NODE_172130_length_242_cov_1.633136_g171948_i0	PRJEB75230	172130	242	1.633136	3.95218912	Akkermansia sp. N21116	3040764	Bacteria	Bacteria	52.8	0.022	NTclustered	gi\|2634178342\|gb\|CP139035.1\|	3040764	g171948	i0	100	0.115702479338843	28	0	12	0	213	240	3145593	3145566	Akkermansia sp. N21116 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia sp. N21116
14165465	14165465	PRJEB75230_P_NODE_30672_length_348_cov_0.800000_g30490_i0	PRJEB75230	30672	348	0.8	2.784	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	52.8	0.033	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g30490	i0	100	0.0804597701149425	28	0	8	0	128	155	1474239	1474212	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	28	52.8	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
16712444	16712444	PRJEB75230_P_NODE_104194_length_260_cov_1.641711_g104012_i0	PRJEB75230	104194	260	1.641711	4.2684486	Verrucomicrobium sp. GAS474	1882831	Bacteria	Bacteria	198	2.88e-46	NTclustered	gi\|1085974270\|emb\|LT629781.1\|	1882831	g104012	i0	81.405	72.9	242	45	93	0	19	260	2077281	2077040	Verrucomicrobiaceae bacterium GAS474 genome assembly, chromosome: I	blastn	18954	198	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Verrucomicrobium	Verrucomicrobium sp. GAS474
16713231	16713231	PRJEB75230_P_NODE_166014_length_243_cov_1.447059_g165832_i0	PRJEB75230	166014	243	1.447059	3.51635337	Urbifossiella limnaea	2528023	Bacteria	Bacteria	217	7.34e-52	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g165832	i0	84.545	7.04938271604938	220	32	90	2	25	243	7696284	7696502	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	1713	217	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
16713832	16713832	PRJEB75230_P_NODE_39974_length_328_cov_1.207843_g39792_i0	PRJEB75230	39974	328	1.207843	3.96172504	Singulisphaera sp. Ch08	3120278	Bacteria	Bacteria	379	1.25e-100	NTclustered	gi\|2732846650\|gb\|CP155447.1\|	3120278	g39792	i0	87.879	60.9542682926829	330	31	99	7	2	328	2271817	2271494	Singulisphaera sp. Ch08 chromosome, complete genome	blastn	19993	379	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Singulisphaera	Singulisphaera sp. Ch08
23088234	23088234	PRJEB75230_P_NODE_150699_length_246_cov_0.890173_g150517_i0	PRJEB75230	150699	246	0.890173	2.18982558	Opitutales bacterium	2026772	Bacteria	Bacteria	67.6	7.94e-7	NTclustered	gi\|2891482121\|emb\|OZ219855.1\|	2026772	g150517	i0	97.5	46.239837398374	40	0	16	1	11	49	71822	71861	MAG: Opitutales bacterium isolate e4292735-b3b5-42df-bce3-ad3ef7a88f44 genome assembly, chromosome: 14	blastn	11375	67.6	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales 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);;