metadata: contig_metadata: 7 rows where analysis = "diamond", bioproject = "PRJNA1145574" and tax

7 rows where analysis = "diamond", bioproject = "PRJNA1145574" 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
28049675	28049675	PRJNA1145574_P_NODE_13505_length_246_cov_0.901734_g13321_i0	PRJNA1145574	13505	246	0.901734	2.21826564	Rangifer tarandus platyrhynchus	3082113	Chordata	Chordata	124	2.9899999999999998e-34	NR	CAI9154273.1	3082113	g13321	i0	82.7	0.914634146341463	75	13	91.5	0	22	246	1	75	CAI9154273.1 unnamed protein product [Rangifer tarandus platyrhynchus]	diamond	225	124	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Cervidae	Rangifer	Rangifer tarandus
28890937	28890937	PRJNA1145574_P_NODE_14848_length_242_cov_0.923077_g14664_i0	PRJNA1145574	14848	242	0.923077	2.23384634	Passeriformes	9126	Chordata	Chordata	94.7	1.86e-20	NR	XP_064267235.1	48849	g14664	i0	50	13.8223140495868	78	39	96.7	0	234	1	784	861	XP_064267235.1 endogenous retrovirus group K member 6 Pol protein [Passer domesticus]	diamond	3345	94.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Passeridae	Passer	Passer domesticus
29091746	29091746	PRJNA1145574_P_NODE_9028_length_286_cov_1.361502_g8844_i0	PRJNA1145574	9028	286	1.361502	3.89389572	Crocuta crocuta	9678	Chordata	Chordata	88.6	3.7e-19	NR	KAF0884676.1	9678	g8844	i0	66.2	0.681818181818182	65	22	68.2	0	3	197	35	99	KAF0884676.1 LORF2 protein, partial [Crocuta crocuta]	diamond	195	88.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Hyaenidae	Crocuta	Crocuta crocuta
30165154	30165154	PRJNA1145574_P_NODE_6192_length_344_cov_1.151292_g6008_i0	PRJNA1145574	6192	344	1.151292	3.96044448	Rissa tridactyla	75485	Chordata	Chordata	52	6.68e-5	NR	XP_054037764.1	75485	g6008	i0	58.3	0.418604651162791	48	20	41.9	0	243	100	543	590	XP_054037764.1 uncharacterized protein LOC128900532 [Rissa tridactyla]	diamond	144	52	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Charadriiformes	Laridae	Rissa	Rissa tridactyla
30734032	30734032	PRJNA1145574_P_NODE_13134_length_247_cov_0.896552_g12950_i0	PRJNA1145574	13134	247	0.896552	2.21448344	Calidris pugnax	198806	Chordata	Chordata	58.9	7.82e-8	NR	XP_014808060.1	198806	g12950	i0	51.6	0.753036437246964	62	29	74.1	1	20	202	220	281	XP_014808060.1 PREDICTED: uncharacterized protein LOC106894085 [Calidris pugnax]	diamond	186	58.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Charadriiformes	Scolopacidae	Calidris	Calidris pugnax
31967004	31967004	PRJNA1145574_P_NODE_14618_length_243_cov_0.917647_g14434_i0	PRJNA1145574	14618	243	0.917647	2.22988221	Agelaius tricolor	9191	Chordata	Chordata	42.7	0.0356	NR	XP_071304911.1	9191	g14434	i0	42.4	0.814814814814815	66	36	81.5	1	199	2	62	125	XP_071304911.1 uncharacterized protein [Agelaius tricolor]	diamond	198	42.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Icteridae	Agelaius	Agelaius tricolor
32220311	32220311	PRJNA1145574_P_NODE_12318_length_249_cov_0.920455_g12134_i0	PRJNA1145574	12318	249	0.920455	2.29193295	Tupaia chinensis	246437	Chordata	Chordata	56.6	5.22e-7	NR	ELW65328.1	246437	g12134	i0	54.9	0.855421686746988	71	30	83.1	1	1	207	370	440	ELW65328.1 Pre-mRNA-splicing factor 38B [Tupaia chinensis]	diamond	213	56.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Scandentia	Tupaiidae	Tupaia	Tupaia chinensis

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