metadata: contig_metadata: 17 rows where analysis = "blastn", bioproject = "PRJNA721440" and tax

17 rows where analysis = "blastn", bioproject = "PRJNA721440" and tax_phylum = "Chordata"

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
710156	710156	PRJNA721440_S_NODE_7141_length_232_cov_1.688525_g7015_i0	PRJNA721440	7141	232	1.688525	3.917378	Elgaria multicarinata	71008	Chordata	Chordata	58.4	4.46e-4	NTclustered	gi\|2676901519\|ref\|XM_063135198.1\|	159646	g7015	i0	94.595	1.67672413793103	37	2	16	0	114	150	793	757	PREDICTED: Elgaria multicarinata webbii high mobility group box 2 (HMGB2), mRNA	blastn	389	58.4	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Lepidosauria	Squamata	Anguidae	Elgaria	Elgaria multicarinata
710164	710164	PRJNA721440_S_NODE_9741_length_207_cov_1.139241_g9615_i0	PRJNA721440	9741	207	1.139241	2.35822887	Pyrrhula murina	928672	Chordata	Chordata	54.7	0.005	NTclustered	gi\|2920008266\|emb\|OZ238999.1\|	928672	g9615	i0	100	0.140096618357488	29	0	14	0	6	34	17662789	17662761	Pyrrhula murina genome assembly, chromosome: 5	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Passeriformes	Fringillidae	Pyrrhula	Pyrrhula murina
1193625	1193625	PRJNA721440_S_NODE_14181_length_180_cov_1.679389_g14055_i0	PRJNA721440	14181	180	1.679389	3.0229002	root	1	Root_unresolved	Root_unresolved	56.5	0.001	NTclustered	gi\|1953348589\|ref\|XM_038438118.1\|	9615	g14055	i0	100	16	30	0	17	0	1	30	536	565	PREDICTED: Canis lupus familiaris keratin 7 (KRT7), mRNA	blastn	2880	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Carnivora	Canidae	Canis	Canis lupus
3261430	3261430	PRJNA721440_S_NODE_11483_length_195_cov_1.349315_g11357_i0	PRJNA721440	11483	195	1.349315	2.63116425	Branchiostoma lanceolatum	7740	Chordata	Chordata	56.5	0.001	NTclustered	gi\|2770778191\|ref\|XR_010755858.1\|	7740	g11357	i0	100	0.153846153846154	30	0	15	0	2	31	212	241	PREDICTED: Branchiostoma lanceolatum uncharacterized lncRNA (LOC136435533), transcript variant X2, ncRNA	blastn	30	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Leptocardii	Amphioxiformes	Branchiostomatidae	Branchiostoma	Branchiostoma lanceolatum
3261466	3261466	PRJNA721440_S_NODE_4223_length_284_cov_8.753191_g4097_i0	PRJNA721440	4223	284	8.753191	24.85906244	Vicugna pacos	30538	Chordata	Chordata	52.8	0.026	NTclustered	gi\|1777469384\|ref\|XR_004190006.1\|	30538	g4097	i0	100	0.0985915492957746	28	0	10	0	242	269	689	716	PREDICTED: Vicugna pacos uncharacterized LOC116280604 (LOC116280604), ncRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Artiodactyla	Camelidae	Vicugna	Vicugna pacos
4538558	4538558	PRJNA721440_S_NODE_6984_length_234_cov_1.135135_g6858_i0	PRJNA721440	6984	234	1.135135	2.6562159	Mus caroli	10089	Chordata	Chordata	56.5	0.002	NTclustered	gi\|1679855561\|ref\|XM_029480371.1\|	10089	g6858	i0	100	0.256410256410256	30	0	13	0	44	73	1858	1887	PREDICTED: Mus caroli CYLD lysine 63 deubiquitinase (Cyld), transcript variant X2, mRNA	blastn	60	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus caroli
5021912	5021912	PRJNA721440_S_NODE_14664_length_178_cov_1.496124_g14538_i0	PRJNA721440	14664	178	1.496124	2.66310072	Cheloniidae	8465	Chordata	Chordata	56.5	0.001	NTclustered	gi\|2911444060\|emb\|OZ223572.1\|	8472	g14538	i0	96.97	0.370786516853933	33	1	19	0	40	72	50290553	50290521	Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 14	blastn	66	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Cheloniidae	Lepidochelys	Lepidochelys kempii
6297668	6297668	PRJNA721440_S_NODE_12545_length_188_cov_2.741007_g12419_i0	PRJNA721440	12545	188	2.741007	5.15309316	Cheloniidae	8465	Chordata	Chordata	52.8	0.016	NTclustered	gi\|2911500576\|emb\|OZ223607.1\|	8472	g12419	i0	100	0.446808510638298	28	0	15	0	160	187	10181252	10181279	Lepidochelys kempii isolate rLepKem1 genome assembly, chromosome: 21	blastn	84	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata		Testudines	Cheloniidae	Lepidochelys	Lepidochelys kempii
9638644	9638644	PRJNA721440_S_NODE_8768_length_214_cov_7.303030_g8642_i0	PRJNA721440	8768	214	7.30303	15.6284842	Lethenteron reissneri	7753	Chordata	Chordata	52.8	0.019	NTclustered	gi\|2635868064\|ref\|XM_061564883.1\|	7753	g8642	i0	100	0.261682242990654	28	0	13	0	169	196	8124	8097	PREDICTED: Lethenteron reissneri DNA replication helicase/nuclease 2 (DNA2), transcript variant X2, mRNA	blastn	56	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lethenteron	Lethenteron reissneri
14739197	14739197	PRJNA721440_S_NODE_4052_length_289_cov_2.620833_g3926_i0	PRJNA721440	4052	289	2.620833	7.57420737	Columba livia	8932	Chordata	Chordata	52.8	0.027	NTclustered	gi\|2728280758\|ref\|XR_010469264.1\|	8932	g3926	i0	100	0.0968858131487889	28	0	10	0	23	50	699	726	PREDICTED: Columba livia uncharacterized LOC135577459 (LOC135577459), ncRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Columbiformes	Columbidae	Columba	Columba livia
17771368	17771368	PRJNA721440_S_NODE_20714_length_158_cov_2.385321_g20588_i0	PRJNA721440	20714	158	2.385321	3.76880718	Chordata	7711	Chordata	Chordata	52.8	0.013	NTclustered	gi\|471371046\|ref\|XM_004375975.1\|	127582	g20588	i0	100	17.8987341772152	28	0	18	0	1	28	4477	4450	PREDICTED: Trichechus manatus latirostris myosin heavy chain 2 (LOC101340630), mRNA	blastn	2828	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Sirenia	Trichechidae	Trichechus	Trichechus manatus
19837078	19837078	PRJNA721440_S_NODE_16556_length_170_cov_1.909091_g16430_i0	PRJNA721440	16556	170	1.909091	3.2454547	Apteryx mantelli	2696672	Chordata	Chordata	56.5	0.001	NTclustered	gi\|840012498\|emb\|LK064798.1\|	202946	g16430	i0	94.595	0.217647058823529	37	1	22	1	111	147	2031377	2031342	Apteryx australis mantelli genome assembly AptMant0, scaffold scaffold221	blastn	37	56.5	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Aves	Apterygiformes	Apterygidae	Apteryx	Apteryx mantelli
22387601	22387601	PRJNA721440_S_NODE_7738_length_225_cov_1.159091_g7612_i0	PRJNA721440	7738	225	1.159091	2.60795475	Xenopus laevis	8355	Chordata	Chordata	52.8	0.02	NTclustered	gi\|2038222965\|ref\|XM_041565031.1\|	8355	g7612	i0	100	2.11555555555556	28	0	12	0	75	102	5290	5263	PREDICTED: Xenopus laevis myelin transcription factor 1-like protein (LOC108718228), transcript variant X5, mRNA	blastn	476	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Amphibia	Anura	Pipidae	Xenopus	Xenopus laevis
23663208	23663208	PRJNA721440_S_NODE_3399_length_309_cov_8.315385_g3273_i0	PRJNA721440	3399	309	8.315385	25.69453965	Mus musculus	10090	Chordata	Chordata	54.7	0.008	NTclustered	gi\|71533340\|gb\|AC156162.2\|	10090	g3273	i0	100	0.0938511326860841	29	0	9	0	116	144	100783	100755	Mus musculus BAC clone RP24-342A17 from chromosome 9, complete sequence	blastn	29	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Rodentia	Muridae	Mus	Mus musculus
23663221	23663221	PRJNA721440_S_NODE_9139_length_211_cov_2.703704_g9013_i0	PRJNA721440	9139	211	2.703704	5.70481544	Dasypus novemcinctus	9361	Chordata	Chordata	52.8	0.019	NTclustered	gi\|2905733595\|ref\|XM_058306754.2\|	9361	g9013	i0	100	0.132701421800948	28	0	13	0	136	163	3653	3626	PREDICTED: Dasypus novemcinctus tubulin folding cofactor C (TBCC), mRNA	blastn	28	52.8	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Cingulata	Dasypodidae	Dasypus	Dasypus novemcinctus
24145173	24145173	PRJNA721440_S_NODE_18819_length_164_cov_2.695652_g18693_i0	PRJNA721440	18819	164	2.695652	4.42086928	Lampetra	13103	Chordata	Chordata	54.7	0.004	NTclustered	gi\|2805715757\|emb\|OZ078416.1\|	7748	g18693	i0	96.97	0.603658536585366	33	0	20	1	77	108	14414972	14414940	Lampetra fluviatilis genome assembly, chromosome: 13	blastn	99	54.7	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Hyperoartia	Petromyzontiformes	Petromyzontidae	Lampetra	Lampetra fluviatilis
24145177	24145177	PRJNA721440_S_NODE_20999_length_156_cov_8.485981_g20873_i0	PRJNA721440	20999	156	8.485981	13.23813036	Eukaryota	2759	unresolved_Eukaryota	other_Eukaryota	91.6	2.72e-14	NTclustered	gi\|2328051338\|ref\|XR_007951560.1\|	38775	g20873	i0	84.375	23.9487179487179	96	12	62	3	54	149	3603	3695	PREDICTED: Antechinus flavipes 28S ribosomal RNA (LOC127552708), rRNA	blastn	3736	91.6	1	Eukaryota	Opisthokonta	Metazoa	Chordata	Mammalia	Dasyuromorphia	Dasyuridae	Antechinus	Antechinus flavipes

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