metadata: contig_metadata: 8 rows where analysis = "diamond", bioproject = "PRJNA688655" and tax

8 rows where analysis = "diamond", bioproject = "PRJNA688655" and tax_phylum = "Chordata"

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
1943160	1943160	PRJNA688655_P_NODE_2762_length_356_cov_2.166078_g2697_i0	PRJNA688655	2762	356	2.166078	7.71123768	root	1	Root_unresolved	Root_unresolved	204	5.6199999999999995e-61	NR	CAI5795825.1	74358	g2697	i0	77.8	2.95786516853933	117	26	98.6	0	355	5	282	398	CAI5795825.1 endogenous retrovirus group K member 11 Pol protein-like [Podarcis lilfordi]	diamond	1053	204	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Podarcis	Podarcis lilfordi
4495141	4495141	PRJNA688655_P_NODE_244_length_1051_cov_2.003067_g202_i0	PRJNA688655	244	1051	2.003067	21.05223417	Metazoa	33208	Chordata	Chordata	475	2.96e-156	NR	CAI7935364.1	74358	g202	i0	64.4	2.98287345385347	348	122	99.3	1	4	1047	363	708	CAI7935364.1 endogenous retrovirus group K member 11 Pol protein-like [Podarcis lilfordi]	diamond	3135	475	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Lacertidae	Podarcis	Podarcis lilfordi
28977172	28977172	PRJNA688655_P_NODE_8748_length_250_cov_0.870056_g8683_i0	PRJNA688655	8748	250	0.870056	2.17514	Emydura macquarii macquarii	1129001	Chordata	Chordata	50.1	1.03e-4	NR	XP_067417499.1	1129001	g8683	i0	69.7	0.396	33	10	39.6	0	2	100	27	59	XP_067417499.1 olfactory receptor 10AG1-like isoform X1 [Emydura macquarii macquarii]	diamond	99	50.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Chelidae	Emydura	Emydura macquarii
29071913	29071913	PRJNA688655_P_NODE_11668_length_246_cov_1.526012_g11603_i0	PRJNA688655	11668	246	1.526012	3.75398952	Mauremys mutica	74926	Chordata	Chordata	95.9	2.58e-23	NR	KAH1173910.1	74926	g11603	i0	83.9	0.682926829268293	56	9	68.3	0	78	245	52	107	KAH1173910.1 hypothetical protein KIL84_017749 [Mauremys mutica]	diamond	168	95.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Geoemydidae	Mauremys	Mauremys mutica
29671286	29671286	PRJNA688655_P_NODE_4690_length_301_cov_2.368421_g4625_i0	PRJNA688655	4690	301	2.368421	7.12894721	Passer domesticus	48849	Chordata	Chordata	73.9	8.25e-13	NR	XP_064267235.1	48849	g4625	i0	57.4	1.08637873754153	54	23	53.8	0	166	5	10	63	XP_064267235.1 endogenous retrovirus group K member 6 Pol protein [Passer domesticus]	diamond	327	73.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Passeridae	Passer	Passer domesticus
29829471	29829471	PRJNA688655_P_NODE_16391_length_241_cov_0.916667_g16326_i0	PRJNA688655	16391	241	0.916667	2.20916747	Mus musculus	10090	Chordata	Chordata	42.7	0.00898	NR	BAE42973.1	10090	g16326	i0	70.4	0.336099585062241	27	8	33.6	0	8	88	40	66	BAE42973.1 unnamed protein product [Mus musculus]	diamond	81	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
30208353	30208353	PRJNA688655_P_NODE_1812_length_414_cov_1.000000_g1747_i0	PRJNA688655	1812	414	1	4.14	Mauremys reevesii	260615	Chordata	Chordata	115	2.4800000000000003e-27	NR	XP_039352353.1	260615	g1747	i0	73.3	0.543478260869565	75	20	54.3	0	184	408	78	152	XP_039352353.1 uncharacterized protein LOC120375641 [Mauremys reevesii]	diamond	225	115	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Geoemydidae	Mauremys	Mauremys reevesii
30367025	30367025	PRJNA688655_P_NODE_11252_length_247_cov_0.885057_g11187_i0	PRJNA688655	11252	247	0.885057	2.18609079	Chrysemys picta bellii	8478	Chordata	Chordata	107	3.84e-26	NR	XP_065415084.1	8478	g11187	i0	78.1	0.777327935222672	64	14	77.7	0	1	192	226	289	XP_065415084.1 uncharacterized protein LOC135973847 [Chrysemys picta bellii]	diamond	192	107	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Emydidae	Chrysemys	Chrysemys picta

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