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

7 rows where analysis = "diamond", bioproject = "PRJNA1073005" 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
26647194	26647194	PRJNA1073005_P_NODE_8101_length_279_cov_1.490291_g7982_i0	PRJNA1073005	8101	279	1.490291	4.15791189	Chondrichthyes	7777	Chordata	Chordata	96.3	8.28e-21	NR	GCC29143.1	137246	g7982	i0	69	7.64516129032258	71	22	76.3	0	252	40	29	99	GCC29143.1 hypothetical protein [Chiloscyllium punctatum]	diamond	2133	96.7	0.995863495346432	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Orectolobiformes	Hemiscylliidae	Chiloscyllium	Chiloscyllium punctatum
27636199	27636199	PRJNA1073005_P_NODE_7564_length_300_cov_0.841410_g7445_i0	PRJNA1073005	7564	300	0.84141	2.52423	Bufotes viridis	30338	Chordata	Chordata	72.8	1.76e-12	NR	CAK8637855.1	30338	g7445	i0	36.5	1.94	96	61	96	0	290	3	38	133	CAK8637855.1 hypothetical protein BUFVIR_LOCUS19784 [Bufotes viridis]	diamond	582	72.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bufonidae	Bufotes	Bufotes viridis
28290497	28290497	PRJNA1073005_P_NODE_6946_length_326_cov_1.347826_g6827_i0	PRJNA1073005	6946	326	1.347826	4.39391276	Opisthokonta	33154	Chordata	Chordata	106	5.21e-25	NR	XP_035197792.1	8884	g6827	i0	55.3	68.9723926380368	114	42	98.5	3	1	321	62	173	XP_035197792.1 60S ribosomal protein L7a [Oxyura jamaicensis]	diamond	22485	106	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Anseriformes	Anatidae	Oxyura	Oxyura jamaicensis
28299037	28299037	PRJNA1073005_P_NODE_9866_length_245_cov_0.866279_g9747_i0	PRJNA1073005	9866	245	0.866279	2.12238355	Staurois parvus	386267	Chordata	Chordata	80.9	1.12e-17	NR	CAI9618505.1	386267	g9747	i0	45.7	0.991836734693878	81	39	95.5	2	8	241	7	85	CAI9618505.1 unnamed protein product, partial [Staurois parvus]	diamond	243	80.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
29561935	29561935	PRJNA1073005_P_NODE_8650_length_260_cov_1.374332_g8531_i0	PRJNA1073005	8650	260	1.374332	3.5732632	Eublepharis macularius	481883	Chordata	Chordata	81.3	1.31e-15	NR	XP_054827278.1	481883	g8531	i0	66.7	12.0807692307692	54	18	62.3	0	7	168	732	785	XP_054827278.1 uncharacterized protein LOC129324210 [Eublepharis macularius]	diamond	3141	81.6	0.996323529411765	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Eublepharidae	Eublepharis	Eublepharis macularius
29593255	29593255	PRJNA1073005_P_NODE_10190_length_242_cov_0.911243_g10071_i0	PRJNA1073005	10190	242	0.911243	2.20520806	Staurois parvus	386267	Chordata	Chordata	113	2.2600000000000003e-27	NR	CAI9609180.1	386267	g10071	i0	68.4	6.85537190082645	79	25	97.9	0	3	239	172	250	CAI9609180.1 unnamed protein product [Staurois parvus]	diamond	1659	113	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ranidae	Staurois	Staurois parvus
29837677	29837677	PRJNA1073005_P_NODE_10131_length_243_cov_0.858824_g10012_i0	PRJNA1073005	10131	243	0.858824	2.08694232	Metazoa	33208	Chordata	Chordata	93.2	6.4e-20	NR	XP_043938962.1	7888	g10012	i0	97.8	3.97530864197531	46	1	56.8	0	242	105	636	681	XP_043938962.1 glutamine--fructose-6-phosphate aminotransferase [isomerizing] 1 [Protopterus annectens]	diamond	966	93.2	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Ceratodontiformes	Protopteridae	Protopterus	Protopterus annectens

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