metadata: contig_metadata: 5 rows where analysis = "blastn", bioproject = "PRJNA741997" and tax

5 rows where analysis = "blastn", bioproject = "PRJNA741997" 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
14750293	14750293	PRJNA741997_P_NODE_25972_length_435_cov_10.367403_g24852_i0	PRJNA741997	25972	435	10.367403	45.09820305	Schistosoma japonicum	6182	Platyhelminthes	Platyhelminthes	728	0	NTclustered	gi\|68479954\|gb\|DQ076149.1\|	6182	g24852	i0	97.005	0.997701149425287	434	12	99	1	1	434	449	17	Schistosoma japonicum clone 1XA1 unknown mRNA	blastn	434	728	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma japonicum
14750425	14750425	PRJNA741997_P_NODE_47732_length_313_cov_1.429167_g46612_i0	PRJNA741997	47732	313	1.429167	4.47329271	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	388	1.96e-103	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g46612	i0	88.657	4.31629392971246	335	16	100	7	1	313	446	780	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	1351	388	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
16501144	16501144	PRJNA741997_P_NODE_57433_length_283_cov_2.490476_g56313_i0	PRJNA741997	57433	283	2.490476	7.04804708	Metazoa	33208	Platyhelminthes	Platyhelminthes	523	4.5999999999999983e-144	NTclustered	gi\|15808977\|gb\|AF418550.1\|	6183	g56313	i0	100	98.1342756183746	283	0	100	0	1	283	539	257	Schistosoma mansoni albumin precursor, mRNA, complete cds	blastn	27772	523	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni
21124081	21124081	PRJNA741997_P_NODE_52217_length_297_cov_2.857143_g51097_i0	PRJNA741997	52217	297	2.857143	8.48571471	Schmidtea mediterranea	79327	Platyhelminthes	Platyhelminthes	300	8.92e-77	NTclustered	gi\|62199102\|gb\|AY967472.1\|	79327	g51097	i0	87.023	85.7306397306397	262	34	88	0	36	297	97	358	Schmidtea mediterranea clone HE.1.01H mRNA sequence	blastn	25462	300	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Rhabditophora	Tricladida	Dugesiidae	Schmidtea	Schmidtea mediterranea
23674344	23674344	PRJNA741997_P_NODE_18539_length_539_cov_1.457082_g17425_i0	PRJNA741997	18539	539	1.457082	7.85367198	Schistosoma mansoni	6183	Platyhelminthes	Platyhelminthes	566	1.53e-156	NTclustered	gi\|1369885\|gb\|L78441.1\|SCM14332R	6183	g17425	i0	94.086	8.58070500927644	372	22	69	0	3	374	372	1	Schistosoma mansoni 14-3-3-2 mRNA, 3' end of cds	blastn	4625	566	1	Eukaryota	Opisthokonta	Metazoa	Platyhelminthes	Trematoda	Strigeidida	Schistosomatidae	Schistosoma	Schistosoma mansoni

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