contig_metadata
14 rows where bioproject = "PRJNA492406" and tax_kingdom = "Pararnavirae"
This data as json, CSV (advanced)
| Link | rowid ▼ | query | bioproject | node | length | coverage | rel_abundance | taxname_lca | taxid_lca | taxoncategory | taxoncategorysimple | bits | evalue | lowcoverage_flag | 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 |
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 3002986 | 3002986 | PRJNA492406_P_NODE_13423_length_342_cov_1.144981_g13124_i0 | PRJNA492406 | 13423 | 342 | 1.144981 | 3.91583502 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 610 | 4.25e-170 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g13124 | i0 | 98.83 | 3.83625730994152 | 342 | 4 | 100 | 0 | 1 | 342 | 3600 | 3259 | Squirrel monkey retrovirus, complete genome | blastn | 1312 | 610 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 3003360 | 3003360 | PRJNA492406_P_NODE_3103_length_684_cov_1.700491_g2814_i0 | PRJNA492406 | 3103 | 684 | 1.700491 | 11.63135844 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 1206 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g2814 | i0 | 98.536 | 3.99415204678363 | 683 | 10 | 99 | 0 | 2 | 684 | 7153 | 6471 | Squirrel monkey retrovirus, complete genome | blastn | 2732 | 1206 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 4927392 | 4927392 | PRJNA492406_P_NODE_24244_length_262_cov_1.597884_g23945_i0 | PRJNA492406 | 24244 | 262 | 1.597884 | 4.18645608 | root | 1 | Root_unresolved | Root_unresolved | 468 | 1.9999999999999996e-127 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g23945 | i0 | 98.855 | 46.9083969465649 | 262 | 3 | 100 | 0 | 1 | 262 | 2235 | 1974 | Moloney murine leukemia virus, complete genome | blastn | 12290 | 468 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 6830404 | 6830404 | PRJNA492406_P_NODE_8686_length_414_cov_2.258065_g8387_i0 | PRJNA492406 | 8686 | 414 | 2.258065 | 9.3483891 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 737 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g8387 | i0 | 99.027 | 4.95410628019324 | 411 | 4 | 99 | 0 | 4 | 414 | 7946 | 7536 | Squirrel monkey retrovirus, complete genome | blastn | 2051 | 737 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 10027572 | 10027572 | PRJNA492406_P_NODE_3108_length_683_cov_2.204918_g2819_i0 | PRJNA492406 | 3108 | 683 | 2.204918 | 15.05958994 | root | 1 | Root_unresolved | Root_unresolved | 1256 | 0 | NTclustered | gi|2088546|gb|U87552.1|MLU87552 | 11786 | g2819 | i0 | 99.854 | 90.4802342606149 | 683 | 1 | 100 | 0 | 1 | 683 | 740 | 58 | Murine leukemia virus integrase (pol) gene, partial cds | blastn | 61798 | 1256 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 12578198 | 12578198 | PRJNA492406_P_NODE_2730_length_726_cov_1.606432_g2447_i0 | PRJNA492406 | 2730 | 726 | 1.606432 | 11.66269632 | root | 1 | Root_unresolved | Root_unresolved | 1341 | 0 | NTclustered | gi|1431162561|gb|EU075330.2| | 11786 | g2447 | i0 | 100 | 96.435261707989 | 726 | 0 | 100 | 0 | 1 | 726 | 4583 | 3858 | Mutant Murine leukemia virus clone 4-6w_c7 gag-pro-pol polyprotein gene, complete cds | blastn | 70012 | 1341 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 15127296 | 15127296 | PRJNA492406_P_NODE_27372_length_250_cov_0.870056_g27073_i0 | PRJNA492406 | 27372 | 250 | 0.870056 | 2.17514 | root | 1 | Root_unresolved | Root_unresolved | 457 | 4.1099999999999985e-124 | NTclustered | gi|332027|gb|M33469.1|MLVENVC | 11786 | g27073 | i0 | 99.6 | 8 | 250 | 1 | 100 | 0 | 1 | 250 | 1250 | 1001 | 4070A Amphotropic Murine leukemia virus envelope gene, complete cds | blastn | 2000 | 457 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 17676980 | 17676980 | PRJNA492406_P_NODE_4914_length_540_cov_1.985011_g4619_i0 | PRJNA492406 | 4914 | 540 | 1.985011 | 10.7190594 | root | 1 | Root_unresolved | Root_unresolved | 992 | 0 | NTclustered | gi|1173658|gb|U36602.1|MLU36602 | 11786 | g4619 | i0 | 99.815 | 7.95555555555556 | 540 | 1 | 100 | 0 | 1 | 540 | 1298 | 759 | Murine leukemia virus gPr80 envelope polyprotein precursor (env) mRNA, complete cds | blastn | 4296 | 992 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 19578729 | 19578729 | PRJNA492406_P_NODE_9936_length_390_cov_1.940063_g9637_i0 | PRJNA492406 | 9936 | 390 | 1.940063 | 7.5662457 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 676 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g9637 | i0 | 97.949 | 4.08717948717949 | 390 | 8 | 100 | 0 | 1 | 390 | 3625 | 4014 | Squirrel monkey retrovirus, complete genome | blastn | 1594 | 676 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 20854387 | 20854387 | PRJNA492406_P_NODE_4497_length_563_cov_2.810204_g4202_i0 | PRJNA492406 | 4497 | 563 | 2.810204 | 15.82144852 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 1040 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g4202 | i0 | 100 | 4.25399644760213 | 563 | 0 | 100 | 0 | 1 | 563 | 1740 | 2302 | Squirrel monkey retrovirus, complete genome | blastn | 2395 | 1040 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 22776362 | 22776362 | PRJNA492406_P_NODE_3178_length_674_cov_1.888519_g2888_i0 | PRJNA492406 | 3178 | 674 | 1.888519 | 12.72861806 | root | 1 | Root_unresolved | Root_unresolved | 1240 | 0 | NTclustered | gi|331934|gb|J02255.1|MLMCG | 11786 | g2888 | i0 | 99.852 | 99.433234421365 | 674 | 1 | 100 | 0 | 1 | 674 | 1907 | 1234 | Moloney murine leukemia virus, complete genome | blastn | 67018 | 1240 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Gammaretrovirus | Gammaretrovirus murleu | ||
| 22776378 | 22776378 | PRJNA492406_P_NODE_4218_length_585_cov_1.404297_g3924_i0 | PRJNA492406 | 4218 | 585 | 1.404297 | 8.21513745 | Betaretrovirus | 140052 | Viruses | Viruses | 1053 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g3924 | i0 | 99.145 | 3.53675213675214 | 585 | 5 | 100 | 0 | 1 | 585 | 2543 | 3127 | Squirrel monkey retrovirus, complete genome | blastn | 2069 | 1053 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 23405076 | 23405076 | PRJNA492406_P_NODE_6659_length_467_cov_1.390863_g6360_i0 | PRJNA492406 | 6659 | 467 | 1.390863 | 6.49533021 | Betaretrovirus squmon | 3427297 | Viruses | Viruses | 835 | 0 | NTclustered | gi|1666023499|gb|MK561030.1| | 11856 | g6360 | i0 | 98.929 | 8.24197002141328 | 467 | 5 | 100 | 0 | 1 | 467 | 8567 | 8101 | Squirrel monkey retrovirus, complete genome | blastn | 3849 | 835 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon | ||
| 24051103 | 24051103 | PRJNA492406_P_NODE_19399_length_286_cov_1.582160_g19100_i0 | PRJNA492406 | 19399 | 286 | 1.58216 | 4.5249776 | Betaretrovirus | 140052 | Viruses | Viruses | 518 | 2.17e-142 | NTclustered | gi|9627014|ref|NC_001514.1| | 11856 | g19100 | i0 | 99.301 | 3.72377622377622 | 286 | 2 | 100 | 0 | 1 | 286 | 4684 | 4399 | Squirrel monkey retrovirus - HLB, complete genome | blastn | 1065 | 518 | 1 | Viruses | Pararnavirae | Artverviricota | Revtraviricetes | Ortervirales | Retroviridae | Betaretrovirus | Betaretrovirus squmon |
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);;