metadata: contig_metadata: 10 rows where bioproject = "PRJNA781453" and tax

10 rows where bioproject = "PRJNA781453" 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
9691491	9691491	PRJNA781453_P_NODE_6728_length_578_cov_1.524752_g6618_i0	PRJNA781453	6728	578	1.524752	8.81306656	Gemmataceae bacterium	2052164	Bacteria	Bacteria	290	1.03e-93	NR	HJZ53572.1	2052164	g6618	i0	75	1.97231833910035	192	48	99.7	0	1	576	82	273	HJZ53572.1 trypsin-like peptidase domain-containing protein [Gemmataceae bacterium]	diamond	1140	290	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
10966954	10966954	PRJNA781453_P_NODE_35129_length_248_cov_0.862857_g35014_i0	PRJNA781453	35129	248	0.862857	2.13988536	Bacteria	2	Bacteria	Bacteria	139	7.46e-38	NR	MCE9607766.1	2052181	g35014	i0	80.5	3.96774193548387	82	16	99.2	0	2	247	81	162	MCE9607766.1 sulfate ABC transporter substrate-binding protein [Planctomycetia bacterium]	diamond	984	139	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia				Planctomycetia bacterium
10967150	10967150	PRJNA781453_P_NODE_5489_length_641_cov_1.806338_g5382_i0	PRJNA781453	5489	641	1.806338	11.57862658	Gemmataceae bacterium	2052164	Bacteria	Bacteria	360	1.1599999999999995e-119	NR	MEO2088887.1	2052164	g5382	i0	85.4	1.99375975039002	213	31	99.7	0	639	1	298	510	MEO2088887.1 GTP-binding protein [Gemmataceae bacterium]	diamond	1278	360	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
22440495	22440495	PRJNA781453_P_NODE_9078_length_497_cov_1.287736_g8964_i0	PRJNA781453	9078	497	1.287736	6.40004792	Planctomyces sp. SH-PL62	1636152	Bacteria	Bacteria	322	3.35e-83	NTclustered	gi\|1015454008\|gb\|CP011273.1\|	1636152	g8964	i0	85.855	1.27766599597586	304	41	61	2	184	486	289158	288856	Planctomyces sp. SH-PL62, complete genome	blastn	635	322	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Planctomycetales	Planctomycetaceae	Planctomyces	Planctomyces sp. SH-PL62
24989381	24989381	PRJNA781453_P_NODE_37560_length_245_cov_0.895349_g37445_i0	PRJNA781453	37560	245	0.895349	2.19360505	Gemmataceae bacterium	2052164	Bacteria	Bacteria	83.2	2.23e-16	NR	MFO0842695.1	2052164	g37445	i0	58.6	1.06530612244898	87	30	99.2	3	243	1	7	93	MFO0842695.1 tetratricopeptide repeat protein [Gemmataceae bacterium]	diamond	261	83.2	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Gemmatales	Gemmataceae		Gemmataceae bacterium
25439037	25439037	PRJNA781453_P_NODE_2580_length_903_cov_2.187952_g2496_i0	PRJNA781453	2580	903	2.187952	19.75720656	Lentisphaeria bacterium	2053569	Bacteria	Bacteria	235	1.47e-71	NR	MBR1967476.1	2053569	g2496	i0	82.2	1.34551495016611	135	24	44.9	0	406	2	1	135	MBR1967476.1 DegT/DnrJ/EryC1/StrS family aminotransferase [Lentisphaeria bacterium]	diamond	1215	235	1	Bacteria	PVC group	Pseudomonadati	Lentisphaerota	Lentisphaeria				Lentisphaeria bacterium
26809824	26809824	PRJNA781453_P_NODE_37001_length_245_cov_1.058140_g36886_i0	PRJNA781453	37001	245	1.05814	2.592443	Bacteria	2	Bacteria	Bacteria	43.1	0.0286	NR	MEO7413797.1	2006848	g36886	i0	52.9	0.857142857142857	34	16	41.6	0	44	145	474	507	MEO7413797.1 DEAD/DEAH box helicase [Opitutaceae bacterium]	diamond	210	43.1	1	Bacteria	PVC group	Pseudomonadati	Verrucomicrobiota	Opitutia	Opitutales	Opitutaceae		Opitutaceae bacterium
29201140	29201140	PRJNA781453_P_NODE_28649_length_269_cov_1.178571_g28534_i0	PRJNA781453	28649	269	1.178571	3.17035599	Isosphaeraceae bacterium	2691532	Bacteria	Bacteria	132	3.36e-38	NR	HEX8201424.1	2691532	g28534	i0	93.8	0.724907063197026	65	4	72.5	0	73	267	1	65	HEX8201424.1 30S ribosomal protein S19 [Isosphaeraceae bacterium]	diamond	195	132	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Isosphaerales	Isosphaeraceae		Isosphaeraceae bacterium
30527471	30527471	PRJNA781453_P_NODE_36293_length_246_cov_0.890173_g36178_i0	PRJNA781453	36293	246	0.890173	2.18982558	Pirellulaceae bacterium	2699754	Bacteria	Bacteria	135	6.919999999999998e-35	NR	MCC6509679.1	2699754	g36178	i0	76.8	1	82	19	100	0	246	1	103	184	MCC6509679.1 cyclic nucleotide-binding domain-containing protein [Pirellulaceae bacterium]	diamond	246	135	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Planctomycetia	Pirellulales	Pirellulaceae		Pirellulaceae bacterium
32834734	32834734	PRJNA781453_P_NODE_37060_length_245_cov_0.895349_g36945_i0	PRJNA781453	37060	245	0.895349	2.19360505	Candidatus Scalindua sediminis	2798304	Bacteria	Bacteria	43.1	0.0269	NR	MBO1223062.1	2798304	g36945	i0	37.7	0.942857142857143	77	43	88.2	2	228	13	272	348	MBO1223062.1 radical SAM protein [Candidatus Scalindua sediminis]	diamond	231	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Candidatus Brocadiia	Candidatus Brocadiales	Candidatus Scalinduaceae	Candidatus Scalindua	Candidatus Scalindua sediminis

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