metadata: contig_metadata: 10 rows where analysis = "blastn", bioproject = "PRJNA407886" and tax

10 rows where analysis = "blastn", bioproject = "PRJNA407886" 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
2968539	2968539	PRJNA407886_P_NODE_61923_length_269_cov_1.571429_g60229_i0	PRJNA407886	61923	269	1.571429	4.22714401	Asplanchna sp.	3231738	Rotifera	other_Eukaryota	159	1.41e-34	NTclustered	gi\|2778092479\|gb\|PP988071.1\|	3231738	g60229	i0	77.574	6.99628252788104	272	55	100	5	1	269	5859	6127	Asplanchna sp. chromosome I mitochondrion, complete sequence	blastn	1882	159	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sp.
6795851	6795851	PRJNA407886_P_NODE_75446_length_246_cov_0.890173_g73752_i0	PRJNA407886	75446	246	0.890173	2.18982558	Adineta vaga	104782	Rotifera	other_Eukaryota	342	1.1799999999999997e-89	NTclustered	gi\|189313895\|gb\|EU637017.1\|	104782	g73752	i0	92.149	8.67479674796748	242	19	98	0	3	244	30485	30244	Adineta vaga glycoprotein gene, partial cds; and hypothetical proteins, DUF288 containing protein, hypothetical protein, methionine sulfoxide reductase, strabismus, S/T/Y kinase, integral membrane protein, plasma membrane calcium ATPase, myosin alkali light chain, hypothetical protein, hsp82, hypothetical protein, DUF288 containing protein, hypothetical protein, saicars, IBR containing protein, hypothetical proteins, NHL repeat containing protein, ubiquitin ligase, snf7, C2 containing protein, PKD channel, synaptotagmin, and hypothetical protein genes, complete cds	blastn	2134	342	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
8070623	8070623	PRJNA407886_P_NODE_38727_length_353_cov_2.671429_g37033_i0	PRJNA407886	38727	353	2.671429	9.43014437	Lepadella cf. ovalis MEG-2012	1225245	Rotifera	other_Eukaryota	375	1.7399999999999998e-99	NTclustered	gi\|401880385\|gb\|JX216760.1\|	1225245	g37033	i0	86.589	97.9688385269122	343	42	97	4	2	342	249	589	Lepadella cf. ovalis MEG-2012 voucher ECOCHZ-AG0566 cytochrome oxidase subunit 1 (COI) gene, partial cds; mitochondrial	blastn	34583	375	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Lepadellidae	Lepadella	Lepadella cf. ovalis MEG-2012
9345092	9345092	PRJNA407886_P_NODE_19188_length_589_cov_2.383721_g17512_i0	PRJNA407886	19188	589	2.383721	14.04011669	Brachionus calyciflorus	104777	Rotifera	other_Eukaryota	353	1.43e-92	NTclustered	gi\|2105975276\|gb\|MZ706949.1\|	104777	g17512	i0	78.598	61.2852292020373	542	110	92	6	1	539	26787	27325	Brachionus calyciflorus chromosome I mitochondrion, complete sequence	blastn	36097	353	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus calyciflorus
10622095	10622095	PRJNA407886_P_NODE_80409_length_242_cov_0.911243_g78715_i0	PRJNA407886	80409	242	0.911243	2.20520806	Adineta vaga	104782	Rotifera	other_Eukaryota	337	5.37e-88	NTclustered	gi\|187233675\|gb\|EU643504.1\|	104782	g78715	i0	91.736	1	242	20	100	0	1	242	334	93	Adineta vaga ubiquinol cytochrome c reductase mRNA, partial cds	blastn	242	337	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
11896444	11896444	PRJNA407886_P_NODE_51110_length_300_cov_1.867841_g49416_i0	PRJNA407886	51110	300	1.867841	5.603523	Brachionus rubens	392764	Rotifera	other_Eukaryota	318	2.4899999999999995e-82	NTclustered	gi\|632795131\|gb\|KJ489418.1\|	392764	g49416	i0	86.348	89.4433333333333	293	39	97	1	9	300	309	17	Brachionus rubens chromosome II mitochondrion, complete sequence	blastn	26833	318	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
16995731	16995731	PRJNA407886_P_NODE_9454_length_1024_cov_9.828601_g8247_i0	PRJNA407886	9454	1024	9.828601	100.64487424	Asplanchna sp.	3231738	Rotifera	other_Eukaryota	394	1.4999999999999995e-104	NTclustered	gi\|2778092479\|gb\|PP988071.1\|	3231738	g8247	i0	75.124	20.12109375	1005	166	95	73	56	1024	2372	1416	Asplanchna sp. chromosome I mitochondrion, complete sequence	blastn	20604	394	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Asplanchnidae	Asplanchna	Asplanchna sp.
18269660	18269660	PRJNA407886_P_NODE_73275_length_248_cov_0.880000_g71581_i0	PRJNA407886	73275	248	0.88	2.1824	Adineta ricciae	249248	Rotifera	other_Eukaryota	263	9.519999999999998e-66	NTclustered	gi\|421999034\|emb\|HE662869.1\|	249248	g71581	i0	91.623	1.0241935483871	191	15	77	1	59	248	1858	1668	Adineta ricciae alien gene expression region, clone Ar_2	blastn	254	263	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta ricciae
20818471	20818471	PRJNA407886_P_NODE_14977_length_720_cov_4.717156_g13380_i0	PRJNA407886	14977	720	4.717156	33.9635232	Philodina citrina	468664	Rotifera	other_Eukaryota	728	0	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g13380	i0	85.205	21.6333333333333	730	84	100	21	1	720	2391	1676	Philodina citrina complete mitochondrial genome	blastn	15576	728	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
23370035	23370035	PRJNA407886_P_NODE_69859_length_251_cov_0.865169_g68165_i0	PRJNA407886	69859	251	0.865169	2.17157419	Macrotrachela quadricornifera	104788	Rotifera	other_Eukaryota	315	2.6299999999999998e-81	NTclustered	gi\|402761759\|gb\|JX184011.1\|	104788	g68165	i0	89.516	13.2709163346614	248	26	99	0	1	248	370	617	Macrotrachela quadricornifera isolate MQ cytochrome c oxidase subunit 2 (COX2) gene, complete cds; mitochondrial	blastn	3331	315	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Macrotrachela	Macrotrachela quadricornifera

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