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

5 rows where analysis = "blastn", bioproject = "PRJEB28062" 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
23935	23935	PRJEB28062_P_NODE_126441_length_247_cov_3.683908_g124077_i0	PRJEB28062	126441	247	3.683908	9.09925276	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	385	1.94e-102	NTclustered	gi\|308156989\|gb\|GQ890454.1\|	10195	g124077	i0	99.526	68.9595141700405	211	1	85	0	24	234	13	223	Brachionus plicatilis isolate DNA16 large subunit ribosomal RNA gene, partial sequence	blastn	17033	385	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
1298679	1298679	PRJEB28062_P_NODE_27622_length_705_cov_71.950949_g25364_i0	PRJEB28062	27622	705	71.950949	507.25419045	Brachionus urceolaris	204736	Rotifera	other_Eukaryota	1142	0	NTclustered	gi\|72153738\|gb\|DQ089740.1\|	204736	g25364	i0	97.325	78.4269503546099	673	16	95	2	24	695	1430	2101	Brachionus urceolaris 28S ribosomal RNA gene, partial sequence	blastn	55291	1142	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus urceolaris
7364974	7364974	PRJEB28062_P_NODE_26146_length_726_cov_108.716692_g23906_i1	PRJEB28062	26146	726	108.716692	789.28318392	Metazoa	33208	Rotifera	other_Eukaryota	1146	0	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g23906	i1	96.537	38.8595041322314	693	23	95	1	24	716	1841	2532	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	28212	1146	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola
7676183	7676183	PRJEB28062_P_NODE_12547_length_1084_cov_249.159248_g10799_i0	PRJEB28062	12547	1084	249.159248	2700.88624832	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	1884	0	NTclustered	gi\|170016231\|ref\|NC_010472.1\|	10195	g10799	i0	98.865	40.1918819188192	1057	11	98	1	24	1080	9900	10955	Brachionus plicatilis mitochondrion part I, complete genome	blastn	43568	1884	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
16289656	16289656	PRJEB28062_P_NODE_116373_length_269_cov_4.596939_g114010_i0	PRJEB28062	116373	269	4.596939	12.36576591	Brachionus	10194	Rotifera	other_Eukaryota	399	7.639999999999999e-107	NTclustered	gi\|14029816\|gb\|AF364508.1\|AF364508	10195	g114010	i0	95.6	75.17843866171	250	9	92	2	22	269	185	434	Brachionus plicatilis 16S ribosomal RNA gene, partial sequence; mitochondrial gene for mitochondrial product	blastn	20223	399	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis

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