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

5 rows where analysis = "blastn", bioproject = "PRJEB14664" and tax_phylum = "Cnidaria"

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
6088882	6088882	PRJEB14664_P_NODE_4145_length_430_cov_3.336709_g4018_i0	PRJEB14664	4145	430	3.336709	14.3478487	Acropora	6127	Cnidaria	other_Eukaryota	320	1.0299999999999999e-82	NTclustered	gi\|2114279968\|ref\|XM_029330392.2\|	45264	g4018	i0	80.732	97.1372093023256	410	79	95	0	19	428	669	1078	PREDICTED: Acropora millepora tubulin beta-4B chain (LOC114953952), mRNA	blastn	41769	320	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Acroporidae	Acropora	Acropora millepora
8948241	8948241	PRJEB14664_P_NODE_4648_length_401_cov_1.606557_g4518_i0	PRJEB14664	4648	401	1.606557	6.44229357	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	448	4.2e-121	NTclustered	gi\|2782844603\|ref\|XM_067056021.1\|	252671	g4518	i0	86.849	99.9675810473815	403	49	100	4	1	401	1398	998	PREDICTED: Clytia hemisphaerica tubulin beta-4B chain (LOC136799316), mRNA	blastn	40087	448	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
10224007	10224007	PRJEB14664_P_NODE_6009_length_338_cov_1.970297_g5879_i0	PRJEB14664	6009	338	1.970297	6.65960386	Actinia tenebrosa	6105	Cnidaria	other_Eukaryota	200	1.08e-46	NTclustered	gi\|1778043721\|ref\|XM_031703576.1\|	6105	g5879	i0	80.952	21.5147928994083	252	48	75	0	8	259	418	167	PREDICTED: Actinia tenebrosa ras-related protein Rap-1A (LOC116295677), mRNA	blastn	7272	200	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Actiniaria	Actiniidae	Actinia	Actinia tenebrosa
14049399	14049399	PRJEB14664_P_NODE_4512_length_408_cov_3.034853_g4384_i0	PRJEB14664	4512	408	3.034853	12.38220024	Clytia hemisphaerica	252671	Cnidaria	other_Eukaryota	359	2.06e-94	NTclustered	gi\|2782889916\|ref\|XM_067065970.1\|	252671	g4384	i0	82.759	96.7058823529412	406	67	99	3	5	408	1058	654	PREDICTED: Clytia hemisphaerica tubulin alpha-1 chain-like (LOC136809439), mRNA	blastn	39456	359	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Hydrozoa	Leptothecata	Clytiidae	Clytia	Clytia hemisphaerica
16597978	16597978	PRJEB14664_P_NODE_13594_length_195_cov_1.650000_g13464_i0	PRJEB14664	13594	195	1.65	3.2175	Orbicella faveolata	48498	Cnidaria	other_Eukaryota	52.8	0.017	NTclustered	gi\|1176080165\|ref\|XM_020754513.1\|	48498	g13464	i0	100	0.143589743589744	28	0	14	0	155	182	554	527	PREDICTED: Orbicella faveolata uncharacterized LOC110048739 (LOC110048739), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Cnidaria	Anthozoa	Scleractinia	Merulinidae	Orbicella	Orbicella faveolata

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