metadata: contig_metadata: 9 rows where bioproject = "PRJNA608894" and tax

9 rows where bioproject = "PRJNA608894" 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
585894	585894	PRJNA608894_P_NODE_7061_length_1058_cov_4.724873_g6674_i0	PRJNA608894	7061	1058	4.724873	49.98915634	Chthoniobacter sp.	2510640	Bacteria	Bacteria	556	9.869999999999999e-196	NR	MDR3405335.1	2510640	g6674	i0	85.3	0.870510396975425	307	45	87.1	0	1057	137	158	464	MDR3405335.1 translation elongation factor EF1A family protein [Chthoniobacter sp.]	diamond	921	556	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales	Chthoniobacteraceae	Chthoniobacter	Chthoniobacter sp.
4975174	4975174	PRJNA608894_P_NODE_21364_length_432_cov_4.440111_g20868_i0	PRJNA608894	21364	432	4.440111	19.18127952	Prosthecobacter	48463	Bacteria	Bacteria	776	0	NTclustered	gi\|12583974\|gb\|AF245378.1\|AF245378	48464	g20868	i0	99.074	241.659722222222	432	4	100	0	1	432	190	621	Prosthecobacter fusiformis 23S ribosomal RNA gene, partial sequence	blastn	104397	776	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Prosthecobacter	Prosthecobacter fusiformis
13339546	13339546	PRJNA608894_P_NODE_37271_length_294_cov_1.619910_g36772_i0	PRJNA608894	37271	294	1.61991	4.7625354	Pseudomonadati	3379134	Bacteria	Bacteria	156	1.3499999999999997e-42	NR	OUU59431.1	1986793	g36772	i0	73.2	11.8571428571429	97	26	99	0	2	292	417	513	OUU59431.1 MAG: glycine dehydrogenase (aminomethyl-transferring), partial [Verrucomicrobia bacterium TMED60]	diamond	3486	156	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobia bacterium TMED60
19711899	19711899	PRJNA608894_P_NODE_30896_length_329_cov_0.898438_g30397_i0	PRJNA608894	30896	329	0.898438	2.95586102	Verrucomicrobiaceae bacterium	2026800	Bacteria	Bacteria	171	5.39e-50	NR	RYD65414.1	2026800	g30397	i0	77.2	0.9209726443769	101	23	92.1	0	3	305	235	335	RYD65414.1 MAG: hypothetical protein EOP84_31955 [Verrucomicrobiaceae bacterium]	diamond	303	171	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae		Verrucomicrobiaceae bacterium
26840393	26840393	PRJNA608894_P_NODE_55441_length_245_cov_2.232558_g54942_i0	PRJNA608894	55441	245	2.232558	5.4697671	Bacteria	2	Bacteria	Bacteria	47.4	8.69e-4	NR	PYI86484.1	2026799	g54942	i0	36.7	2.90204081632653	79	45	95.5	2	234	1	38	112	PYI86484.1 MAG: succinate-semialdehyde dehydrogenase (NADP(+)), partial [Verrucomicrobiota bacterium]	diamond	711	47.8	0.99163179916318	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
29605999	29605999	PRJNA608894_P_NODE_43590_length_270_cov_2.340102_g43091_i0	PRJNA608894	43590	270	2.340102	6.3182754	Persicirhabdus sediminis	454144	Bacteria	Bacteria	43.9	0.0199	NR	WP_200312416.1	454144	g43091	i0	48.9	0.5	45	20	47.8	3	256	128	377	420	WP_200312416.1 membrane protein insertase YidC [Persicirhabdus sediminis]	diamond	135	43.9	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia	Verrucomicrobiales	Verrucomicrobiaceae	Persicirhabdus	Persicirhabdus sediminis
30648583	30648583	PRJNA608894_P_NODE_14033_length_603_cov_3.281132_g13551_i0	PRJNA608894	14033	603	3.281132	19.785225959999998	Chthoniobacterales bacterium	2201154	Bacteria	Bacteria	87	3.5e-17	NR	MEO5753320.1	2201154	g13551	i0	30.2	0.955223880597015	192	106	87.6	6	535	8	34	213	MEO5753320.1 CAP domain-containing protein [Chthoniobacterales bacterium]	diamond	576	87	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Spartobacteria	Chthoniobacterales			Chthoniobacterales bacterium
31198648	31198648	PRJNA608894_P_NODE_55355_length_246_cov_0.884393_g54856_i0	PRJNA608894	55355	246	0.884393	2.17560678	Verrucomicrobiota	74201	Bacteria	Bacteria	87.8	7.46e-20	NR	NBV85467.1	2026799	g54856	i0	54.2	3.01219512195122	83	37	100	1	1	246	56	138	NBV85467.1 L,D-transpeptidase [Verrucomicrobiota bacterium]	diamond	741	87.8	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota					Verrucomicrobiota bacterium
31344136	31344136	PRJNA608894_P_NODE_43536_length_271_cov_1.040404_g43037_i0	PRJNA608894	43536	271	1.040404	2.81949484	Verrucomicrobiia bacterium	2499141	Bacteria	Bacteria	60.1	4.12e-8	NR	HYG84357.1	2499141	g43037	i0	50.7	0.74169741697417	67	33	74.2	0	270	70	231	297	HYG84357.1 hypothetical protein [Verrucomicrobiia bacterium]	diamond	201	60.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Verrucomicrobiia				Verrucomicrobiia 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);;