metadata: contig_metadata: 5 rows where bioproject = "PRJNA575566" and tax

5 rows where bioproject = "PRJNA575566" and tax_phylum = "Platyhelminthes"

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
7514505	7514505	PRJNA575566_P_NODE_14106_length_280_cov_1.168950_g13909_i0	PRJNA575566	14106	280	1.16895	3.27306	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	209	1.45e-49	NTclustered	gi\|341925955\|dbj\|AB610878.1\|	6161	g13909	i0	82.143	88.8535714285714	252	37	89	8	31	278	1031	1278	Dugesia japonica Djtuba mRNA for tubulin alpha chain, complete cds	blastn	24879	209	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Dugesia	Dugesia japonica
10764279	10764279	PRJNA575566_P_NODE_18649_length_243_cov_2.730769_g18452_i0	PRJNA575566	18649	243	2.730769	6.63576867	Macrostomum lignano	282301	Platyhelminthes	Platyhelminthes	377	3.18e-100	NTclustered	gi\|926460157\|gb\|KR132223.1\|	282301	g18452	i0	94.65	1	243	13	100	0	1	243	287	529	Macrostomum lignano clone c100550_g1_i1 mRNA sequence	blastn	243	377	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Macrostomida	Macrostomidae	Macrostomum	Macrostomum lignano
28311351	28311351	PRJNA575566_P_NODE_15446_length_268_cov_1.545894_g15249_i0	PRJNA575566	15446	268	1.545894	4.14299592	Mesocestoides corti	53468	Platyhelminthes	Platyhelminthes	77.8	1e-14	NR	VDD81745.1	53468	g15249	i0	50.6	0.92910447761194	83	26	92.9	1	17	265	112	179	VDD81745.1 unnamed protein product, partial [Mesocestoides corti]	diamond	249	77.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Cestoda	Cyclophyllidea	Mesocestoididae	Mesocestoides	Mesocestoides corti
29240522	29240522	PRJNA575566_P_NODE_9549_length_338_cov_1.386282_g9352_i0	PRJNA575566	9549	338	1.386282	4.68563316	Schistosomatidae	31245	Platyhelminthes	Platyhelminthes	168	2.63e-49	NR	CAX78280.1	6182	g9352	i0	75	15.887573964497	112	28	99.4	0	336	1	5	116	CAX78280.1 putative ribosomal protein L5 [Schistosoma japonicum]	diamond	5370	169	0.994082840236686	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
32514320	32514320	PRJNA575566_P_NODE_24099_length_209_cov_0.864865_g23902_i0	PRJNA575566	24099	209	0.864865	1.80756785	Calicophoron daubneyi	300641	Platyhelminthes	Platyhelminthes	82.8	1.86e-16	NR	CAL5132287.1	300641	g23902	i0	54.3	3.01435406698565	70	31	99	1	2	208	1509	1578	CAL5132287.1 unnamed protein product [Calicophoron daubneyi]	diamond	630	82.8	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Plagiorchiida	Paramphistomidae	Calicophoron	Calicophoron daubneyi

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