metadata: contig_metadata: 8 rows where analysis = "blastn", bioproject = "PRJNA792582" and tax

8 rows where analysis = "blastn", bioproject = "PRJNA792582" 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
7155160	7155160	PRJNA792582_P_NODE_13406_length_467_cov_2.672589_g12594_i0	PRJNA792582	13406	467	2.672589	12.48099063	Rubellicoccus peritrichatus	3080537	Bacteria	Bacteria	361	6.639999999999999e-95	NTclustered	gi\|2605121622\|gb\|CP136920.1\|	3080537	g12594	i0	80.932	79.6745182012848	472	76	100	13	1	467	2162787	2162325	Rubellicoccus peritrichatus strain CR14 isolate coral tank chromosome, complete genome	blastn	37208	361	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Puniceicoccales	Cerasicoccaceae	Rubellicoccus	Rubellicoccus peritrichatus
15243725	15243725	PRJNA792582_P_NODE_26812_length_333_cov_3.900000_g25998_i0	PRJNA792582	26812	333	3.9	12.987	Luteolibacter	518753	Bacteria	Bacteria	219	2.9199999999999993e-52	NTclustered	gi\|2585939279\|dbj\|AP024600.1\|	2819286	g25998	i0	81.784	155.354354354354	269	41	80	7	1	265	2216378	2216642	Luteolibacter sp. LG18 DNA, complete genome	blastn	51733	219	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter sp. LG18
18628706	18628706	PRJNA792582_P_NODE_52335_length_248_cov_1.760000_g51521_i0	PRJNA792582	52335	248	1.76	4.3648	Opitutales bacterium	2026772	Bacteria	Bacteria	202	2.0999999999999998e-47	NTclustered	gi\|2891482117\|emb\|OZ219851.1\|	2026772	g51521	i0	83.122	266.568548387097	237	24	91	14	4	228	1410556	1410324	MAG: Opitutales bacterium isolate e4292735-b3b5-42df-bce3-ad3ef7a88f44 genome assembly, chromosome: 10	blastn	66109	202	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales			Opitutales bacterium
23729817	23729817	PRJNA792582_P_NODE_34419_length_293_cov_2.063636_g33605_i0	PRJNA792582	34419	293	2.063636	6.04645348	Haloferula helveola	490095	Bacteria	Bacteria	82.4	3.47e-11	NTclustered	gi\|2647781590\|dbj\|AP024702.1\|	490095	g33605	i0	87.5	0.989761092150171	72	7	25	2	140	211	505902	505833	Haloferula helveola CN-1 DNA, complete genome	blastn	290	82.4	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Haloferula	Haloferula helveola
23729867	23729867	PRJNA792582_P_NODE_39079_length_280_cov_1.487923_g38265_i0	PRJNA792582	39079	280	1.487923	4.1661844	Prosthecobacter vanneervenii	48466	Bacteria	Bacteria	451	2.18e-122	NTclustered	gi\|12583975\|gb\|AF245379.1\|AF245379	48466	g38265	i0	95.714	223.510714285714	280	12	100	0	1	280	1298	1019	Prosthecobacter sp. FC-2 23S ribosomal RNA gene, partial sequence	blastn	62583	451	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter vanneervenii
24167173	24167173	PRJNA792582_P_NODE_54619_length_246_cov_0.890173_g53805_i0	PRJNA792582	54619	246	0.890173	2.18982558	Verrucomicrobiales	48461	Bacteria	Bacteria	196	9.7e-46	NTclustered	gi\|2022020957\|gb\|CP059069.1\|	2562705	g53805	i0	81.569	251.731707317073	255	31	100	14	1	246	3411479	3411726	Akkermansiaceae bacterium strain AJA081-3 chromosome, complete genome	blastn	61926	196	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Akkermansiaceae		Akkermansiaceae bacterium
25003461	25003461	PRJNA792582_P_NODE_39860_length_278_cov_1.468293_g39046_i0	PRJNA792582	39860	278	1.468293	4.08185454	Luteolibacter ambystomatis	2824561	Bacteria	Bacteria	322	1.77e-83	NTclustered	gi\|2029343589\|gb\|CP073100.1\|	2824561	g39046	i0	88.087	65.4676258992806	277	26	99	6	5	278	277731	277459	Luteolibacter ambystomatis strain 32A chromosome, complete genome	blastn	18200	322	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Luteolibacter	Luteolibacter ambystomatis
25442090	25442090	PRJNA792582_P_NODE_33040_length_300_cov_1.339207_g32226_i0	PRJNA792582	33040	300	1.339207	4.017621	Opitutaceae	134623	Bacteria	Bacteria	422	1.85e-113	NTclustered	gi\|1070531674\|gb\|CP016094.1\|	1838286	g32226	i0	92.027	95.2166666666667	301	23	100	1	1	300	2557194	2557494	Lacunisphaera limnophila strain IG16b, complete genome	blastn	28565	422	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae	Lacunisphaera	Lacunisphaera limnophila

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