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

12 rows where analysis = "blastn", bioproject = "PRJNA1167252" 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
1588921	1588921	PRJNA1167252_P_NODE_13962_length_329_cov_1.218750_g13689_i0	PRJNA1167252	13962	329	1.21875	4.0096875	Kolteria novifilia	2527975	Bacteria	Bacteria	409	1.5899999999999998e-109	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g13689	i0	89.571	175.434650455927	326	28	98	5	1	324	1830563	1830242	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	57718	409	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
2865359	2865359	PRJNA1167252_P_NODE_23423_length_252_cov_0.871508_g23150_i0	PRJNA1167252	23423	252	0.871508	2.19620016	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	351	2.01e-92	NTclustered	gi\|1015459065\|gb\|CP011274.1\|	1636152	g23150	i0	92	2.99206349206349	250	20	99	0	3	252	19804	20053	Planctomyces sp. SH-PL62 plasmid pPL62-1, complete sequence	blastn	754	351	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
4141548	4141548	PRJNA1167252_P_NODE_28624_length_243_cov_0.917647_g28351_i0	PRJNA1167252	28624	243	0.917647	2.22988221	Planctomycetia bacterium	2052181	Bacteria	Bacteria	388	1.47e-103	NTclustered	gi\|1927961636\|gb\|CP054187.1\|	2052181	g28351	i0	95.473	1	243	11	100	0	1	243	277366	277124	MAG: Planctomycetia bacterium isolate H1_PLA2 chromosome, complete genome	blastn	243	388	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
9242104	9242104	PRJNA1167252_P_NODE_10248_length_391_cov_2.911950_g9975_i0	PRJNA1167252	10248	391	2.91195	11.3857245	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	542	1.82e-149	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g9975	i0	91.603	148.048593350384	393	31	100	2	1	391	2002477	2002085	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	57887	542	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
11793101	11793101	PRJNA1167252_P_NODE_21350_length_262_cov_1.407407_g21077_i0	PRJNA1167252	21350	262	1.407407	3.68740634	uncultured Phycisphaerales bacterium	904075	Bacteria	Bacteria	237	6.15e-58	NTclustered	gi\|2874253847\|emb\|OY969903.1\|	904075	g21077	i0	84.091	50.8664122137405	264	22	100	9	1	262	1831460	1831215	MAG: uncultured Phycisphaerales bacterium isolate MFD01213.bin.c.1 genome assembly, chromosome: 1	blastn	13327	237	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales			uncultured Phycisphaerales bacterium
15617071	15617071	PRJNA1167252_P_NODE_14773_length_320_cov_0.959514_g14500_i0	PRJNA1167252	14773	320	0.959514	3.0704448	Humisphaera borealis	2807512	Bacteria	Bacteria	422	1.99e-113	NTclustered	gi\|1927742986\|gb\|CP063458.1\|	2807512	g14500	i0	90.402	120.353125	323	27	100	3	1	320	5065072	5064751	Humisphaera borealis strain M1803 chromosome, complete genome	blastn	38513	422	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Tepidisphaerales	Tepidisphaeraceae	Humisphaera	Humisphaera borealis
15617335	15617335	PRJNA1167252_P_NODE_23973_length_251_cov_0.876404_g23700_i0	PRJNA1167252	23973	251	0.876404	2.19977404	Urbifossiella limnaea	2528023	Bacteria	Bacteria	303	5.69e-78	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g23700	i0	89.627	49.6932270916335	241	22	96	3	12	251	2018054	2017816	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	12473	303	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
18166093	18166093	PRJNA1167252_P_NODE_21015_length_264_cov_1.633508_g20742_i0	PRJNA1167252	21015	264	1.633508	4.31246112	Telmatocola sphagniphila	1123043	Bacteria	Bacteria	313	1e-80	NTclustered	gi\|2041266541\|gb\|CP074694.1\|	1123043	g20742	i0	90.417	227.655303030303	240	19	90	4	27	264	3722385	3722148	Telmatocola sphagniphila strain SP2T chromosome, complete genome	blastn	60101	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Telmatocola	Telmatocola sphagniphila
20715852	20715852	PRJNA1167252_P_NODE_22217_length_255_cov_2.241758_g21944_i0	PRJNA1167252	22217	255	2.241758	5.7164829	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	291	4.509999999999999e-74	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g21944	i0	88.703	120.839215686275	239	26	94	1	1	239	2001632	2001869	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	30814	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
20715972	20715972	PRJNA1167252_P_NODE_26697_length_246_cov_1.803468_g26424_i0	PRJNA1167252	26697	246	1.803468	4.43653128	Kolteria novifilia	2527975	Bacteria	Bacteria	235	2.06e-57	NTclustered	gi\|1712629967\|gb\|CP036279.1\|	2527975	g26424	i0	84.553	172.073170731707	246	29	98	6	1	241	1829948	1830189	Planctomycetes bacterium Pan216 chromosome, complete genome	blastn	42330	235	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Kolteriales	Kolteriaceae	Kolteria	Kolteria novifilia
21991279	21991279	PRJNA1167252_P_NODE_26638_length_247_cov_0.896552_g26365_i0	PRJNA1167252	26638	247	0.896552	2.21448344	Sedimentisphaerales bacterium	2813034	Bacteria	Bacteria	318	1.9899999999999998e-82	NTclustered	gi\|2874254109\|emb\|OY970194.1\|	2813034	g26365	i0	89.879	5.25910931174089	247	25	100	0	1	247	5407184	5407430	MAG: Sedimentisphaerales bacterium isolate MFD00905.bin.c.1 genome assembly, chromosome: 1	blastn	1299	318	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Sedimentisphaerales			Sedimentisphaerales bacterium
23992178	23992178	PRJNA1167252_P_NODE_27439_length_245_cov_0.906977_g27166_i0	PRJNA1167252	27439	245	0.906977	2.22209365	Akkermansia	239934	Bacteria	Bacteria	187	5.809999999999998e-43	NTclustered	gi\|1805960388\|gb\|CP029703.1\|	239935	g27166	i0	100	41.2448979591837	101	0	41	0	145	245	2325800	2325700	Akkermansia muciniphila strain EB-AMDK-46 chromosome, complete genome	blastn	10105	187	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila

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