metadata: contig_metadata: 11 rows where analysis = "blastn", bioproject = "PRJNA670521" and tax

11 rows where analysis = "blastn", bioproject = "PRJNA670521" 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
638356	638356	PRJNA670521_P_NODE_72981_length_250_cov_0.870056_g72236_i0	PRJNA670521	72981	250	0.870056	2.17514	Adineta vaga	104782	Rotifera	other_Eukaryota	171	5.99e-38	NTclustered	gi\|188501533\|gb\|EU643477.1\|	104782	g72236	i0	84.181	1.604	177	27	71	1	1	176	66602	66426	Adineta vaga clone Av_TEL_K_A retrotransposons Juno1 and Athenas, and mariner-like, complete sequence; hypothetical protein and B-box zinc finger family-like protein genes, complete cds; transposon mariner-like, complete sequence; cysteine protease and RTX toxin-like protein genes, complete cds; transposons mariner-like, piggyBac-like, and mariner-like, complete sequence; NHL repeat protein-like protein gene, complete cds; transposons hobo-like and Tc/mariner superfamily, and Athena, complete sequence; histidine ammonia-lyase-like protein gene, complete cds; long-chain acyl-CoA synthetase-like protein gene, partial cds; transposon piggyBac-like AvPokey1.3, complete sequence; and unknown genes	blastn	401	171	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Adinetida	Adinetidae	Adineta	Adineta vaga
1914418	1914418	PRJNA670521_P_NODE_5242_length_770_cov_8.205165_g4568_i0	PRJNA670521	5242	770	8.205165	63.1797705	Philodina citrina	468664	Rotifera	other_Eukaryota	645	2.789999999999999e-180	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g4568	i0	82.254	16.8584415584416	772	113	99	21	3	766	1659	2414	Philodina citrina complete mitochondrial genome	blastn	12981	645	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
8291270	8291270	PRJNA670521_P_NODE_13787_length_492_cov_1.720764_g13048_i0	PRJNA670521	13787	492	1.720764	8.46615888	Philodina megalotrocha	1234259	Rotifera	other_Eukaryota	665	0	NTclustered	gi\|1976325705\|gb\|MW577597.1\|	1234259	g13048	i0	99.454	79.2540650406504	366	2	74	0	1	366	254	619	Philodina megalotrocha isolate RiGrAm.3.1 cytochrome c oxidase subunit I (COX1) gene, partial cds; mitochondrial	blastn	38993	665	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina megalotrocha
8291384	8291384	PRJNA670521_P_NODE_44787_length_309_cov_1.927966_g44042_i0	PRJNA670521	44787	309	1.927966	5.95741494	Brachionus manjavacas	667381	Rotifera	other_Eukaryota	189	2.1099999999999998e-43	NTclustered	gi\|307640088\|gb\|GQ894756.1\|	667381	g44042	i0	86.286	59.252427184466	175	23	56	1	1	174	282	456	Brachionus manjavacas isolate Bsal11 cytochrome oxidase c subunit I (cox1b) gene, partial cds; mitochondrial	blastn	18309	189	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus manjavacas
9566991	9566991	PRJNA670521_P_NODE_8968_length_596_cov_1.938815_g8237_i0	PRJNA670521	8968	596	1.938815	11.5553374	Brachionus rubens	392764	Rotifera	other_Eukaryota	224	1.18e-53	NTclustered	gi\|1802791198\|gb\|MN256531.1\|	392764	g8237	i0	76.233	23.1342281879195	446	93	74	13	41	480	11516	11078	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	13788	224	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
10842246	10842246	PRJNA670521_P_NODE_49469_length_297_cov_1.375000_g48724_i0	PRJNA670521	49469	297	1.375	4.08375	Philodina citrina	468664	Rotifera	other_Eukaryota	372	1.86e-98	NTclustered	gi\|407227484\|emb\|FR856884.1\|	468664	g48724	i0	89.226	63.1313131313131	297	32	100	0	1	297	758	1054	Philodina citrina complete mitochondrial genome	blastn	18750	372	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina citrina
10842430	10842430	PRJNA670521_P_NODE_7949_length_630_cov_6.642729_g7225_i0	PRJNA670521	7949	630	6.642729	41.8491927	Brachionus manjavacas	667381	Rotifera	other_Eukaryota	540	1.0899999999999999e-148	NTclustered	gi\|2006240385\|gb\|MW559988.1\|	667381	g7225	i0	84.021	57.0428571428571	582	71	91	16	2	575	10502	9935	Brachionus manjavacas isolate DE chromosome I mitochondrion, complete sequence	blastn	35937	540	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus manjavacas
12117346	12117346	PRJNA670521_P_NODE_33050_length_347_cov_1.686131_g32305_i0	PRJNA670521	33050	347	1.686131	5.85087457	Anomopus telphusae	338910	Rotifera	other_Eukaryota	566	9.489999999999997e-157	NTclustered	gi\|72153748\|gb\|DQ089741.1\|	338910	g32305	i0	95.989	65.478386167147	349	12	100	1	1	347	2439	2787	Anomopus telphusae 28S ribosomal RNA gene, partial sequence	blastn	22721	566	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Anomopus	Anomopus telphusae
12117499	12117499	PRJNA670521_P_NODE_6910_length_673_cov_1.493333_g6199_i0	PRJNA670521	6910	673	1.493333	10.05013109	Brachionus falcatus	392765	Rotifera	other_Eukaryota	390	1.25e-103	NTclustered	gi\|2615504964\|gb\|OR601541.1\|	392765	g6199	i0	77.727	27.4962852897474	651	135	96	10	5	650	698	53	Brachionus falcatus chromosome 1 mitochondrion, complete sequence	blastn	18505	390	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus falcatus
14667060	14667060	PRJNA670521_P_NODE_2432_length_1119_cov_5.131931_g1947_i0	PRJNA670521	2432	1119	5.131931	57.42630789	Brachionus rubens	392764	Rotifera	other_Eukaryota	460	1.6e-124	NTclustered	gi\|632795126\|gb\|KJ489417.1\|	392764	g1947	i0	80.374	25.6487935656836	642	97	56	22	26	652	11178	10551	Brachionus rubens chromosome I mitochondrion, complete sequence	blastn	28701	460	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Ploima	Brachionidae	Brachionus	Brachionus rubens
22842401	22842401	PRJNA670521_P_NODE_50578_length_294_cov_1.742081_g49833_i0	PRJNA670521	50578	294	1.742081	5.12171814	Opisthokonta	33154	Rotifera	other_Eukaryota	241	5.42e-59	NTclustered	gi\|37785582\|gb\|AY210469.1\|	96448	g49833	i0	81.699	88.0544217687075	306	40	100	10	1	294	365	666	Philodina roseola 28S ribosomal RNA gene, partial sequence	blastn	25888	241	1	Eukaryota	Opisthokonta	Metazoa	Rotifera	Eurotatoria	Philodinida	Philodinidae	Philodina	Philodina roseola

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