metadata: contig_metadata: 10 rows where bioproject = "PRJNA658591" and tax

10 rows where bioproject = "PRJNA658591" 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
13915416	13915416	PRJNA658591_S_NODE_6511_length_188_cov_1.496403_g6448_i0	PRJNA658591	6511	188	1.496403	2.81323764	Cheloniidae	8465	Chordata	Chordata	52.8	0.016	NTclustered	gi\|2911500576\|emb\|OZ223607.1\|	8472	g6448	i0	100	0.446808510638298	28	0	15	0	2	29	10181279	10181252	Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 21	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Cheloniidae	Lepidochelys	Lepidochelys kempii
18477774	18477774	PRJNA658591_S_NODE_2235_length_284_cov_5.519149_g2172_i0	PRJNA658591	2235	284	5.519149	15.67438316	Vicugna pacos	30538	Chordata	Chordata	52.8	0.026	NTclustered	gi\|1777469384\|ref\|XR_004190006.1\|	30538	g2172	i0	100	0.0985915492957746	28	0	10	0	242	269	689	716	PREDICTED: Vicugna pacos uncharacterized LOC116280604 (LOC116280604), ncRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Camelidae	Vicugna	Vicugna pacos
18477786	18477786	PRJNA658591_S_NODE_6435_length_189_cov_1.114286_g6372_i0	PRJNA658591	6435	189	1.114286	2.10600054	Mus caroli	10089	Chordata	Chordata	56.5	0.001	NTclustered	gi\|1679855561\|ref\|XM_029480371.1\|	10089	g6372	i0	100	0.317460317460317	30	0	16	0	44	73	1858	1887	PREDICTED: Mus caroli CYLD lysine 63 deubiquitinase (Cyld), transcript variant X2, mRNA	blastn	60	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus caroli
18477795	18477795	PRJNA658591_S_NODE_815_length_433_cov_4.531250_g752_i0	PRJNA658591	815	433	4.53125	19.6203125	Spinus spinus	160760	Chordata	Chordata	54.7	0.012	NTclustered	gi\|2917663466\|emb\|OZ228753.1\|	160760	g752	i0	94.444	0.166281755196305	36	1	8	1	156	190	37205122	37205157	Spinus spinus genome assembly, chromosome: 5	blastn	72	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Spinus	Spinus spinus
24113355	24113355	PRJNA658591_S_NODE_8579_length_170_cov_2.760331_g8516_i0	PRJNA658591	8579	170	2.760331	4.6925627	Mammalia	40674	Chordata	Chordata	158	2.93e-34	NTclustered	gi\|2806545747\|ref\|XM_068562404.1\|	9764	g8516	i0	83.432	79.7882352941176	169	28	99	0	1	169	1107	1275	PREDICTED: Eschrichtius robustus ATP synthase F1 subunit alpha (ATP5F1A), mRNA	blastn	13564	158	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Eschrichtiidae	Eschrichtius	Eschrichtius robustus
30598964	30598964	PRJNA658591_S_NODE_2513_length_270_cov_2.932127_g2450_i0	PRJNA658591	2513	270	2.932127	7.9167429	root	1	Root_unresolved	Root_unresolved	107	2.45e-26	NR	XP_051712873.2	9986	g2450	i0	64.8	37.8888888888889	88	27	95.6	2	12	269	111	196	XP_051712873.2 large ribosomal subunit protein eL22 isoform X2 [Oryctolagus cuniculus]	diamond	10230	107	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Lagomorpha	Leporidae	Oryctolagus	Oryctolagus cuniculus
30618386	30618386	PRJNA658591_S_NODE_8853_length_169_cov_0.866667_g8790_i0	PRJNA658591	8853	169	0.866667	1.46466723	Ranitomeya imitator	111125	Chordata	Chordata	59.7	9.52e-10	NR	XP_069586114.1	111125	g8790	i0	51.9	0.958579881656805	54	23	95.9	1	164	3	22	72	XP_069586114.1 COX assembly mitochondrial protein homolog [Ranitomeya imitator]	diamond	162	59.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Dendrobatidae	Ranitomeya	Ranitomeya imitator
31123672	31123672	PRJNA658591_S_NODE_5575_length_199_cov_2.193333_g5512_i0	PRJNA658591	5575	199	2.193333	4.36473267	Ciona intestinalis	7719	Chordata	Chordata	70.9	2.55e-12	NR	XP_002120963.1	7719	g5512	i0	60	0.678391959798995	45	18	67.8	0	34	168	565	609	XP_002120963.1 alpha-amylase 2-like [Ciona intestinalis]	diamond	135	70.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Cionidae	Ciona	Ciona intestinalis
31325871	31325871	PRJNA658591_S_NODE_7015_length_183_cov_1.216418_g6952_i0	PRJNA658591	7015	183	1.216418	2.22604494	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	97.1	1.85e-24	NR	XP_053557215.1	8345	g6952	i0	78.3	3.91803278688525	60	13	98.4	0	2	181	5	64	XP_053557215.1 succinyl-CoA:3-ketoacid coenzyme A transferase 1, mitochondrial-like [Bombina bombina]	diamond	717	97.8	0.992842535787321	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Bombinatoridae	Bombina	Bombina bombina
32009648	32009648	PRJNA658591_S_NODE_6498_length_188_cov_2.230216_g6435_i0	PRJNA658591	6498	188	2.230216	4.19280608	Erpetoichthys calabaricus	27687	Chordata	Chordata	66.6	5.46e-11	NR	XP_051791274.1	27687	g6435	i0	71.4	4.69148936170213	49	13	76.6	1	167	24	156	204	XP_051791274.1 E3 SUMO-protein ligase ZBED1-like [Erpetoichthys calabaricus]	diamond	882	67	0.994029850746269	Eukaryota	Opisthokonta	Metazoa	Chordata	Cladistia	Polypteriformes	Polypteridae	Erpetoichthys	Erpetoichthys calabaricus

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