metadata: contig_metadata: 14 rows where analysis = "blastn", bioproject = "PRJNA255848" and tax

14 rows where analysis = "blastn", bioproject = "PRJNA255848" 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
368698	368698	PRJNA255848_P_NODE_4141_length_553_cov_3.521825_g3837_i0	PRJNA255848	4141	553	3.521825	19.47569225	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	933	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g3837	i0	97.107	278.580470162749	553	16	100	0	1	553	2463	1911	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	154055	933	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
1643575	1643575	PRJNA255848_P_NODE_722_length_1244_cov_4.487029_g578_i0	PRJNA255848	722	1244	4.487029	55.81864076	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	1954	0	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g578	i0	95.016	225.733922829582	1244	62	100	0	1	1244	338	1581	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	280813	1954	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
6746355	6746355	PRJNA255848_P_NODE_2246_length_757_cov_8.899718_g1994_i0	PRJNA255848	2246	757	8.899718	67.37086526	Limnoglobus roseus	2598579	Bacteria	Bacteria	1168	0	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g1994	i0	94.591	197.095112285337	758	35	100	4	1	757	2956139	2956891	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	149201	1168	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
9296651	9296651	PRJNA255848_P_NODE_12608_length_285_cov_6.961864_g12290_i0	PRJNA255848	12608	285	6.961864	19.8413124	Limnoglobus roseus	2598579	Bacteria	Bacteria	505	1.6799999999999995e-138	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g12290	i0	98.596	108.761403508772	285	4	100	0	1	285	2958882	2958598	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	30997	505	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
13122435	13122435	PRJNA255848_P_NODE_18991_length_228_cov_1.703911_g18673_i0	PRJNA255848	18991	228	1.703911	3.88491708	Luteolibacter sp.	1962973	Bacteria	Bacteria	372	1.37e-98	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g18673	i0	96.053	273.565789473684	228	9	100	0	1	228	1008799	1009026	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	62373	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
13122578	13122578	PRJNA255848_P_NODE_7491_length_391_cov_7.368421_g7173_i0	PRJNA255848	7491	391	7.368421	28.81052611	Limnoglobus roseus	2598579	Bacteria	Bacteria	468	3.13e-127	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g7173	i0	88.601	142.797953964194	386	42	100	2	1	385	2956139	2956523	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	55834	468	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
18220445	18220445	PRJNA255848_P_NODE_7955_length_377_cov_2.268293_g7637_i0	PRJNA255848	7955	377	2.268293	8.55146461	Prosthecobacter fusiformis	48464	Bacteria	Bacteria	577	4.789999999999999e-160	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g7637	i0	97.904	231.46949602122	334	5	88	1	46	377	1562	1895	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	87264	577	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
19494638	19494638	PRJNA255848_P_NODE_44436_length_162_cov_2.867257_g44118_i0	PRJNA255848	44436	162	2.867257	4.64495634	Urbifossiella limnaea	2528023	Bacteria	Bacteria	291	2.62e-74	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g44118	i0	99.375	125.981481481481	160	1	99	0	3	162	2018965	2019124	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	20409	291	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
20770177	20770177	PRJNA255848_P_NODE_19217_length_227_cov_1.196629_g18899_i0	PRJNA255848	19217	227	1.196629	2.71634783	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	329	8.34e-86	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g18899	i0	92.952	127.290748898678	227	15	100	1	1	227	4421234	4421009	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	28895	329	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
20770225	20770225	PRJNA255848_P_NODE_34877_length_167_cov_1.559322_g34559_i0	PRJNA255848	34877	167	1.559322	2.60406774	Urbifossiella limnaea	2528023	Bacteria	Bacteria	261	2.14e-65	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g34559	i0	94.675	76.2994011976048	169	7	100	1	1	167	2020065	2020233	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	12742	261	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
22045238	22045238	PRJNA255848_P_NODE_16818_length_243_cov_2.097938_g16500_i0	PRJNA255848	16818	243	2.097938	5.09798934	Urbifossiella limnaea	2528023	Bacteria	Bacteria	403	5.25e-108	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g16500	i0	96.694	223.699588477366	242	8	99	0	1	242	2018120	2017879	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	54359	403	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
22045259	22045259	PRJNA255848_P_NODE_24638_length_201_cov_1.039474_g24320_i0	PRJNA255848	24638	201	1.039474	2.08934274	Limnoglobus roseus	2598579	Bacteria	Bacteria	119	1.7000000000000002e-22	NTclustered	gi\|1733446852\|gb\|CP042425.1\|	2598579	g24320	i0	80.117	2.64179104477612	171	25	92	8	18	185	4089609	4089445	Limnoglobus roseus strain PX52 chromosome, complete genome	blastn	531	119	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Limnoglobus	Limnoglobus roseus
22045271	22045271	PRJNA255848_P_NODE_28178_length_187_cov_3.797101_g27860_i0	PRJNA255848	28178	187	3.797101	7.10057887	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	243	8.85e-60	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g27860	i0	92.398	3.01604278074866	171	11	91	2	4	173	316	147	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	564	243	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
22045373	22045373	PRJNA255848_P_NODE_8898_length_352_cov_3.006601_g8580_i0	PRJNA255848	8898	352	3.006601	10.58323552	uncultured Gemmataceae bacterium	1914239	Bacteria	Bacteria	579	1.2299999999999996e-160	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g8580	i0	96.307	142.068181818182	352	13	100	0	1	352	2002343	2002694	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	50008	579	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae 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);;