metadata: contig_metadata: 11 rows where bioproject = "PRJEB28062", tax_clade = "Opisthokonta" and tax

11 rows where bioproject = "PRJEB28062", tax_clade = "Opisthokonta" 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
27475616	27475616	PRJEB28062_P_NODE_50883_length_499_cov_4.971831_g48534_i0	PRJEB28062	50883	499	4.971831	24.80943669	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	212	9.14e-64	NR	RNA44476.1	10195	g48534	i0	94	0.697394789579158	116	7	69.7	0	362	15	29	144	RNA44476.1 glycogen synthase kinase-3 beta isoform X2 [Brachionus plicatilis]	diamond	348	212	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
28107011	28107011	PRJEB28062_P_NODE_92485_length_337_cov_4.424242_g90123_i0	PRJEB28062	92485	337	4.424242	14.90969554	Brachionus plicatilis	10195	Rotifera	other_Eukaryota	79	2.97e-16	NR	RMZ93160.1	10195	g90123	i0	42.7	0.916913946587537	103	58	90.8	1	308	3	8	110	RMZ93160.1 hypothetical protein BpHYR1_047544, partial [Brachionus plicatilis]	diamond	309	79	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus plicatilis
28359520	28359520	PRJEB28062_P_NODE_109246_length_288_cov_5.097674_g106883_i0	PRJEB28062	109246	288	5.097674	14.68130112	Rotaria socialis	392032	Rotifera	other_Eukaryota	142	1.1599999999999999e-41	NR	CAF3351764.1	392032	g106883	i0	86.1	3.29166666666667	79	11	82.3	0	263	27	46	124	CAF3351764.1 unnamed protein product [Rotaria socialis]	diamond	948	142	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria socialis
29174310	29174310	PRJEB28062_P_NODE_120149_length_260_cov_2.042781_g117785_i0	PRJEB28062	120149	260	2.042781	5.3112306	Rotaria	231623	Rotifera	other_Eukaryota	102	1.37e-25	NR	CAF0719423.1	2762511	g117785	i0	75.8	2.28461538461538	66	16	76.2	0	250	53	93	158	CAF0719423.1 unnamed protein product [Rotaria sp. Silwood1]	diamond	594	102	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Rotaria	Rotaria sp. Silwood1
30728248	30728248	PRJEB28062_P_NODE_118594_length_264_cov_1.612565_g116231_i0	PRJEB28062	118594	264	1.612565	4.2571716	Didymodactylos carnosus	1234261	Rotifera	other_Eukaryota	140	3.21e-41	NR	CAF1596920.1	1234261	g116231	i0	100	0.75	66	0	75	0	66	263	1	66	CAF1596920.1 unnamed protein product, partial [Didymodactylos carnosus]	diamond	198	140	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Didymodactylos	Didymodactylos carnosus
32807977	32807977	PRJEB28062_P_NODE_93420_length_334_cov_9.379310_g91058_i0	PRJEB28062	93420	334	9.37931	31.3268954	Opisthokonta	33154	Rotifera	other_Eukaryota	88.2	1.79e-19	NR	RMZ94042.1	10195	g91058	i0	72.1	10.9580838323353	61	17	54.8	0	208	26	88	148	RMZ94042.1 40S ribosomal S18 [Brachionus plicatilis]	diamond	3660	88.2	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);;