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

5 rows where analysis = "blastn", bioproject = "PRJEB11748" and tax_phylum = "Rotifera"

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
4810935	4810935	PRJEB11748_P_NODE_148084_length_337_cov_12.634058_g145903_i0	PRJEB11748	148084	337	12.634058	42.57677546	Ploima	84394	Rotifera	other_Eukaryota	446	1.25e-120	NTclustered	gi\|61200811\|gb\|AY829085.1\|	84397	g145903	i0	91.239	57.593471810089	331	24	97	4	11	337	2104	1775	Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence	blastn	19409	448	0.995535714285714	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sieboldii
6397227	6397227	PRJEB11748_P_NODE_38766_length_701_cov_13.584375_g36765_i0	PRJEB11748	38766	701	13.584375	95.22646875	Asplanchna sieboldii	84397	Rotifera	other_Eukaryota	1107	0	NTclustered	gi\|61200811\|gb\|AY829085.1\|	84397	g36765	i0	95.982	83.5820256776034	672	24	96	2	22	691	1434	2104	Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence	blastn	58591	1107	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sieboldii
14044022	14044022	PRJEB11748_P_NODE_203752_length_280_cov_11.926941_g201569_i0	PRJEB11748	203752	280	11.926941	33.3954348	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	351	2.27e-92	NTclustered	gi\|402761759\|gb\|JX184011.1\|	104788	g201569	i0	91.406	15.6	256	22	91	0	3	258	617	362	Macrotrachela quadricornifera isolate MQ cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	4368	351	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera
18836628	18836628	PRJEB11748_P_NODE_40855_length_680_cov_96.096931_g38823_i0	PRJEB11748	40855	680	96.096931	653.4591308	Eurotatoria	2816136	Rotifera	other_Eukaryota	1075	0	NTclustered	gi\|72153731\|gb\|DQ089739.1\|	104782	g38823	i0	97.91	38.6544117647059	622	11	91	2	36	656	2190	1570	Adineta vaga 28S ribosomal RNA gene, partial sequence	blastn	26285	1081	0.994449583718779	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
19140680	19140680	PRJEB11748_P_NODE_164116_length_318_cov_14.455253_g161933_i0	PRJEB11748	164116	318	14.455253	45.96770454	Asplanchna sieboldii	84397	Rotifera	other_Eukaryota	451	2.51e-122	NTclustered	gi\|61200811\|gb\|AY829085.1\|	84397	g161933	i0	94.237	88.9874213836478	295	17	93	0	1	295	1727	1433	Asplanchna sieboldi 28S ribosomal RNA gene, partial sequence	blastn	28298	451	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sieboldii

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