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

10 rows where analysis = "blastn", bioproject = "PRJNA1120586" 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
276150	276150	PRJNA1120586_P_NODE_38041_length_239_cov_1.282353_g37850_i0	PRJNA1120586	38041	239	1.282353	3.06482367	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	425	1.1e-114	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g37850	i0	98.745	169.836820083682	239	3	100	0	1	239	582	820	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	40591	425	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
1028381	1028381	PRJNA1120586_P_NODE_28441_length_265_cov_1.846939_g28250_i0	PRJNA1120586	28441	265	1.846939	4.89438835	Akkermansia	239934	Bacteria	Bacteria	490	4.3299999999999986e-134	NTclustered	gi\|1888387165\|gb\|CP058562.1\|	239935	g28250	i0	100	296	265	0	100	0	1	265	139143	139407	Akkermansia muciniphila strain AK32 chromosome, complete genome	blastn	78440	490	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae	Akkermansia	Akkermansia muciniphila
1550308	1550308	PRJNA1120586_P_NODE_14162_length_336_cov_2.883895_g13971_i0	PRJNA1120586	14162	336	2.883895	9.6898872	Urbifossiella limnaea	2528023	Bacteria	Bacteria	337	7.81e-88	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g13971	i0	84.956	248.738095238095	339	44	100	5	1	336	4211930	4212264	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	83576	337	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
1550469	1550469	PRJNA1120586_P_NODE_24882_length_277_cov_3.346154_g24691_i0	PRJNA1120586	24882	277	3.346154	9.26884658	Urbifossiella limnaea	2528023	Bacteria	Bacteria	348	2.9e-91	NTclustered	gi\|1712585314\|gb\|CP036273.1\|	2528023	g24691	i0	89.455	125.72202166065	275	29	99	0	1	275	2019590	2019864	Urbifossiella limnaea strain ETA_A1 chromosome, complete genome	blastn	34825	348	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Urbifossiella	Urbifossiella limnaea
1550828	1550828	PRJNA1120586_P_NODE_44562_length_231_cov_5.567901_g44371_i0	PRJNA1120586	44562	231	5.567901	12.86185131	uncultured Gemmata sp.	459262	Bacteria	Bacteria	394	2.98e-105	NTclustered	gi\|330376222\|gb\|JF731389.1\|	459262	g44371	i0	97.403	99.987012987013	231	6	100	0	1	231	432	202	Uncultured Gemmata sp. clone BacTopLow012 16S ribosomal RNA gene, partial sequence	blastn	23097	394	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Gemmata	uncultured Gemmata sp.
9204105	9204105	PRJNA1120586_P_NODE_37928_length_239_cov_1.694118_g37737_i0	PRJNA1120586	37928	239	1.694118	4.04894202	uncultured Verrucomicrobiales bacterium	100234	Bacteria	Bacteria	372	1.45e-98	NTclustered	gi\|220682330\|gb\|FJ542937.1\|	100234	g37737	i0	94.958	99.6610878661088	238	10	99	2	3	239	545	309	Uncultured Verrucomicrobiales bacterium clone B01-06A 16S ribosomal RNA gene, partial sequence	blastn	23819	372	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales			uncultured Verrucomicrobiales bacterium
18128219	18128219	PRJNA1120586_P_NODE_8155_length_413_cov_2.223837_g7964_i0	PRJNA1120586	8155	413	2.223837	9.18444681	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	675	0	NTclustered	gi\|2874253768\|emb\|OY969715.1\|	412056	g7964	i0	96.126	189.217917675545	413	16	100	0	1	413	915205	915617	MAG: uncultured Verrucomicrobiae bacterium isolate MFD01916.bin.1.1 genome assembly, chromosome: 1	blastn	78147	675	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
22705390	22705390	PRJNA1120586_P_NODE_50638_length_227_cov_1.069620_g50447_i0	PRJNA1120586	50638	227	1.06962	2.4280374	Bacteria	2	Bacteria	Bacteria	196	8.829999999999999e-46	NTclustered	gi\|2874254043\|emb\|OY970367.1\|	120965	g50447	i0	82.667	291.396475770925	225	35	99	4	1	225	3454566	3454786	MAG: uncultured Planctomycetota bacterium isolate MFD04580.bin.c.2 genome assembly, chromosome: 1	blastn	66147	196	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota					uncultured Planctomycetota bacterium
23980679	23980679	PRJNA1120586_P_NODE_3439_length_580_cov_2.802348_g3252_i0	PRJNA1120586	3439	580	2.802348	16.2536184	Limnoglobus	2731450	Bacteria	Bacteria	695	0	NTclustered	gi\|2874253853\|emb\|OY969909.1\|	1914239	g3252	i0	88.356	309.872413793103	584	61	100	6	1	580	2002294	2002874	MAG: uncultured Gemmataceae bacterium isolate MFD01275.bin.c.1 genome assembly, chromosome: 1	blastn	179726	699	0.994277539341917	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		uncultured Gemmataceae bacterium
24502457	24502457	PRJNA1120586_P_NODE_9740_length_386_cov_1.640379_g9549_i0	PRJNA1120586	9740	386	1.640379	6.33186294	Frigoriglobus tundricola	2774151	Bacteria	Bacteria	532	1.08e-146	NTclustered	gi\|1870286614\|gb\|CP053452.2\|	2774151	g9549	i0	91.582	151.253886010363	392	23	99	5	1	383	4959452	4959842	Frigoriglobus tundricola strain PL17 chromosome, complete genome	blastn	58384	532	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae	Frigoriglobus	Frigoriglobus tundricola

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