metadata: contig_metadata: 14 rows where bioproject = "PRJNA229468" and tax

14 rows where bioproject = "PRJNA229468" 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
367288	367288	PRJNA229468_S_NODE_321_length_277_cov_4.311404_g308_i0	PRJNA229468	321	277	4.311404	11.94258908	Ciona intestinalis	7719	Chordata	Chordata	235	2.3599999999999997e-57	NTclustered	gi\|1494783678\|ref\|XM_009862731.3\|	7719	g308	i0	82.955	152.649819494585	264	41	99	4	16	277	1225	1486	PREDICTED: Ciona intestinalis polyubiquitin-A (LOC100175058), transcript variant X1, mRNA	blastn	42284	235	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Ascidiacea	Phlebobranchia	Cionidae	Ciona	Ciona intestinalis
1642070	1642070	PRJNA229468_S_NODE_862_length_180_cov_1.450382_g849_i0	PRJNA229468	862	180	1.450382	2.6106876	Trichechus manatus latirostris	127582	Chordata	Chordata	73.6	2.23e-13	NR	XP_004378497.1	127582	g849	i0	66.7	17.1	57	19	95	0	177	7	251	307	XP_004378497.1 E3 ubiquitin-protein ligase UHRF1 [Trichechus manatus latirostris]	diamond	3078	73.9	0.995940460081191	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Sirenia	Trichechidae	Trichechus	Trichechus manatus
4194376	4194376	PRJNA229468_S_NODE_844_length_181_cov_2.303030_g831_i0	PRJNA229468	844	181	2.30303	4.1684843	Xenopus tropicalis	8364	Chordata	Chordata	111	2.5e-20	NTclustered	gi\|77620966\|emb\|CR761546.2\|	8364	g831	i0	79.29	3.7292817679558	169	27	91	6	11	175	271	107	Xenopus tropicalis finished cDNA, clone TGas127d10	blastn	675	111	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus tropicalis
5470639	5470639	PRJNA229468_S_NODE_905_length_177_cov_2.257812_g892_i0	PRJNA229468	905	177	2.257812	3.99632724	Scyliorhinus canicula	7830	Chordata	Chordata	95.3	2.45e-15	NTclustered	gi\|1952512345\|ref\|XM_038789812.1\|	7830	g892	i0	79.412	2.30508474576271	136	26	76	2	43	177	246	112	PREDICTED: Scyliorhinus canicula 60S ribosomal protein L11-like (LOC119962035), mRNA	blastn	408	95.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Chondrichthyes	Carcharhiniformes	Scyliorhinidae	Scyliorhinus	Scyliorhinus canicula
9984666	9984666	PRJNA229468_S_NODE_1148_length_164_cov_1.217391_g1135_i0	PRJNA229468	1148	164	1.217391	1.99652124	root	1	Root_unresolved	Root_unresolved	189	1e-43	NTclustered	gi\|2805740242\|emb\|OZ078478.1\|	7748	g1135	i0	88.05	97.0731707317073	159	19	97	0	1	159	103581	103739	Lampetra fluviatilis genome assembly, chromosome: 75	blastn	15920	189	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
11845855	11845855	PRJNA229468_S_NODE_890_length_178_cov_1.790698_g877_i0	PRJNA229468	890	178	1.790698	3.18744244	Hyla sarda	327740	Chordata	Chordata	104	4.1e-18	NTclustered	gi\|2512160901\|ref\|XM_056558662.1\|	327740	g877	i0	81.967	2.45505617977528	122	22	69	0	1	122	302	181	PREDICTED: Hyla sarda tyrosine 3-monooxygenase/tryptophan 5-monooxygenase activation protein epsilon (YWHAE), transcript variant X1, mRNA	blastn	437	104	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Hylidae	Hyla	Hyla sarda
11845856	11845856	PRJNA229468_S_NODE_930_length_175_cov_1.944444_g917_i0	PRJNA229468	930	175	1.944444	3.402777	Opisthokonta	33154	Chordata	Chordata	105	3.6199999999999997e-28	NR	KAH0506066.1	79684	g917	i0	86	17.0228571428571	57	8	97.7	0	3	173	6	62	KAH0506066.1 60S ribosomal protein L36a [Microtus ochrogaster]	diamond	2979	106	0.990566037735849	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Cricetidae	Microtus	Microtus ochrogaster
15670083	15670083	PRJNA229468_S_NODE_1033_length_168_cov_1.285714_g1020_i0	PRJNA229468	1033	168	1.285714	2.15999952	Chrysochloris asiatica	185453	Chordata	Chordata	95.3	2.31e-15	NTclustered	gi\|586491719\|ref\|XM_006876253.1\|	185453	g1020	i0	87.059	40.5178571428571	85	10	51	1	82	166	415	332	PREDICTED: Chrysochloris asiatica solute carrier family 25 (mitochondrial carrier; adenine nucleotide translocator), member 6 (SLC25A6), mRNA	blastn	6807	95.3	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia		Chrysochloridae	Chrysochloris	Chrysochloris asiatica
16944571	16944571	PRJNA229468_S_NODE_694_length_197_cov_1.033784_g681_i0	PRJNA229468	694	197	1.033784	2.03655448	Chordata	7711	Chordata	Chordata	85.5	1.73e-17	NR	XP_067954439.1	7769	g681	i0	66.1	10.5837563451777	62	20	92.9	1	186	4	389	450	XP_067954439.1 LOW QUALITY PROTEIN: thioredoxin reductase 1, cytoplasmic-like [Myxine glutinosa]	diamond	2085	85.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Myxini	Myxiniformes	Myxinidae	Myxine	Myxine glutinosa
23319336	23319336	PRJNA229468_S_NODE_619_length_206_cov_0.974522_g606_i0	PRJNA229468	619	206	0.974522	2.00751532	Sitta europaea	50251	Chordata	Chordata	52.8	0.018	NTclustered	gi\|2917598300\|emb\|OZ228662.1\|	50251	g606	i0	100	0.135922330097087	28	0	14	0	1	28	9505611	9505584	Sitta europaea genome assembly, chromosome: 8	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Sittidae	Sitta	Sitta europaea
23319341	23319341	PRJNA229468_S_NODE_999_length_170_cov_2.421488_g986_i0	PRJNA229468	999	170	2.421488	4.1165296	Geotrypetes seraphini	260995	Chordata	Chordata	65.8	1.83e-6	NTclustered	gi\|1835613316\|ref\|XM_033917946.1\|	260995	g986	i0	75.94	4.00588235294118	133	28	77	4	35	165	346	476	PREDICTED: Geotrypetes seraphini ribosomal protein S25 (RPS25), mRNA	blastn	681	65.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Gymnophiona	Dermophiidae	Geotrypetes	Geotrypetes seraphini
28134157	28134157	PRJNA229468_S_NODE_1045_length_167_cov_1.855932_g1032_i0	PRJNA229468	1045	167	1.855932	3.09940644	Mammalia	40674	Chordata	Chordata	80.1	8.94e-16	NR	XP_058138020.1	9361	g1032	i0	67.3	31.6167664670659	55	18	98.8	0	166	2	503	557	XP_058138020.1 E3 ubiquitin-protein ligase UHRF1 isoform X1 [Dasypus novemcinctus]	diamond	5280	80.1	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Cingulata	Dasypodidae	Dasypus	Dasypus novemcinctus
30358843	30358843	PRJNA229468_S_NODE_652_length_202_cov_1.666667_g639_i0	PRJNA229468	652	202	1.666667	3.36666734	Ascaphus truei	8439	Chordata	Chordata	51.6	1.17e-5	NR	MEE6511301.1	8439	g639	i0	37.1	1.03960396039604	70	36	93.6	2	3	191	165	233	MEE6511301.1 hypothetical protein [Ascaphus truei]	diamond	210	51.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Ascaphidae	Ascaphus	Ascaphus truei
31717486	31717486	PRJNA229468_S_NODE_897_length_178_cov_1.162791_g884_i0	PRJNA229468	897	178	1.162791	2.06976798	Engystomops pustulosus	76066	Chordata	Chordata	43.9	7.71e-4	NR	KAG8588135.1	76066	g884	i0	57.1	0.589887640449438	35	13	59	1	1	105	37	69	KAG8588135.1 hypothetical protein GDO81_005883 [Engystomops pustulosus]	diamond	105	43.9	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Leptodactylidae	Engystomops	Engystomops pustulosus

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