metadata: contig_metadata: 5 rows where analysis = "diamond", bioproject = "PRJNA1248424" and tax

5 rows where analysis = "diamond", bioproject = "PRJNA1248424" and tax_phylum = "Campylobacterota"

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_kingdom	tax_phylum	tax_class	tax_order	tax_family	tax_genus	tax_species
26661813	26661813	PRJNA1248424_P_NODE_82101_length_199_cov_6.015873_g76031_i0	PRJNA1248424	82101	199	6.015873	11.97158727	Helicobacter pylori	210	Bacteria	Bacteria	77	4.31e-17	NR	GAA8838853.1	210	g76031	i0	94.6	0.557788944723618	37	2	55.8	0	194	84	7	43	GAA8838853.1 hypothetical protein Kyoto149A_5200 [Helicobacter pylori]	diamond	111	77	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Helicobacteraceae	Helicobacter	Helicobacter pylori
27768825	27768825	PRJNA1248424_P_NODE_67624_length_255_cov_0.813187_g61555_i0	PRJNA1248424	67624	255	0.813187	2.07362685	Campylobacterales bacterium	2268180	Bacteria	Bacteria	53.5	6.67e-6	NR	MBY0539905.1	2268180	g61555	i0	59.6	1.09411764705882	47	17	55.3	1	255	115	334	378	MBY0539905.1 DDE-type integrase/transposase/recombinase [Campylobacterales bacterium]	diamond	279	53.5	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales			Campylobacterales bacterium
28968474	28968474	PRJNA1248424_P_NODE_57548_length_282_cov_1.167464_g51480_i0	PRJNA1248424	57548	282	1.167464	3.29224848	Sulfurovum sp.	1969726	Bacteria	Bacteria	74.7	3.35e-14	NR	MCB4763109.1	1969726	g51480	i0	50.7	8.29787234042553	71	35	75.5	0	65	277	3	73	MCB4763109.1 reverse transcriptase family protein [Sulfurovum sp.]	diamond	2340	74.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.
31369429	31369429	PRJNA1248424_P_NODE_66336_length_258_cov_1.567568_g60267_i0	PRJNA1248424	66336	258	1.567568	4.04432544	Arcobacteraceae bacterium	2808971	Bacteria	Bacteria	42.7	0.0426	NR	MCK5293339.1	2808971	g60267	i0	40.7	0.686046511627907	59	33	68.6	1	78	254	47	103	MCK5293339.1 NnrS family protein [Arcobacteraceae bacterium]	diamond	177	42.7	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Arcobacteraceae		Arcobacteraceae bacterium
32886054	32886054	PRJNA1248424_P_NODE_76400_length_244_cov_1.497076_g70331_i0	PRJNA1248424	76400	244	1.497076	3.65286544	Sulfurovum sp.	1969726	Bacteria	Bacteria	62	6.22e-9	NR	MCB4775620.1	1969726	g70331	i0	64.1	1.91803278688525	39	14	48	0	118	2	336	374	MCB4775620.1 hypothetical protein [Sulfurovum sp.]	diamond	468	62	1	Bacteria	Pseudomonadati	Campylobacterota	Epsilonproteobacteria	Campylobacterales	Sulfurovaceae	Sulfurovum	Sulfurovum sp.

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