metadata: contig_metadata: 18 rows where analysis = "blastn", bioproject = "PRJNA900999" and tax

18 rows where analysis = "blastn", bioproject = "PRJNA900999" 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
878086	878086	PRJNA900999_S_NODE_1761_length_286_cov_8.105058_g1705_i0	PRJNA900999	1761	286	8.105058	23.18046588	uncultured Planctomycetota bacterium	120965	Bacteria	Bacteria	182	3.23e-41	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g1705	i0	78.644	10.0524475524476	295	48	99	14	1	285	3453757	3454046	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	2875	182	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
8898923	8898923	PRJNA900999_S_NODE_3547_length_223_cov_13.288660_g3491_i0	PRJNA900999	3547	223	13.28866	29.6337118	Gemmataceae	1914233	Bacteria	Bacteria	298	2.3e-76	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g3491	i0	93.909	338.237668161435	197	12	88	0	5	201	3633549	3633353	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	75427	298	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
9806018	9806018	PRJNA900999_S_NODE_4868_length_198_cov_2.284024_g4812_i0	PRJNA900999	4868	198	2.284024	4.52236752	Prosthecobacter dejongeii	48465	Bacteria	Bacteria	278	2.6e-70	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g4812	i0	91.919	15.9090909090909	198	16	100	0	1	198	371	174	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	3150	278	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
11449745	11449745	PRJNA900999_S_NODE_7389_length_168_cov_2.733813_g7333_i0	PRJNA900999	7389	168	2.733813	4.59280584	Planctomycetia	203683	Bacteria	Bacteria	311	2.11e-80	NTclustered	gi\|908860\|emb\|X81958.1\|	41672	g7333	i0	100	103	168	0	100	0	1	168	410	243	Isophaera sp. partial 16S rRNA gene (Schlesner 666)	blastn	17304	311	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae	Isosphaera	Isosphaera sp.
12357023	12357023	PRJNA900999_S_NODE_2410_length_257_cov_8.605263_g2354_i0	PRJNA900999	2410	257	8.605263	22.11552591	Lacipirellula parvula	2650471	Bacteria	Bacteria	418	1.9999999999999994e-112	NTclustered	gi\|1761017769\|dbj\|AP021861.1\|	2650471	g2354	i0	98.723	150.992217898833	235	3	91	0	23	257	5164241	5164007	Lacipirellula parvula PX69 DNA, complete genome	blastn	38805	418	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula parvula
12357027	12357027	PRJNA900999_S_NODE_2750_length_245_cov_15.430556_g2694_i0	PRJNA900999	2750	245	15.430556	37.8048622	uncultured Planctomycetaceae bacterium	100233	Bacteria	Bacteria	302	1.99e-77	NTclustered	gi\|2874253757\|emb\|OY969698.1\|	100233	g2694	i0	93.596	71.2326530612245	203	12	83	1	24	226	4422886	4422685	MAG: uncultured Planctomycetaceae bacterium isolate MFD00082.bin.2.56 genome assembly, chromosome: 1	blastn	17452	302	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae		uncultured Planctomycetaceae bacterium
14906086	14906086	PRJNA900999_S_NODE_7372_length_168_cov_3.597122_g7316_i0	PRJNA900999	7372	168	3.597122	6.04316496	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	259	7.75e-65	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g7316	i0	95.122	4.83928571428571	164	8	98	0	5	168	3657807	3657644	Planctomyces sp. SH-PL62, complete genome	blastn	813	259	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
16180807	16180807	PRJNA900999_S_NODE_3473_length_225_cov_6.734694_g3417_i0	PRJNA900999	3473	225	6.734694	15.1530615	Candidatus Uabimicrobium helgolandensis	3095367	Bacteria	Bacteria	108	4.21e-19	NTclustered	gi\|2793194503\|gb\|CP165719.1\|	3095367	g3417	i0	79.141	6.42222222222222	163	28	72	6	5	163	51765	51605	Candidatus Uabimicrobium helgolandensis strain HlEnr_7 chromosome	blastn	1445	108	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Uabimicrobiia	Candidatus Uabimicrobiales	Candidatus Uabimicrobiaceae	Candidatus Uabimicrobium	Candidatus Uabimicrobium helgolandensis
17456323	17456323	PRJNA900999_S_NODE_3234_length_231_cov_6.440594_g3178_i0	PRJNA900999	3234	231	6.440594	14.87777214	Parachlamydiales bacterium	2052178	Bacteria	Bacteria	198	2.51e-46	NTclustered	gi\|2874253843\|emb\|OY969899.1\|	2052178	g3178	i0	83.871	55.9523809523809	217	26	90	7	1	209	2632015	2631800	MAG: Parachlamydiales bacterium isolate MFD00082.bin.c.1 genome assembly, chromosome: 1	blastn	12925	198	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia	Parachlamydiales			Parachlamydiales bacterium
17456363	17456363	PRJNA900999_S_NODE_694_length_384_cov_21.464789_g639_i0	PRJNA900999	694	384	21.464789	82.42478976	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	577	4.8899999999999984e-160	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g639	i0	93.766	254.825520833333	385	22	100	2	1	384	4955863	4955480	Planctomyces sp. SH-PL14, complete genome	blastn	97853	577	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
18729483	18729483	PRJNA900999_S_NODE_2535_length_253_cov_2.991071_g2479_i0	PRJNA900999	2535	253	2.991071	7.56740963	Lacipirellula limnantheis	2528024	Bacteria	Bacteria	316	7.37e-82	NTclustered	gi\|1712529062\|gb\|CP036339.1\|	2528024	g2479	i0	99.425	4.8695652173913	174	1	69	0	1	174	5171767	5171594	Lacipirellula limnantheis strain I41 chromosome	blastn	1232	316	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Lacipirellulaceae	Lacipirellula	Lacipirellula limnantheis
20004679	20004679	PRJNA900999_S_NODE_1836_length_282_cov_7.786561_g1780_i0	PRJNA900999	1836	282	7.786561	21.95810202	Gemmata massiliana	1210884	Bacteria	Bacteria	300	8.41e-77	NTclustered	gi\|1804905141\|emb\|LR593886.1\|	1210884	g1780	i0	92.417	205.195035460993	211	15	74	1	51	260	3633563	3633353	Gemmata massiliana isolate Soil9 genome assembly, chromosome: 1	blastn	57865	300	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	Gemmata massiliana
20004721	20004721	PRJNA900999_S_NODE_6096_length_182_cov_2.091503_g6040_i0	PRJNA900999	6096	182	2.091503	3.80653546	Planctellipticum variicoloris	3064265	Bacteria	Bacteria	255	1.1e-63	NTclustered	gi\|2557458921\|gb\|CP130886.1\|	3064265	g6040	i0	92.222	164.412087912088	180	14	99	0	1	180	4468970	4469149	Planctellipticum variicoloris strain SH412 chromosome, complete genome	blastn	29923	255	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctellipticum	Planctellipticum variicoloris
20004735	20004735	PRJNA900999_S_NODE_7736_length_165_cov_1.911765_g7680_i0	PRJNA900999	7736	165	1.911765	3.15441225	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	195	2.17e-45	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g7680	i0	93.846	2.56363636363636	130	6	78	2	1	129	1194207	1194335	Planctomyces sp. SH-PL62, complete genome	blastn	423	195	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
21279981	21279981	PRJNA900999_S_NODE_1277_length_315_cov_15.108392_g1221_i0	PRJNA900999	1277	315	15.108392	47.5914348	Bremerella sp. TYQ1	3119568	Bacteria	Bacteria	206	2.1399999999999994e-48	NTclustered	gi\|2101355205\|gb\|CP083740.1\|	3119568	g1221	i0	78.979	345.587301587302	333	46	99	20	1	314	1689261	1689588	Bremerella sp. TYQ1 chromosome, complete genome	blastn	108860	206	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae	Bremerella	Bremerella sp. TYQ1
23830201	23830201	PRJNA900999_S_NODE_3459_length_225_cov_432.714286_g3403_i0	PRJNA900999	3459	225	432.714286	973.6071435	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	252	1.84e-62	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g3403	i0	93.023	7.75111111111111	172	12	76	0	16	187	1811389	1811560	Planctomyces sp. SH-PL62, complete genome	blastn	1744	252	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
25104104	25104104	PRJNA900999_S_NODE_4300_length_207_cov_24.438202_g4244_i0	PRJNA900999	4300	207	24.438202	50.58707814	Planctomyces sp. SH-PL14	1632864	Bacteria	Bacteria	313	7.53e-81	NTclustered	gi\|1015434452\|gb\|CP011270.1\|	1632864	g4244	i0	96.791	214.227053140097	187	6	90	0	1	187	4955510	4955324	Planctomyces sp. SH-PL14, complete genome	blastn	44345	313	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL14
25104151	25104151	PRJNA900999_S_NODE_8040_length_162_cov_3.857143_g7984_i0	PRJNA900999	8040	162	3.857143	6.24857166	uncultured Chlamydiae bacterium	305355	Bacteria	Bacteria	145	2.16e-30	NTclustered	gi\|2874253676\|emb\|OY969110.1\|	305355	g7984	i0	86.667	2.74074074074074	135	13	82	5	12	144	1641568	1641437	MAG: uncultured Chlamydiae bacterium isolate MFD00082.bin.c.5 genome assembly, chromosome: 1	blastn	444	145	1	Bacteria	PVC group	Pseudomonadati	Chlamydiota	Chlamydiia				uncultured Chlamydiae 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);;