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

10 rows where analysis = "blastn", bioproject = "PRJDB9741" and tax_phylum = "Verrucomicrobiota"

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
2560674	2560674	PRJDB9741_P_NODE_13803_length_189_cov_1.171429_g13486_i0	PRJDB9741	13803	189	1.171429	2.21400081	uncultured Spartobacteria bacterium	333969	Bacteria	Bacteria	263	6.879999999999999e-66	NTclustered	gi\|409969675\|gb\|JQ701281.1\|	333969	g13486	i0	92.896	96.010582010582	183	9	96	3	9	189	55	235	Uncultured Spartobacteria bacterium clone Flu3_11 16S ribosomal RNA gene, partial sequence	blastn	18146	263	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria				uncultured Spartobacteria bacterium
2560889	2560889	PRJDB9741_P_NODE_4283_length_314_cov_3.509434_g3967_i0	PRJDB9741	4283	314	3.509434	11.01962276	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	390	5.479999999999999e-104	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g3967	i0	94.141	222.162420382166	256	15	82	0	2	257	1349	1094	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	69759	390	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
7359560	7359560	PRJDB9741_P_NODE_4406_length_309_cov_2.388462_g4090_i0	PRJDB9741	4406	309	2.388462	7.38034758	Prosthecobacter	48463	Bacteria	Bacteria	525	1.4099999999999995e-144	NTclustered	gi\|183579826\|emb\|AM905423.1\|	48465	g4090	i0	97.403	279.912621359223	308	8	99	0	2	309	1794	1487	Prosthecobacter dejongeii partial 23S rRNA gene, strain DSM12251	blastn	86493	525	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter dejongeii
10213602	10213602	PRJDB9741_P_NODE_10829_length_200_cov_2.761589_g10512_i0	PRJDB9741	10829	200	2.761589	5.523178	Opitutales bacterium	2026772	Bacteria	Bacteria	174	3.55e-39	NTclustered	gi\|2814788334\|emb\|OY762281.2\|	2026772	g10512	i0	82.828	199.695	198	30	98	4	1	196	978371	978176	MAG: Opitutales bacterium isolate 685e4509-010e-4797-9872-a51ee4494a19 genome assembly, chromosome: 1	blastn	39939	174	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
10213759	10213759	PRJDB9741_P_NODE_34789_length_163_cov_2.456140_g34472_i0	PRJDB9741	34789	163	2.45614	4.0035082	Opitutales bacterium	2026772	Bacteria	Bacteria	183	4.62e-42	NTclustered	gi\|2814788334\|emb\|OY762281.2\|	2026772	g34472	i0	89.116	30.1411042944785	147	16	90	0	1	147	977994	978140	MAG: Opitutales bacterium isolate 685e4509-010e-4797-9872-a51ee4494a19 genome assembly, chromosome: 1	blastn	4913	183	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
11488912	11488912	PRJDB9741_P_NODE_3110_length_393_cov_3.011628_g2795_i0	PRJDB9741	3110	393	3.011628	11.83569804	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	204	9.809999999999999e-48	NTclustered	gi\|2518556548\|emb\|OX638380.1\|	412056	g2795	i0	77.143	7.53180661577608	385	67	95	16	14	387	3920796	3921170	MAG: uncultured Verrucomicrobiae bacterium isolate efd5e50e-5b6a-4a0f-a0a2-e496bae301b3 genome assembly, chromosome: 1	blastn	2960	204	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae bacterium
12764516	12764516	PRJDB9741_P_NODE_3191_length_386_cov_2.225519_g2876_i0	PRJDB9741	3191	386	2.225519	8.59050334	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	625	1.7299999999999996e-174	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g2876	i0	95.855	239.422279792746	386	16	100	0	1	386	575	190	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	92417	625	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
15313147	15313147	PRJDB9741_P_NODE_32013_length_165_cov_0.879310_g31696_i0	PRJDB9741	32013	165	0.87931	1.4508615	Luteolibacter sp.	1962973	Bacteria	Bacteria	278	2.09e-70	NTclustered	gi\|2836248208\|gb\|CP121322.1\|	1962973	g31696	i0	96.97	121.133333333333	165	5	100	0	1	165	1010102	1010266	MAG: Luteolibacter sp. isolate NCC532_bact_1514 chromosome, complete genome	blastn	19987	278	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp.
16284408	16284408	PRJDB9741_P_NODE_11473_length_198_cov_1.731544_g11156_i0	PRJDB9741	11473	198	1.731544	3.42845712	Verrucomicrobiota	74201	Bacteria	Bacteria	357	3.25e-94	NTclustered	gi\|164510706\|emb\|AJ966885.1\|	134634	g11156	i0	99.49	110.560606060606	196	1	99	0	2	197	1547	1352	Opitutus sp. VeGlc2 16S rRNA gene (partial), 23S rRNA gene, tRNA-Ala gene, tRNA-Ile gene, ITS1 and ITS2, strain DSM 11246	blastn	21891	359	0.994428969359331	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Opitutus	Opitutus sp. VeGlc2
19136508	19136508	PRJDB9741_P_NODE_36636_length_163_cov_0.842105_g36319_i0	PRJDB9741	36636	163	0.842105	1.37263115	uncultured Verrucomicrobiae bacterium	412056	Bacteria	Bacteria	230	5.8499999999999985e-56	NTclustered	gi\|2874254040\|emb\|OY970364.1\|	412056	g36319	i0	92.638	117.319018404908	163	7	100	5	1	163	2167752	2167909	MAG: uncultured Verrucomicrobiae bacterium isolate MFD04463.bin.c.15 genome assembly, chromosome: 1	blastn	19123	230	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				uncultured Verrucomicrobiae 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);;