metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJEB83101" and tax

8 rows where analysis = "blastn", bioproject = "PRJEB83101" 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
142178	142178	PRJEB83101_P_NODE_51241_length_274_cov_1.393035_g50936_i0	PRJEB83101	51241	274	1.393035	3.8169159	Aeoliella mucimassa	2527972	Bacteria	Bacteria	191	5.11e-44	NTclustered	gi\|1712622222\|gb\|CP036278.1\|	2527972	g50936	i0	79.699	40.2481751824818	266	52	97	2	1	265	2585687	2585951	Aeoliella mucimassa strain Pan181 chromosome, complete genome	blastn	11028	191	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Aeoliella	Aeoliella mucimassa
2692252	2692252	PRJEB83101_P_NODE_50643_length_275_cov_1.386139_g50338_i0	PRJEB83101	50643	275	1.386139	3.81188225	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	329	1.04e-85	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g50338	i0	88.321	0.996363636363636	274	32	99	0	1	274	5593835	5593562	Lacipirellula limnantheis strain I41 chromosome	blastn	274	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
3968324	3968324	PRJEB83101_P_NODE_50924_length_274_cov_2.522388_g50619_i0	PRJEB83101	50924	274	2.522388	6.91134312	Akkermansiaceae bacterium	2562705	Bacteria	Bacteria	198	3.0499999999999998e-46	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g50619	i0	82.051	2.56569343065693	234	40	85	2	41	273	3204414	3204646	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	703	198	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
10345337	10345337	PRJEB83101_P_NODE_58109_length_263_cov_1.305263_g57804_i0	PRJEB83101	58109	263	1.305263	3.43284169	Horticoccus luteus	2862869	Bacteria	Bacteria	213	1.04e-50	NTclustered	gi\|2077391884\|gb\|CP080507.1\|	2862869	g57804	i0	81.369	100.752851711027	263	47	99	2	2	263	2127162	2126901	Horticoccus luteus strain KSB-15 chromosome, complete genome	blastn	26498	213	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Horticoccus	Horticoccus luteus
19268478	19268478	PRJEB83101_P_NODE_82156_length_244_cov_0.912281_g81851_i0	PRJEB83101	82156	244	0.912281	2.22596564	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	58.4	4.73e-4	NTclustered	gi\|2874254096\|emb\|OY970179.1\|	412056	g81851	i0	90.909	1.02049180327869	44	3	18	1	186	229	670107	670149	MAG: uncultured Verrucomicrobiae bacterium isolate MFD05521.bin.c.1 genome assembly, chromosome: 1	blastn	249	58.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
21818954	21818954	PRJEB83101_P_NODE_53078_length_271_cov_1.313131_g52773_i0	PRJEB83101	53078	271	1.313131	3.55858501	Tautonia plasticadhaerens	2527974	Bacteria	Bacteria	143	1.43e-29	NTclustered	gi\|1712713678\|gb\|CP036426.1\|	2527974	g52773	i0	77.953	6.85608856088561	254	38	87	13	29	264	4831112	4831365	Tautonia plasticadhaerens strain ElP chromosome	blastn	1858	143	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Tautonia	Tautonia plasticadhaerens
23094673	23094673	PRJEB83101_P_NODE_68679_length_251_cov_0.876404_g68374_i0	PRJEB83101	68679	251	0.876404	2.19977404	Luteolibacter sp. SL250	2995170	Bacteria	Bacteria	353	5.569999999999998e-93	NTclustered	gi\|2381117106\|gb\|CP113054.1\|	2995170	g68374	i0	92.032	1	251	20	100	0	1	251	2801644	2801394	Luteolibacter sp. SL250 chromosome	blastn	251	353	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. SL250
24368863	24368863	PRJEB83101_P_NODE_85720_length_242_cov_0.923077_g85415_i0	PRJEB83101	85720	242	0.923077	2.23384634	Humisphaera borealis	2807512	Bacteria	Bacteria	281	2.55e-71	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g85415	i0	88.987	34.1198347107438	227	25	94	0	3	229	2080087	2080313	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	8257	281	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis

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