metadata: contig_metadata: 9 rows where analysis = "diamond" and bioproject = "PRJNA1228616"

9 rows where analysis = "diamond" and bioproject = "PRJNA1228616"

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
27641658	27641658	PRJNA1228616_S_NODE_3504_length_215_cov_1.244186_g3481_i0	PRJNA1228616	3504	215	1.244186	2.6749999	Lynx pardinus	191816	Chordata	Chordata	46.6	3.82e-4	NR	VFV35591.1	191816	g3481	i0	48.9	1.29767441860465	47	20	60	1	137	9	30	76	VFV35591.1 ribosomal protein l17 [Lynx pardinus]	diamond	279	46.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Felidae	Lynx	Lynx pardinus
27893925	27893925	PRJNA1228616_S_NODE_2345_length_251_cov_1.456731_g2322_i0	PRJNA1228616	2345	251	1.456731	3.65639481	Phycisphaeraceae bacterium	2026777	Bacteria	Bacteria	43.1	0.0301	NR	MEQ9459848.1	2026777	g2322	i0	33.8	0.812749003984064	68	42	81.3	1	245	42	230	294	MEQ9459848.1 glucosamine-6-phosphate deaminase [Phycisphaeraceae bacterium]	diamond	204	43.1	1	Bacteria	PVC group	Pseudomonadati	Planctomycetota	Phycisphaerae	Phycisphaerales	Phycisphaeraceae		Phycisphaeraceae bacterium
28083378	28083378	PRJNA1228616_S_NODE_8965_length_150_cov_1.317757_g8942_i0	PRJNA1228616	8965	150	1.317757	1.9766355	Lactobacillus delbrueckii	1584	Bacteria	Bacteria	70.1	2.28e-14	NR	MBT8837403.1	1585	g8942	i0	60.9	5.62	46	18	92	0	143	6	19	64	MBT8837403.1 hypothetical protein [Lactobacillus delbrueckii subsp. bulgaricus]	diamond	843	70.1	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Lactobacillus	Lactobacillus delbrueckii
28336045	28336045	PRJNA1228616_S_NODE_6826_length_166_cov_1.016260_g6803_i0	PRJNA1228616	6826	166	1.01626	1.6869916	Heterobasidion irregulare TC 32-1	747525	Fungi	Fungi	42.7	0.0132	NR	XP_009549396.1	747525	g6803	i0	61.3	0.560240963855422	31	11	56	1	139	47	234	263	XP_009549396.1 uncharacterized protein HETIRDRAFT_445859 [Heterobasidion irregulare TC 32-1]	diamond	93	42.7	1	Eukaryota	Opisthokonta	Fungi	Basidiomycota	Agaricomycetes	Russulales	Bondarzewiaceae	Heterobasidion	Heterobasidion irregulare
29283117	29283117	PRJNA1228616_S_NODE_3449_length_216_cov_2.289017_g3426_i0	PRJNA1228616	3449	216	2.289017	4.94427672	Weissella cibaria	137591	Bacteria	Bacteria	43.5	0.00656	NR	WP_196777313.1	137591	g3426	i0	58.8	0.944444444444444	68	18	93.1	4	13	213	21	79	WP_196777313.1 hypothetical protein, partial [Weissella cibaria]	diamond	204	43.5	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Lactobacillaceae	Weissella	Weissella cibaria
29409489	29409489	PRJNA1228616_S_NODE_1069_length_328_cov_3.424561_g1046_i0	PRJNA1228616	1069	328	3.424561	11.23256008	Oxyura jamaicensis	8884	Chordata	Chordata	46.6	0.00359	NR	XP_035182290.1	8884	g1046	i0	50.6	0.740853658536585	81	39	73.2	1	81	320	8	88	XP_035182290.1 homeobox protein EMX1, partial [Oxyura jamaicensis]	diamond	243	46.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Anseriformes	Anatidae	Oxyura	Oxyura jamaicensis
30546691	30546691	PRJNA1228616_S_NODE_2513_length_245_cov_1.707921_g2490_i0	PRJNA1228616	2513	245	1.707921	4.18440645	Staphylococcus aureus	1280	Bacteria	Bacteria	45.1	0.00524	NR	WP_218587743.1	1280	g2490	i0	59	0.955102040816327	78	26	94.3	3	231	1	59	131	WP_218587743.1 hypothetical protein, partial [Staphylococcus aureus]	diamond	234	45.1	1	Bacteria		Bacillati	Bacillota	Bacilli	Bacillales	Staphylococcaceae	Staphylococcus	Staphylococcus aureus
30862608	30862608	PRJNA1228616_S_NODE_7034_length_164_cov_1.438017_g7011_i0	PRJNA1228616	7034	164	1.438017	2.35834788	Enterococcus faecalis	1351	Bacteria	Bacteria	85.9	2.62e-20	NR	WP_375855466.1	1351	g7011	i0	97.9	1.71951219512195	48	1	87.8	0	163	20	37	84	WP_375855466.1 hypothetical protein [Enterococcus faecalis]	diamond	282	85.9	1	Bacteria		Bacillati	Bacillota	Bacilli	Lactobacillales	Enterococcaceae	Enterococcus	Enterococcus faecalis
31842636	31842636	PRJNA1228616_S_NODE_7977_length_156_cov_2.778761_g7954_i0	PRJNA1228616	7977	156	2.778761	4.33486716	Ceratitis capitata	7213	Arthropoda	Arthropoda	60.8	1.71e-9	NR	CAD7015487.1	7213	g7954	i0	62.5	1.07692307692308	56	14	94.2	3	6	152	20	75	CAD7015487.1 unnamed protein product [Ceratitis capitata]	diamond	168	60.8	1	Eukaryota	Opisthokonta	Metazoa	Arthropoda	Insecta	Diptera	Tephritidae	Ceratitis	Ceratitis capitata

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